Sqoop error while trying to connect to MySql

Question

Hi, 

I am running below sqoop command but getting error. I'm using edureka VM

[edureka@localhost ~]$ sqoop import \
> --connect "jdbc:mysql://local/mydb" \
> --user root \
> --password Edurekasql_123 \
> --table elections \
> --target-dir /Test \
> -m 1;
Warning: /usr/lib/sqoop-1.4.6.bin__hadoop-2.0.4-alpha/../hbase does not exist! HBase imports will fail.
Please set $HBASE_HOME to the root of your HBase installation.
Warning: /usr/lib/sqoop-1.4.6.bin__hadoop-2.0.4-alpha/../hcatalog does not exist! HCatalog jobs will fail.
Please set $HCAT_HOME to the root of your HCatalog installation.
Warning: /usr/lib/sqoop-1.4.6.bin__hadoop-2.0.4-alpha/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
18/12/22 21:58:02 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Error parsing arguments for import:
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: --user
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: root
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: --password
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: Edurekasql_123
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: --table
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: elections
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: --target-dir
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: /Test
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: -m
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: 1

Answer 1

Please use the below command to solve the problem :

sqoop import --connect jdbc:mysql://localhost/mydb --username root --password Edurekasql_123 --table elections --target-dir /Test1 -m 1;