How to implement sqoop jobs?

0 votes
I am new to Sqoop. I want to know the steps to implement sqoop jobs like importing and checking import, etc.

Can someone tell me the steps?
Dec 18, 2018 in Big Data Hadoop by digger
• 26,600 points
83 views

1 answer to this question.

0 votes

Step 1: Give the below command to start mysql:

sudo service mysqld start

Step 2: To access the MySQL, you need to give the below command:

mysql -u root -p

When the console asks for a password, type the password or just press enter if you dont want a password

create database sample;
use sample;

Now create a table and insert data

Step 3: Now, we have created a database and inside the database, we have also created a table employee and have also loaded the table.

Now to view the table, we give the following command:

select * from employee

Step 4: Now, we are supposed to open another terminal and give the below commands to use sqoop to import tables to hdfs:

sqoop import --connect jdbc:mysql://localhost/sample --table employee --username root --P --target-dir /sqoop_jobs/sqoop1 -m 1

Step 5: Now we can verify import in the hdfs by entering the url of sqoop in the web browser

answered Dec 18, 2018 by Omkar
• 68,160 points

Related Questions In Big Data Hadoop

0 votes
1 answer

How to tune Spark jobs & optimize the performance?

You need to know the cluster properly ...READ MORE

answered Apr 18, 2018 in Big Data Hadoop by coldcode
• 2,040 points
560 views
0 votes
1 answer

How to implement data locality in Hadoop MapReduce?

You can use this getFileBlockLocations method of ...READ MORE

answered Apr 20, 2018 in Big Data Hadoop by kurt_cobain
• 9,280 points
102 views
0 votes
1 answer

How to transfer data from Netezza to HDFS using Apache Sqoop?

Remove the --direct option. It gives issue ...READ MORE

answered Apr 23, 2018 in Big Data Hadoop by kurt_cobain
• 9,280 points
358 views
0 votes
1 answer

How to install Sqoop with Hadoop 2.2.0?

You can refer the below link to ...READ MORE

answered Sep 18, 2018 in Big Data Hadoop by Frankie
• 9,810 points
283 views
0 votes
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,760 points
3,552 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,760 points
441 views
+1 vote
11 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
18,204 views
0 votes
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,280 points
1,319 views
0 votes
1 answer

Hadoop Sqoop: How to change sqoop metastore?

In sqoop-site.xml I configured it with, the ...READ MORE

answered Nov 13, 2018 in Big Data Hadoop by Omkar
• 68,160 points
321 views
0 votes
1 answer

Not able to list sqoop jobs

It seems like you are missing a ...READ MORE

answered Dec 13, 2018 in Big Data Hadoop by Omkar
• 68,160 points
93 views