Support Questions
Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

load data local inpath not working in HDP3

Expert Contributor


We are using HDP 3 in our environment. we are trying to load data from Local into using LOAD DATA LOCAL INPATH but we are getting error No path found. While if we load file to HDFS and then LOAD DATA INPATH to table it is successfully.

Is LOAD DATA from locally has been removed in HDP3?


Cloudera Employee

Hi @Vinay

1)Kindly check whether you have mentioned the path correctly.

2) Try running the query in the host where HS2 is running. If you get any permission error or No files found error kindly add this property "" in Custom hiveserver2-site via ambari and try running LOAD DATA query as hive user. I think this will work for you.

Please accept this answer if you found it helpful.