Sorry, have been busy. I will have a look and provide you an update by tomorrow. ... View more

Another test you can do is below: 1. start HiveMetaStore server: hive --service metastore & 2. start HiveServer2 server: hiveserver2 & 3. start beeline: beeline -u 'jdbc:hive2://localhost:10000/default' -n hive 4. run the SELECT query to see if it fails the same way 5. if still failed, check the HiveServer2 server log file, which is defined under /home/hduser/Softwares/apache-hive-2.0.1-bin/conf/hive-log4j2.properties file with the following properties: property.hive.log.dir property.hive.log.file Check the error there. ... View more

Can you try again by starting Hive CLI using debug mode: hive --hiveconf hive.root.logger=DEBUG,console And then run the query that failed: select count(1) from order_items; Please copy and paste the output after you run SELECT query here for review. Thanks ... View more

hmm, I can see file /home/hduser/Softwares/apache-hive-2.0.1-bin/lib/hive-exec-2.0.1.jar is loaded in Hive CLI already, it is hard to figure out without looking at the issue live, but I have a couple of other questions: - when did job fail, did it fail before MR was launched or after? If after, was the mapper or reducer failed? - have you tried to use beeline (need to start HiveServer2) to see if it also fails there? - how many nodes do you have in the cluster? is it just one? ... View more

the PID for CliDriver is 29018, please run strings /proc/29018/environ instead. ... View more

Can you please perform the following: 1. start hive CLI: hive 2. on another shell window, type in the following command: ps aux | grep CliDriver and note down the PID of hive CLI 3. run command: strings /proc/<hive-cli-PID>/environ Then copy and paste the outputs here for me to have a look. Thanks ... View more

Hmm, this is strange that you don't get the following output like I have: 17/03/29 07:20:04 [6af15552-8d3f-43a2-8d6e-5e2c03fc2d80 main]: DEBUG CliDriver: CliDriver inited with classpath /opt/hive/conf:/opt/hive/lib/accumulo-core-1.6.0.jar:/opt/hive/lib/accumulo-fate-1.6.0.jar:/opt/hive/lib/accumulo-start-1.6.0.jar:/opt/hive/lib/accumulo-trace-1.6.0.jar:/opt/hive/lib/activation-1.1.jar:/opt/hive/lib/aether-api-0.9.0.M2.jar.... I was expecting this so that I can check for the list of JAR files loaded by Hive CLI. I might need to use the downloaded version as yours, coz my version is built from Hive source code. Not too sure why at this stage. ... View more

the .bashrc looks all right, please run below command: hive --hiveconf hive.root.logger=DEBUG,console and then copy and paste the output here for review. ... View more

I just downloaded the apache-hive-2.0.1-bin version and I can see it is under $HIVE_HOME/lib/hive-exec-2.0.1.jar Have you setup $HIVE_HOME correctly? How did you install Hadoop and Hive? Where are the locations? ... View more

Hi, I have checked, class org.apache.hadoop.hive.io.HdfsUtils$HadoopFileStatus.class should be located under $HIVE_HOME/lib/hive-exec-2.2.0-SNAPSHOT.jar, the version number might be different, can you please make sure that it exist? Did you install hadoop and hive tarballs manually? ... View more