topic Re: A problem about sqoop in Talend Studio

A problem about sqoop

_AnonymousUser — Tue, 17 Jul 2012 11:05:13 GMT

Hi,
I have a problem about sqoop.
When I execute tsqoopimport component that show a error about
"Cannot run program "sqoop":java.io.IOException:error=2,No such file or directory"
what's wrong with sqoop,and how to specify SQOOP client dir?
I install sqoop,hadoop,TOSBD on a same server,and run sqoop-import command is ok.
Have someone help me?I need to install a JobServer?

Re: A problem about sqoop

Anonymous — Wed, 18 Jul 2012 02:59:29 GMT

Hi
Here is the code in this component.

String[] cmd_tSqoopImport_1 = new String[] { "sqoop", "import",
						"--connect", "jdbc:mysql://localhost/database_name",
						"--table", "table_name", "--username", "",
						"--password", ""
				};
				final Process ps_tSqoopImport_1 = runtime_tSqoopImport_1
						.exec(cmd_tSqoopImport_1);

The component executes "sqoop". Please check whether "sqoop" is internal or external command in cmd.
Regards,
Pedro

Re: A problem about sqoop

_AnonymousUser — Thu, 19 Jul 2012 04:18:11 GMT

Thanks,The problem is resolve
We can export SQOOP path in ./bash_profile and then execute SQOOP on external command,than then open TosBD to execute tsqoopImport

Re: A problem about sqoop

Anonymous — Thu, 19 Jul 2012 04:22:11 GMT

Hi
Great!
Feel free to ask any questions here.
Regards,
Pedro

Re: A problem about sqoop

_AnonymousUser — Thu, 06 Jun 2013 19:11:06 GMT

Hi
Even i am getting the same issue. Can you please help me resolve that. I am not able to clearly get your point.

Thank you,
Nagu.

Re: A problem about sqoop

Anonymous — Fri, 07 Jun 2013 10:21:43 GMT

Hi Naguhadoop
First you can export your job ,and then put it into your sqoop bin floder and run the .sh file .

Re: A problem about sqoop

_AnonymousUser — Mon, 05 May 2014 15:08:20 GMT

Hi ,
I am also facing the same issue.
Request your help/suggestions on below points : -
1) In Talend 5.2 ,there is no place where we specify the HDFS details except "target directory".
2) In order to have Sqoop components to work ,do we need to have HDFS,Talend and Sqoop to be installed on same machine?
In Talend 5.4, we can specify the HDFS details but in 5.2 we don't.
Please let me know prerequisties to have the Sqoop Component work in 5.2 & 5.4 both.
Thanks,
Himanshu

Re: A problem about sqoop

Anonymous — Tue, 06 May 2014 08:23:23 GMT

Hi,
Have you checked component reference
https://help.talend.com/search/all?query=tSqoopImport&content-lang=en qoop is typically installed in every Hadoop distribution. But if the Hadoop distribution you need to use have no Sqoop installed, you have to install one on your own and ensure to add the Sqoop command line to the PATH variable of that distribution.
Please have a look at jira issue https://jira.talendforge.org/browse/TDI-24250.

Best regards
Sabrina

Re: A problem about sqoop

Anonymous — Mon, 19 May 2014 13:21:38 GMT

SQOOP connection with teradata giving following error
ERROR]: org.apache.sqoop.tool.BaseSqoopTool - Got error creating database manager: java.io.IOException: No manager for connect string: jdbc:teradata
Let me know where to put teradata connection jars

Re: A problem about sqoop

_AnonymousUser — Tue, 03 Jun 2014 12:44:28 GMT

Hi sikarpe,
Add Addition Argument as "jdbc.driver.class" and value as "com.teradata.jdbc.TeraDriver" under Advanced Settings for tSqoopImport

Re: A problem about sqoop

_AnonymousUser — Wed, 11 Feb 2015 09:13:14 GMT

Thanks!!! it´s works perfectly!!