You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by Yagyank Chadha <ya...@gmail.com> on 2016/04/04 11:48:22 UTC

Hive permission issues with hadoop hdfs

Hi all,

I have installed hive over hadoop and ran the following commands

*hive> CREATE SCHEMA userdb; OK Time taken: 0.305 seconds hive> CREATE
TABLE emp ( eid Int, name String); OK Time taken: 1.247 seconds hive> LOAD
DATA LOCAL INPATH '/home/hduser/sample.txt' OVERWRITE INTO TABLE emp;
Loading data to table default.emp Failed with exception Unable to move
source file:/home/hduser/sample.txt to destination
hdfs://localhost:54310/user/hive/warehouse/emp/sample.txt FAILED: Execution
Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask*

when I run

*hdfs dfs -ls /user/hive/warehouse*

I get

*Found 5 items drwxrwxr-x - root supergroup 0 2016-04-04 15:00
/user/hive/warehouse/emp drwxrwxr-x - root supergroup 0 2016-04-04 14:40
/user/hive/warehouse/kylin_cal_dt drwxrwxr-x - root supergroup 0 2016-04-04
14:40 /user/hive/warehouse/kylin_category_groupings drwxrwxr-x - root
supergroup 0 2016-04-04 14:40 /user/hive/warehouse/kylin_sales drwxrwxr-x -
root supergroup 0 2016-04-04 14:52 /user/hive/warehouse/userdb.db*

and when I run

*hdfs dfs -ls /user/hive/warehouse/emp*

I get

*-rw-r--r-- 1 root supergroup 0 2016-04-04 15:00
/user/hive/warehouse/emp/sample.txt*

but i have already done

*hdfs dfs -chmod 777 /user/hive/warehouse/emp*

Still I am not able to access hdfs through Hive.

I am executing all commands as root


-- 
Regards
*Yagyank chadha*

*Undergraduate student*
*Computer Science Engineering*
*Thapar University, Patiala*