topic Re: tSqoopImport error with Java API option in Talend Studio

tSqoopImport error with Java API option

Anonymous — Sat, 16 Nov 2024 11:22:54 GMT

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!

Re: tSqoopImport error with Java API option

Anonymous — Tue, 23 Dec 2014 03:45:57 GMT

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/85986?
Best regards
Sabrina

Re: tSqoopImport error with Java API option

Anonymous — Tue, 23 Dec 2014 14:37:06 GMT

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.NoSuchMethodErrorrg.apache.hadoop.hive.shims.HadoopShims.getHadoopConfNames()Ljava/util/Map;

Re: tSqoopImport error with Java API option

_AnonymousUser — Thu, 02 Jul 2015 03:05:35 GMT

Did anybody figured that out...