Created 07-20-2016 04:50 AM
When I am trying to access my hive databases from Hive View, am getting above error.
Does anyone has any idea about this that why we get such error from hive view ?
I think you have logged in as admin and trying to do operations, Refer Link and create hdfs directory for admin and give appropriately permissions . It will works
su - hdfs
hadoop fs -mkdir /user/admin
hadoop fs -chown admin:hadoop /user/admin
I have the same problem and when i've done all the steps as previously mentioned above I still get permissions denied. Can someone help me please?
INSERT OVERWRITE DIRECTORY "hdfs://sandbox-hdp.hortonworks.com/tmp/hey2" SELECT * FROM mytable;