How to connect Sqoop to mysql Database?

0 votes
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?
May 15, 2019 in Big Data Hadoop by Rishi
320 views

1 answer to this question.

0 votes

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
answered May 15, 2019 by Tina

Related Questions In Big Data Hadoop

0 votes
1 answer

How to connect Relational Database using Sqoop?

Hi, You can use the command below to ...READ MORE

answered Jun 26, 2019 in Big Data Hadoop by Gitika
• 25,440 points
38 views
0 votes
1 answer

How to create database in Mysql?

The command you can use is: create table ...READ MORE

answered Apr 15, 2019 in Big Data Hadoop by Gitika
• 25,440 points
57 views
0 votes
1 answer

How to create table inside database in MySql in Linux?

We can use this command to create ...READ MORE

answered Apr 15, 2019 in Big Data Hadoop by Gitika
• 25,440 points
85 views
0 votes
1 answer

How to use SQLServer database with Sqoop?

First, download the SQLServer connector from Microsoft's ...READ MORE

answered May 15, 2019 in Big Data Hadoop by Karan
34 views
0 votes
1 answer

Update hdfs data before stroring in MySql

Yes, you can update the data before ...READ MORE

answered Jan 27, 2019 in Big Data Hadoop by Omkar
• 68,860 points
47 views
0 votes
1 answer

Problem connecting Sqoop to MySql

Perhaps, you have slightly misunderstood the method ...READ MORE

answered May 15, 2019 in Big Data Hadoop by Ali
181 views
0 votes
2 answers

How to pass a password to Sqoop import command?

You can directly pass the password in ...READ MORE

answered May 15, 2019 in Big Data Hadoop by Raj
539 views
0 votes
1 answer

Connection String for MySQL database using Sqoop

The format for the connection string and ...READ MORE

answered Jun 6, 2019 in Big Data Hadoop by John
155 views
0 votes
1 answer

How to configure the metastore service to communicate with the MySQL database in Hive?

Hey, This step shows the configuration properties you ...READ MORE

answered May 29, 2019 in Big Data Hadoop by Gitika
• 25,440 points
61 views
0 votes
3 answers

How to change the delimiter in Sqoop?

--fields-terminated-by <char> READ MORE

answered Jun 25, 2019 in Big Data Hadoop by anonymous
2,423 views