Created on 06-12-2021 09:48 PM - edited 06-12-2021 11:47 PM
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
Created 06-13-2021 09:20 AM
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.
Created 06-14-2021 08:16 AM
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.