Here the problem is not with test_hello.txt, moreover it have 777 permission.
As i said earlier "/user/hive/warehouse/*" owned by hive:hive and sticky bit was set for that directory. So i couldn't change permissions or move data from another hdfs location to warehouse directory. Please see some of the commands which i ran to see the exact permissions and ACLs.
[kkr@myhost ~]$ hdfs dfs -ls /user
Found 1 items
drwxr-xr-x - kkr kkr 0 2019-02-06 09:58 /user/kkr
[kkr@myhost ~]$ hdfs dfs -ls /user/kkr
Found 3 items
drwx------ - kkr kkr 0 2019-02-06 15:00 /user/kkr/.Trash
drwx------ - kkr kkr 0 2019-01-30 15:20 /user/kkr/.staging
-rwxrwxrwx 3 kkr kkr 7 2019-01-16 11:33 /user/kkr/test_hello.txt
[kkr@myhost ~]$ hdfs dfs -cat /user/kkr/test_hello.txt
Hello
[kkr@myhost ~]$ hdfs dfs -ls hdfs://nameservice1/user/hive/warehouse/test.db/
Found 2 items
drwxrwx--x+ - hive hive 0 2018-08-24 16:53 hdfs://nameservice1/user/hive/warehouse/test.db/test1
drwxrwx--x+ - hive hive 0 2019-02-19 16:26 hdfs://nameservice1/user/hive/warehouse/test.db/testk
[kkr@myhost ~]$ hdfs dfs -getfacl /user/hive
# file: /user/hive
# owner: hive
# group: hive
# flags: --t
user::rwx
group::rwx
other::r-x
/////beeline//////////
0: jdbc:hive2://myhost> show databases;
+-----------------+--+
| database_name |
+-----------------+--+
| ltc |
| test |
+-----------------+--+
2 rows selected (0.181 seconds)
0: jdbc:hive2://myhost> use test;
No rows affected (0.091 seconds)
0: jdbc:hive2://myhost> show tables;
+-----------------+--+
| tab_name |
+-----------------+--+
| test1 |
+-----------------+--+
1 rows selected (0.161 seconds)
0: jdbc:hive2://myhost> CREATE TABLE IF NOT EXISTS testK (userid STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' STORED AS TEXTFILE;
INFO : OK
0: jdbc:hive2://myhost> show tables;
+-----------------+--+
| tab_name |
+-----------------+--+
| test1 |
| testk |
+-----------------+--+
2 rows selected (0.174 seconds)
0: jdbc:hive2://myhost> describe testk;
INFO : OK
+-----------+------------+----------+--+
| col_name | data_type | comment |
+-----------+------------+----------+--+
| userid | string | |
+-----------+------------+----------+--+
1 row selected (0.163 seconds)
0: jdbc:hive2://myhost> LOAD DATA INPATH 'hdfs:/user/kkr/test_hello.txt' OVERWRITE INTO TABLE testK;
.
.
INFO : Loading data to table test.testk from hdfs://nameservice1/user/kkr/test_hello.txt
ERROR : Failed with exception Access denied: Unable to move source hdfs://nameservice1/user/kkr/test_hello.txt to destination hdfs://nameservice1/user/hive/warehouse/test.db/testk/test_hello.txt: Permission denied: user=hive, access=WRITE, inode="/user/kkr":kkr:kkr:drwxr-xr-x
Remote Exception: Permission denied: user=hive, access=WRITE, inode="/user/kkr":kkr:kkr:drwxr-xr-x
.
.
INFO : org.apache.hadoop.hive.ql.metadata.HiveException: Access denied: Unable to move source hdfs://nameservice1/user/kkr/test_hello.txt to destination hdfs://nameservice1/user/hive/warehouse/test.db/testk/test_hello.txt: Permission denied: user=hive, access=WRITE, inode="/user/kkr":kkr:kkr:drwxr-xr-x
.
.
Caused by: org.apache.hadoop.security.AccessControlException: Permission denied: user=hive, access=WRITE, inode="/user/kkr":kkr:kkr:drwxr-xr-x
.
.
Caused by: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.AccessControlException): Permission denied: user=hive, access=WRITE, inode="/user/kkr":kkr:kkr:drwxr-xr-x
.
.
ERROR : FAILED: Execution Error, return code 20009 from org.apache.hadoop.hive.ql.exec.MoveTask. Access denied: Unable to move source hdfs://nameservice1/user/kkr/test_hello.txt to destination hdfs://nameservice1/user/hive/warehouse/test.db/testk/test_hello.txt: Permission denied: user=hive, access=WRITE, inode="/user/kkr":kkr:kkr:drwxr-xr-x
INFO : Completed executing command(queryId=hive_20190219165454_8fc3d09c-e085-45fd-9866-184a0699647c); Time taken: 0.046 seconds
Error: Error while processing statement: FAILED: Execution Error, return code 20009 from org.apache.hadoop.hive.ql.exec.MoveTask. Access denied: Unable to move source hdfs://nameservice1/user/kkr/test_hello.txt to destination hdfs://nameservice1/user/hive/warehouse/test.db/testk/test_hello.txt: Permission denied: user=hive, access=WRITE, inode="/user/kkr":kkr:kkr:drwxr-xr-x (state=42000,code=20009)
No rows affected (0.213 seconds)
