How to connect Sqoop to mysql Database

Question

Hi. I am trying to import tables from a database to HDFS using this. For this, I first need to connect to the database. I am using MySql database. Can someone tell me how to connect Sqoop to HDFS?

Answer 1

Hi. You can connect Sqoop to MySql using the connect string with the import. You will have to mention the url to the database that is stored in MySql:

$ sqoop import --connect <hostname><database name>

For example, if the host is database.hadoop.com and the database name is student, then you should use the following command:

$ sqoop import --connect jdbc:mysql://database.hadoop.com/student