[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

@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

@ARP  try increasing fs.s3a.connection.maximum to 1500 and follow this doc for the fine S3 tuning parameters.   https://docs.cloudera.com/documentation/enterprise/latest/topics/admin_hive_on_s3_tuning.html ... 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

@kevinmat0510  Hive 3 architecture is changed to support ACID v2 and Hive 3 buckets generation is automatic which splits data implicitly.   https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.5/using-hiveql/content/hive_3_internals.html   You can't disable  the generation of buckets, it's a complete architecture change of Hive 3 and refer the Hive 3 ACID support details in the document.   Thanks, Prakash  ... 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

@shrimaha It looks like you're using wrong jdbc connection string to connect to Hive, could you please check your connection string details once.   https://community.cloudera.com/t5/Community-Articles/Working-with-Beeline/ta-p/247606   https://docs.cloudera.com/HDPDocuments/HDP2/HDP-2.6.5/bk_data-access/content/beeline-vs-hive-cli.html   Thanks, Prakash ... View more