Your user does not have permissions to write to HDFS. Try to run the query with the user that belongs to hadoop/hdfs group. ... View more

DO you have cluster named abcdefg ? Run below command and check curl -U <username>:<password> http://<ambari-host>:<port>/api/v1/clusters ... View more

Your Connection string is : !connect jdbc:hive2://host1.com:2181,host2.com:2181,host3.com:2181;serviceDiscoveryMode=zooKeeper; zooKeeperNamespace=hiveserver2 / is missing in your connection string after zookeeper ensemble. Correct connection string is like below. !connect jdbc:hive2://host1.com:2181,host2.com:2181,host3.com:2181/;serviceDiscoveryMode=zooKeeper; zooKeeperNamespace=hiveserver2 How to avoid issues with JDBC connection string ? (works only in latest versions, tested in HDP 2.5 and HDP 2.6). 1) Go to hive in Ambari ---> Summary -----> click on left arrow button ----> connection string is copied. 2) Paste the connection string in beeline ... View more