A problem with tSqoopImport and hive

Anonymous — Sat, 16 Nov 2024 04:15:25 GMT

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:

"hive.import" = "TRUE";
"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.

Re: A problem with tSqoopImport and hive

Anonymous — Mon, 28 Oct 2019 15:06:30 GMT

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

topic Re: A problem with tSqoopImport and hive in Talend Studio

A problem with tSqoopImport and hive

Re: A problem with tSqoopImport and hive