Data Ingestion Using Sqoop

pyspark

#1

Querying using list and eval command!

kindly help out please as I keep getting this error message after much trials following the video. what do I need to do right?

[olanrewajuremi2000@gw03 ~]$ sqoop eval \

–connect jdbc://ms.itversity.com :3306/retail_db
–username retail_user
–password itversity
–query " SELECT * FROM orders LIMIT 10"
Warning: /usr/hdp/2.5.0.0-1245/accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
18/07/18 18:54:48 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.5.0.0-1245
18/07/18 18:54:48 ERROR tool.BaseSqoopTool: Error parsing arguments for eval:
18/07/18 18:54:48 ERROR tool.BaseSqoopTool: Unrecognized argument: :3306/retail_db
18/07/18 18:54:48 ERROR tool.BaseSqoopTool: Unrecognized argument: --username
18/07/18 18:54:48 ERROR tool.BaseSqoopTool: Unrecognized argument: retail_user
18/07/18 18:54:48 ERROR tool.BaseSqoopTool: Unrecognized argument: --password
18/07/18 18:54:48 ERROR tool.BaseSqoopTool: Unrecognized argument: itversity
18/07/18 18:54:48 ERROR tool.BaseSqoopTool: Unrecognized argument: --query
18/07/18 18:54:48 ERROR tool.BaseSqoopTool: Unrecognized argument: SELECT * FROM orders LIMIT 10

Try --help for usage instructions.
[olanrewajuremi2000@gw03 ~]$


#2

@Chris

Try below command:

sqoop eval
–connect “jdbc:mysql://ms.itversity.com:3306/retail_db”
–username retail_user
–password itversity
–query " SELECT * FROM orders LIMIT 10"