Talend community forum / A problem about sqoop

Apaul · 2012-07-17 12:05:13

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?

pedro · 2012-07-18 03:59:29

Hi

Here is the code in this component.

Code:

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

Apaul · 2012-07-19 05:18:11

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

pedro · 2012-07-19 05:22:11

Hi

Great!
Feel free to ask any questions here.

Regards,
Pedro

Announcement

Unanswered posts

#1 2012-07-17 12:05:13

A problem about sqoop

#2 2012-07-18 03:59:29

Re: A problem about sqoop

Code:

#3 2012-07-19 05:18:11

Re: A problem about sqoop

#4 2012-07-19 05:22:11

Re: A problem about sqoop

Board footer