https://community.cloudera.com/t5/Support-Questions/Fail-to-load-data-from-HDFS-into-Apachi-Hive/m-p/314797#M226195 <P>Hi All,</P><P>After I tried to load data from a file in HDFS into Hive, I ran into a permission error as show below. Could you please help to let me know what I did wrong?&nbsp;</P><P>Thank you,&nbsp;</P><P>&nbsp;</P><P>1) I uploaded a csv file: EMP.csv from my laptop into HDFS folder: /user/admin using admin credential.</P><P>2) I use Data Analytic studio to load the csv file into an external table in Hive using the code below:</P><P>CREATE EXTERNAL TABLE IF NOT EXISTS emp(<BR />EmployeeID STRING,<BR />FirstName STRING,<BR />LastName STRING,<BR />Email STRING,<BR />PhoneNumber STRING,<BR />HireDate STRING,<BR />JobID STRING,<BR />Salary STRING,<BR />ManagerID STRING,<BR />DepartmentID STRING<BR />)<BR />COMMENT 'My first Hive table'<BR />ROW FORMAT DELIMITED FIELDS TERMINATED BY ','<BR />STORED AS TEXTFILE<BR />LOCATION '/user/admin/EMP.csv'<BR />;</P><P>&nbsp;</P><P>Here is the error:</P><P>"org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [hive] does not have [ALL] privilege on [hdfs://sandbox-hdp.hortonworks.com:8020/user/admin/EMP.csv]"</P> Sat, 17 Apr 2021 00:15:13 GMT TDStephanieSoft 2021-04-17T00:15:13Z