Sqoop导入MySql Db失败

Question

我将尝试将mysql表导入sqoop，但我将面临以下异常:运行在本地计算机表创建中的MySql和数据库创建工作正常，而当我尝试sqoop导入作业时，自动失败。请帮帮我。提前谢谢。

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

at org.apache.hadoop.util.Shell.runCommand(Shell.java:538)
    at org.apache.hadoop.util.Shell.run(Shell.java:455)
    at org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(Shell.java:702)
    at org.apache.hadoop.yarn.server.nodemanager.DefaultContainerExecutor.launchContainer(DefaultContainerExecutor.java:195)
    at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:300)
    at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:81)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:744)

        1 file(s) moved.

Container exited with a non-zero exit code 9009

在本地机器中安装MySQL并在系统路径中添加环境变量

Answer 1

此问题是由于系统路径中添加的MySQL环境变量造成的。C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\Doctrine extensions for PHP\ ; &跳过重定向路径，因此MySQL考虑将'&‘替换为命令行，而不是它正在工作的任何其他字符。

Answer 2

作为一项工作，删除直接选项。请提供完整的命令