Error on Tutorial "How to Process Data with Apache Hive" - Cannot load data into Hive tables

[#1]

Problem loading data to table in this tutorial

http://hortonworks.com/hadoop-tutorial/how-to-process-data-with-apache-hive/

This command

<code>LOAD DATA INPATH '/user/admin/Batting.csv' OVERWRITE INTO TABLE temp_batting;

produces error

H110 Unable to submit statement. Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [admin] does not have [READ] privilege on [hdfs://sandbox.hortonworks.com:8020/user/admin/elecMonthly_Orc] [ERROR_STATUS]

I created both user/admin and temp/admin folders. I used hdfs superuser to make admin owner of file, folder, and even parent folder. I gave full permissions in HDFS. and this is clearly shown in Ambari. Error persists.

Can anyone help? Thanks

[#2]

@Aidan Condron

Can you please take a screenshot of the output of

hdfs dfs -ls /user/admin/elecMonthly_Orc

[#3]

@Aidan Condron what user are you running the Hive Statement as?

[#4]

Thanks Andrew. Think it was discongruity between Hive account running statement and Admin owing file. Thanks for this and sorry for delay in reply.

[#5]

@Aidan Condron Is it resolved?

[#6]

@Aidan Condron accept best answer below

[#7]

Are you using the latest sandbox? Try the Ambari Hive view, it has the Upload File action specifically for csv files.

[#8]

Thanks for answering so quickly!

[#9]

@Aidan Condron what about the directory about it. What's the output of:

hdfs dfs -ls /user/admin

It looks like the files are owned by the user 'Spark'. Which user is the running the Hive Statement?

[#10]

admin is running statement as per tutorial

I thought I did hdfs chown on files. Shown in Ambari as owned by admin