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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tSqoopImport error with Java API option

Hi,
I am using tSqoopImport component to load data into Hive directly using "hive.import">>"true" and "hive.table.name">> "sample1" options in the 'Additional Arguments'.
When I run my job, the data gets loaded into HDFS but, exit after following error:
: org.apache.sqoop.tool.ImportTool - Encountered IOException running import job: java.io.IOException: Cannot run program "hive.cmd": CreateProcess error=2, The system cannot find the file specified
I am using Cloudera VM and my below configurations are being used:
NameNode URI: "hdfs://127.0.0.1:8020"
Resource Manager: "127.0.0.1:8032" 
Please let me know if this can be fixed.
Thanks! 
Labels (3)
3 Replies
Anonymous
Not applicable
Author

Hi,
Could you please take a look at a related forum: https://community.talend.com/t5/Design-and-Development/Error-in-TOS-BD-HIVE-ELT-Step-2-Tutorial/td-p...?
Best regards
Sabrina
Anonymous
Not applicable
Author

Hi Sabrina,
Thanks for reply.
The post doesn't conclude any solution though.
I am still getting the same error. Although I have used tSqoopImport component and not any tHive component and using same ResourceManager configuration as I had mentioned in my post earlier. 
Also, what is the difference between Connection Mode as Standalone and Embedded? I tried both.
p.s. I tried running the job with tHive connection additionally but a different error though. I am using Hive version as Cloudera CDH5.1 Yarn Mode.
Error: Exception in thread "main" java.lang.NoSuchMethodError0683p000009MA5A.pngrg.apache.hadoop.hive.shims.HadoopShims.getHadoopConfNames()Ljava/util/Map;
_AnonymousUser
Specialist III
Specialist III

Did anybody figured that out...