In your cluster, check on exactly which node you have your hive service running. On that node, you will find log files at "/var/log/hive" location. ... View more

HiveServer2 and Metastore servers can be on different machines. HS2 can also be configured to get metadata via a remote Metastore server (HS2 opens a TCP client connection to Metastore server) or use an embedded Metastore server (in which case HS2 calls the Metastore Server's API directly: use hive.metastore.uris="" in hiveserver2-site.xml to achieve that). ... View more

@bleonhardi, How can I connect to Hive with a UNIX/HDFS user? Let's say I have a user named "newuser". I tried the following, but apparently I am doing something wrong. % su - newuser % beeline beeline> !connect -n newuser -p jdbc:mysql://my.host.com/hive ... View more

Step 1: cat /etc/ambari-server/conf/ambari.properties | grep ambari-server.user. Know the user from above command. Step 2: change user /var/run/ambari-server chown -R <output of above command> /var/run/ambari-server ... View more

@Swapnil Prabhu please run HDFS service check and report results. ... View more

I followed the instruction, but still getting the same error. I've checked directory and it looks good: [hdfs@c6402 ~]$ hadoop fs -ls /user/admin/ Found 4 items drwxrwxrwx - admin hadoop 0 2016-06-28 17:27 /user/admin/.Trash drwxrwxrwx - admin hadoop 0 2016-06-28 14:11 /user/admin/.staging drwxrwxrwx - admin hadoop 0 2016-06-28 14:11 /user/admin/employee_db drwxr-xr-x - admin hadoop 0 2016-06-28 19:56 /user/admin/hive Also, tried switching the group to HDFS but no luck. Any ideas? ... View more

Try to leverage search on HCC https://community.hortonworks.com/questions/153/impersonation-error-while-trying-to-access-ambari.html ... View more