Support Questions
Find answers, ask questions, and share your expertise

load data local inpath not working in HDP3

Highlighted

load data local inpath not working in HDP3

Expert Contributor

Hi,

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?

1 REPLY 1

Re: load data local inpath not working 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 "hive.users.in.admin.role=hive" 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.