You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ambari.apache.org by Kaliyug Antagonist <ka...@gmail.com> on 2015/11/05 16:11:34 UTC

Confusion regarding the permissions

I just set up HDP 2.3 using Ambari 2.1.2.

I ran two sample MR programs and they seem to work fine.

Now, I uploaded a text file using the hdfs user :

[hdfs@l1031lab root]$ hdfs dfs -ls /dumphere
Found 1 items
-rw-r--r--   3 hdfs hdfs       6243 2015-11-05 16:06
/dumphere/TwitterData.txt
[hdfs@l1031lab root]$

Now I wish to do a LOAD INFILE on the hive prompt :

LOAD  DATA  INPATH  '/dumphere/TwitterData.txt' OVERWRITE INTO TABLE
TwitterExampletextexample;
Loading data to table scratchpad.twitterexampletextexample
Failed with exception Unable to move source hdfs://
l1031lab.sss.se.scania.com:8020/dumphere/TwitterData.txt to destination
hdfs://
l1031lab.sss.se.scania.com:8020/apps/hive/warehouse/scratchpad.db/twitterexampletextexample/TwitterData.txt
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.MoveTask

I assume this is a permissions issue, am I right ?

If yes, I am confused with the way I should get data into Hive. I have
several files(csv, txt etc.) which I will load on HDFS and then create Hive
tables. How do I proceed ?