HIVE> FAILED: SemanticException Line 1:23 Invalid path

Question

I tired to load the data into my table 'users' in LOCAL mode and i am using cloudera on my virtual box. I have a file placed my file inside /home/cloudera/Desktop/Hive/ directory but i am getting 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 to load data into table

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

Answer 1

Yes I removed the Local as per @Bhaskar, and path is my HDFS path where file exists not underlying linux path.

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

Answer 2

You should change permission on the folder that contains your file.

chmod -R 755 /home/user/