Unable to load from file to Hive table

Lab Support
#1

I am getting below error while trying to load a file to Hive table.

SemanticException Line 1:23 Invalid path ‘’/user/sruthi52049811/airlines_data.csv’’: No files matching path file:/user/sruthi52049811/airlines_data.csv

I tried both with and without LOCAL inpath.

#2

Hi @dustpurple,

Can you please paste your code here

Thanks

#3

I use load data inpath , it was giving error earlier but now its working. Table got loaded but all values are NULL. Table i created is airline_tb, file I used to load it is located at user/sruthi52049811/airlines_data.csv
Schema of the table and file layout are same

#4

Can anyone please help me to find why is it loading all NULL to hive table when the file has data