Hi All, 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?  Thank you,    1) I uploaded a csv file: EMP.csv from my laptop into HDFS folder: /user/admin using admin credential. 2) I use Data Analytic studio to load the csv file into an external table in Hive using the code below: CREATE EXTERNAL TABLE IF NOT EXISTS emp( EmployeeID STRING, FirstName STRING, LastName STRING, Email STRING, PhoneNumber STRING, HireDate STRING, JobID STRING, Salary STRING, ManagerID STRING, DepartmentID STRING ) COMMENT 'My first Hive table' ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE LOCATION '/user/admin/EMP.csv' ;   Here is the error: "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]" ... View more

Hi All, I am a newbie in Apache world. After I have completed the setup of the HortonWorks sandbox, I try to activate Amari in the Advanced HDP quick link, but for some reason it activates my Apache Nifi instead of taking me to the login screen of Ambari.  I notice that the Ambari uses the same port 8080 with Nifi. Could you please help to let me know if there is a way to make the Ambari to use a different port than 8080?  ( Here is the url that was hard code in the Ambari link in Advanced HDP Quick Link.  http://sandbox-hdp.hortonworks.com:8080  ) Thanks for helping, ... View more