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
464 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
• 26,270 points
65 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
• 26,270 points
73 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
• 26,270 points
94 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
38 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
• 69,000 points
58 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
238 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
794 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
240 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
• 26,270 points
81 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
3,038 views