Support Questions

Find answers, ask questions, and share your expertise

Unable to use SQOOP IMPORT SYNTAX

avatar
New Contributor

MySQL [sandeepnagulayahoo]> sqoop import --connect jdbc:mysql://sqoopdb.slbdh.cloudlabs.com/sandeepnagulayahoo--username sandeepnagulayahoo --password XXXXXX --table raj --m 1 --target-dir raj
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sqoop import --connect jdbc:mysql://sqoopdb.slbdh.cloudlabs.com/sandeepnagulayah' at line 1

2 REPLIES 2

avatar

It would be helpful to community members inclined to answer your question if you included which version of Sqoop you're using, and from which distribution (i.e., HDP, CDH or CDP) you installed it from. The version of mysql you're targeting would be helpful, as well.

 

 

Bill Brooks, Community Moderator
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

avatar
Master Collaborator

Hi ,

Can you attach the screenshot of the sqoop command that you are running with an exception ?, It seems to be you are running it from MySql command line can you exit from there and run it through normal terminal session.