Getting error while importing data from mysql using sqoop


2 Answer(s)


hi Jitendra,

The Sqoop by default ships with Mysql and Postgresql connector with Cloudera VM. Can you post the query that you were trying to execute when this error showed up.

Thanks

2 more things you need to make sure that you have done for the query to execute.
You need to grant all privileges to the user on the database, example command is given below. Next check the connectivity of the database.

mysql> grant all privileges on test.* to 'testuser'@'%' identified by 'testpassword'

If you are still getting the error, paste the command you are trying to execute.