I recently downloaded HDP 2.2 and facing issues with hive configuration. Every time I login to Ambari/Hue after first use, i get permission denied error. I tried up changing hdfs permissions,few basics authorizations setting in hive conf, grant access through CLI, but nothing works. Please assist
@dhawal shah Can you share the exact error message, log snippet or a screen snapshot? It is hard to say whats going on without more information..
Also, moving the question to Data Processing category.
This works fine.
However, whenever i access hive through Ambari/Beeline i get access denied error. It happens whenever i import appliance and login second time.
Tried Grant commands as well.
Attached logs with error messages. hue-logs-145018895474.ziphue-logs-145018895474.zip
Just under your nose the permission issue for the user hdfs once that corrected you will be good to go !
Check the file permissions and owner of the Hive installation.
Processing exception: Error occurred executing hive query: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [hdfs] does not have [USE] privilege on [default]: Traceback (most recent call last):
Either use the chown -R user:group /hive_install_dir *
or su to the owner of the /hive_install_dir and retry