Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

A problem with tSqoopImport and hive

Hi,

I'm currently working on Talend 6.3 and when I use the tsqoopimport
component with the Java API i get an IOException.

I'm connecting to a cloudera 5.8 cluster with this additional arguments:

  1. "hive.import" = "TRUE";
  2. "hive.table.name" = "something"

Running the job, get the following exception:

[ERROR]: org.apache.sqoop.tool.ImportTool - Encountered IOException running import job: java.io.IOException: Cannot run program "hive.cmd": CreateProcess error=2, Impossibile trovare il file specificato
	at java.lang.ProcessBuilder.start(ProcessBuilder.java:1048)
	at java.lang.Runtime.exec(Runtime.java:620)
	at java.lang.Runtime.exec(Runtime.java:528)
	at org.apache.sqoop.util.Executor.exec(Executor.java:76)
	at org.apache.sqoop.hive.HiveImport.executeExternalHiveScript(HiveImport.java:382)
	at org.apache.sqoop.hive.HiveImport.executeScript(HiveImport.java:337)
	at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:241)
	at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:524)
	at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:615)
	at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
	at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
	at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
	at 

Where am I doing wrong?

Any suggestion will be appreciated.

Thank you.

Labels (2)
1 Reply
Anonymous
Not applicable
Author

This looks like you do not have Hive installed where you are running this job OR (and possibly more likely) you do not have the hive.cmd location in your PATH variable. I would start investigating this