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 in Big Data Hadoop by Rishi
162 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 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 in Big Data Hadoop by Gitika
• 25,340 points
25 views
0 votes
1 answer

How to create database in Mysql?

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

answered Apr 15 in Big Data Hadoop by Gitika
• 25,340 points
42 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 in Big Data Hadoop by Gitika
• 25,340 points
73 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 in Big Data Hadoop by Karan
27 views
0 votes
1 answer

Update hdfs data before stroring in MySql

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

answered Jan 27 in Big Data Hadoop by Omkar
• 67,660 points
38 views
0 votes
1 answer

Problem connecting Sqoop to MySql

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

answered May 15 in Big Data Hadoop by Ali
142 views
0 votes
2 answers
0 votes
1 answer
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 in Big Data Hadoop by Gitika
• 25,340 points
44 views
0 votes
3 answers

How to change the delimiter in Sqoop?

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

answered Jun 25 in Big Data Hadoop by anonymous
1,844 views