uses an HDFS location for data preparation file storage. You must grant access to the absolute HDFS file path of the default database for the Hive warehouse. You must also 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 the appropriate HDFS permissions to the Hadoop impersonation user. HDFS permissions determine what a user can do to files and directories stored in HDFS. To access a file or directory, a user must have permissions or belong to a group that has permissions to the file or directory.