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
12 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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 create database in Mysql?

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

answered Apr 15 in Big Data Hadoop by Gitika
• 7,320 points
19 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
• 7,320 points
44 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
9 views
0 votes
1 answer

How to fetch more data from database while using Sqoop import?

Hey. You guessed it right. The max ...READ MORE

answered 6 days ago in Big Data Hadoop by Gani
11 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
• 65,840 points
18 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
17 views
0 votes
2 answers
0 votes
1 answer

Using Hadoop for Data Analytics.

Yes, your approach is correct - you ...READ MORE

answered Sep 28, 2018 in Big Data Hadoop by Frankie
• 9,570 points
23 views
0 votes
1 answer

How to set mapping to java in sqoop?

Hey @Chris, to set the mapping to ...READ MORE

answered 6 days ago in Big Data Hadoop by Reshma
21 views
0 votes
1 answer

How to decrease load on HBase while importing Sqoop?

Sqoop by default serializes all the input ...READ MORE

answered 5 days ago in Big Data Hadoop by Yogi
9 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.