"none of the solutions from the internet are helping" 🙄. So I asked what binaries? ... View more

Dennis, Thanks for your kind answer, but -> I'm not a company, I'm a person trying to use open source software to learn and contribute like anyone else ... if Cloudera claims that his software is open source so why an agreement is needed? It shouldn't, it defeats completely the purpose. I'm not signing any "agreements", either the code is free on NOT, as simple as that!! If NOT, then just say so ... Stop using "open source" as a fashion flag, this will simply diminish the real coders that produce and put their code available REALLY FOR FREE!! If Cloudera got the free code available and built upon on and now wants to sell it, OK, I have no problem with that, but DONT say it is opne source, because it isn't if you charge for it ...  Sorry, but this is so obvious to me ... am I so blind, dumb or missing anything here? ... View more

[hdfs@c****-node* hive-testbench-hive14]$ ./tpcds-build.sh  Building TPC-DS Data Generator make: Nothing to be done for `all’. TPC-DS Data Generator built, you can now use tpcds-setup.sh to generate data. [hdfs@c4237-node2 hive-testbench-hive14]$ ./tpcds-setup.sh 2 TPC-DS text data generation complete. Loading text data into external tables. make: *** [time_dim] Error 1 make: *** Waiting for unfinished jobs.... make: *** [date_dim] Error 1 Data loaded into database tpcds_bin_partitioned_orc_2.   INFO : OK +---------------------+ | database_name | +---------------------+ | default | | information_schema | | sys | +---------------------+ 3 rows selected (1.955 seconds) 0: jdbc:hive2://c4237-node2.coelab.cloudera.c> tpcds_bin_partitioned_orc_2 database is not created, I have some issues in testing the tpcds queries   sudo -u hdfs -s    13  cd /home/hdfs    14  wget https://github.com/hortonworks/hive-testbench/archive/hive14.zip     15  unzip hive14.zip   17  export JAVA_HOME=/usr/jdk64/jdk1.8.0_77    18  export PATH=$JAVA_HOME/bin:$PATH ./tpcds-build.sh beeline -i testbench.settings -u "jdbc:hive2://c****-node9.coe***.*****.com:10500/tpcds_bin_partitioned_orc_2"   I'm not able to test the tpcds queries, any help would be appreciated. ... View more

The Issue was due postgresql jdbc jar whcih comes with Cdh was not latest .   I had manually downloaded the latest jars and replaced the old ones and then the issue was resolved . Thanks for the help !!! ... View more

@ARP  There is a bug https://issues.apache.org/jira/browse/HIVE-24693    Kindly use this work around properties and test your jobs.   set hive.parquet.timestamp.time.unit=nanos; set hive.parquet.write.int64.timestamp=true; ... View more

@bigdataNico  Kindly run hdfs dfs -rmr /user/hive/.yarn/package/LLAP/* and restart the LLAP. ... View more

You have to delete the files from HDFS use this command::hdfs dfs -rm -rf /user/hive/.yarn/package/LLAP   After the deleting run the below commands::   hdfs dfs -mkdir -p /user/hive/.yarn/package/LLAP hdfs dfs -chown hive:hadoop /user/hive/.yarn/package/LLAP hdfs dfs -chmod 755 /user/hive/.yarn/package/LLAP   Restart the Hiveserver2 after executing these commands. ... View more

@kevinmat0510  You have to delete the files from HDFS use this command::hdfs dfs -rm -rf /user/hive/.yarn/package/LLAP   ... View more

@linzhongwei   Relevant bug::https://issues.apache.org/jira/browse/HIVE-23111 ... View more

@AnkitP  It's not able to make connection to the namenode hostname/IPaddress to hostname:8020, can you check whether you're able to perform telnet namenode-hostname 8020, in case if you're getting connection error then you need to open this port for connection.   Thanks, Prakash ... View more