Getting error while loading data into hive table

Question

I am facing issues with hive table. I have created a database:

create database airport;
use airport;
create table airports_mod(airport_id INT,name string,city string,country string,iata string,icao string,latitude double,longitude double,altitude double,timezone timestamp,DST string,tz string) ROW FORMAT DELIMITED FIELDS TERMINATED BY "," STORED AS TEXTFILE;

All this works fine but when I run the below command, I get error:

load data inpath "/home/hduser/airdatasets/airports_mod.dat" into table airports_mod;
FAILED: SemanticException Line 1:17 Invalid path ""/home/hduser/airdatasets/airports_mod.dat"": No files matching path hdfs://localhost:8020/home/hduser/Airdatasets/airports_mod.dat

Comments

Do you have that file in the mentioned path? If yes, please re-check the path.

---

Yes, I checked. It is correct. Still getting error

---

Could you please share the output of the following commands?

$ ls /home/hduser

$ ls /home/hduser/airdatasets

---

$ ls /home/hduser
Airdatasets

$ ls /home/hduser/airdatasets

It says no file or directory found

Answer 1

In the command you have used, the path is /home/hduser/airdatasets/

There is no such directory. The directory name is Airdatasets but you have used airdatasets. Directories are case-sensitive. You have to use the exact same name. Try this path, it should work:

/home/hduser/Airdatasets/airports_mod.dat

Comments

Well, this is embarrassing! Such a silly mistake! Thanks, it worked