HIVE> FAILED: SemanticException Line 1:23 Wrong Way

Question

I'm tired of loading data into my “users” in LOCAL mode, and I use cloudera in my virtual box. I have a file placed my file inside / home / cloudera / Desktop / Hive / but I get an error

FAILED: SemanticException Line 1:23 Invalid path ''/home/cloudera/Desktop/Hive/hive_input.txt'': No files matching path file:/home/cloudera/Desktop/Hive/hive_input.txt

My syntax for loading data into a table

Load DATA LOCAL INPATH '/home/cloudera/Desktop/Hive/hive_input.txt' INTO Table users

Answer 1

Yes, I deleted Local according to @Bhaskar, and the path is my HDFS path where the file exists, not the Linux path.

Load DATA INPATH '/user/cloudera/input_project/' INTO Table users;

Answer 2

You must change the permission for the folder containing your file.

chmod -R 755 /home/user/

Answer 3

. CLI user01 ( INPATH) user02, .

So the solution could be 1. Move the file to a folder where user01 can access the file. OR 2. Restart the Hive CLI after logging in with user02.