Hive Access Denied issue

Question

Access denied on my Hive, can anyone help?

Answer 1

You must run the below command on terminal to fix it.

# sudo -u hdfs hadoop fs -mkdir /user/hive/warehouse

# sudo -u hdfs hadoop fs -chmod g+w /tmp

# sudo -u hdfs hadoop fs -chmod g+w /user/hive/warehouse

# sudo -u hdfs hadoop fs -chown -R training /user/hive/warehouse

# sudo chmod 777 /var/lib/hive/metastore

# cd /var/lib/hive/metastore/metastore_db/

# sudo rm *.lck

# cd

# hive