RE: Running Sqoop

I've mysql workbench installed on my local pc. But, whenever I run a sqoop command, it says 'Connection to the database server' not established.

I've already installed the connectors and placed them inside sqoop/lib folder.

When I connect to mysql DB, I was able to connect with the username and password.

Please find the screenshots for your reference.

Kindly let me know if I'm missing something.

Thanks,

Venkatesh Raman

Hi Venkatesh, 

Thanks for contacting Syncfusion support. We have checked the logs attached and we suspect that the issue may be due to mysql connector used in ‘Sqoop\lib’ is incompatible with mysql server version 8.0.13 running in your machine. Download MySql connector jar 8.0 from here and replace the downloaded JDBC connector jars to Sqoop\lib folder. 

 

 

Here is a sqoop sample executed in command shell which list the database from mysql server: 

 

Regards, 

Mallieswari D 

Thanks. I downloaded mysql-connector-java-8.0.13 and it was resulting in version mismatch 'java.lang.UnsupportedClassVersionError: com/mysql/jdbc/Driver : Unsupported major.minor version 52.0' issues, so I tried 5.1.47 and the sqoop commands between mysql and hdfs seem to be working fine. But, when I use hive import, I'm getting a jline error. Kindly let me know if I'm missing something.

Thanks,

Venkatesh Raman

Hi Venkatesan, 

  

Please let us know whether you have tried out Hive import via Big Data Studio application. Because Jline jar references were already handled in Big Data Studio. You can check the following link to know more about submitting a Sqoop job via Big Data Studio. 

https://help.syncfusion.com/bigdata/bigdata-studio/sqoop#add-sqoop-job 

  

Also, we couldn’t find any files in your attachment. If you still face any problem, please let us know. 

  

Regards, 

Dinesh Kumar P