Churchill vins Churchill vins - 1 year ago 135
MySQL Question

Sqoop Import MySql Db failed

I'll try to import mysql table into sqoop but i am facing the below exceptions,
MySql running in my local machine table creation and db creation working fine, when I'll try sqoop import the job automatically failed.
Please help me.
Thanks in Advance.

'MySQL' is not recognized as an internal or external command,
operable program or batch file.

at org.apache.hadoop.util.Shell.runCommand(
at org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(
at org.apache.hadoop.yarn.server.nodemanager.DefaultContainerExecutor.launchContainer(
at java.util.concurrent.ThreadPoolExecutor.runWorker(
at java.util.concurrent.ThreadPoolExecutor$

1 file(s) moved.

Container exited with a non-zero exit code 9009

Installed MySQL in local machine and added the environmental variables in the system path

Answer Source

The problem occurs due to the MySQL Environmental variables added in the system path. C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\Doctrine extensions for PHP\ ; The & skips the remaing paths so MySQL consider as command line, replace '&' instead of any other characters it's working.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download