Grant access to the absolute HDFS file path of the default database for the hive warehouse.
Grant read and write permissions on the Hive warehouse directory. You can find the location of the warehouse directory in the hive.metastore.warehouse.dir property of the hive-site.xml file. For example, the default might be
/user/hive/warehouse
or
/apps/hive/warehouse
.
Grant permission to the Hadoop impersonation user. Optionally, you can assign -777 permissions on the directory.