Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

load data local not working in beeline

Highlighted

load data local not working in beeline

Master Collaborator

with hive it works but if I use beeline I get the error file not found.

$ ls -ltr /home/a.txt
-rwxrwxrwx 1  domain users 9 Oct 22 15:54 /home/a.txt
$ cat /home/a.txt
1
2
3
4
0: jdbc:hive2://node1.us.com> create table a(id int);
No rows affected (0.183 seconds)
0: jdbc:hive2://node1.us.com> load data local inpath '/home/a.txt' into table a;
Error: Error while compiling statement: FAILED: SemanticException Line 1:23 Invalid path ''/home/a.txt'': No files matching path file:/home/a.txt (state=42000,code=40000)
0: jdbc:hive2://node1.us.com>

Don't have an account?
Coming from Hortonworks? Activate your account here