Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive action error while loading table . Showing invalis path error.

Hive action error while loading table . Showing invalis path error.

Explorer

Hi,
I created hive query script and loading vua oozi.
If I execute the Hive query script through command line , it runs fine.
But when I am loading through Oozi hive action ,
The table is getting created fine.
The next statement I have is load which errors out.

load data inpath '${Input_file}' into table test.employee;

This path I am sending from job.properties file as

 

InputDir= ${nameNode}/user/data/emp

 

Workflow xml has the input file

<param>Input_file=${InputDir}/hive_emphdfs.txt</param>

 

Now when I see describe extended table it shows.
location:hdfs://quickstart.cloudera:8020/user/hive/warehouse/test.db/employee

instead of hdfs://localhost:8020/user/hive/warehouse/test.db/employee

 

I have hive-site.xml and hive-default.xml in same loaction as workflow.xml file.

 

When I am running my script through oozi,

 

I am getting following error.
FAILED: SemanticException [Error 10028]: Line 3:17 Path is not legal ''hdfs://localhost:8020/user/data/emp/hive_emphdfs.txt'': Move from: hdfs://localhost:8020/user/data/emp/hive_emphdfs.txt to: hdfs://quickstart.cloudera:8020/user/hive/warehouse/test.db/employee is not valid. Please check that values for params "default.fs.name" and "hive.metastore.warehouse.dir" do not conflict.
Intercepting System.exit(10028)
Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.HiveMain], exit code [10028]


What should I to resolve it.

Thanks

2 REPLIES 2

Re: Hive action error while loading table . Showing invalis path error.

Contributor

Hi,

 

Please check your workflow's "job.properties" file, the "nameNode" value should be in format "hdfs://ha-nameservice" (if NameNode HA enabled) or "hdfs://namenode-host:8020" (if there is no NameNode HA). Although your cluster is most probably contains one host only (you use Cloudera quickstart image), the "localhost:8020" would not resolve properly to the NameNode from everywhere.

As the error message said, can you also double-check the values "default.fs.name" and "hive.metastore.warehouse.dir" from Cloudera Manager? What are their values?

 

Regards

 Miklos Szurap

Customer Operations Engineer at Cloudera

Re: Hive action error while loading table . Showing invalis path error.

Explorer

Hi,

   When I am opening the cloudera manager  it does not open. It tells me connecting to Cloudera Manager. I am having my laptop with only 8 gb in total.

  For the time being I chnaged the job.properties file to set the name node and Job Tracker as

 

nameNode=hdfs://quickstart.cloudera:8020
jobTracker=quickstart.cloudera:8032

 

It solved my issue

 

 

 

Don't have an account?
Coming from Hortonworks? Activate your account here