Importing a portion of Relational Database to HDFS

0 votes
I need to import a portion of a relational database every day as files to HDFS, and generate Java classes to Interact with my imported data. Is there any tool which I can use to accomplish this?

Can someone help!
Jul 20, 2018 in Big Data Hadoop by Meci Matt
• 9,460 points
115 views

1 answer to this question.

0 votes

Yes, there is a tool called Sqoop which you can use to move your RDBMS data to HDFS.

Sqoop (“SQL-to-Hadoop”) is a straightforward command-line tool with the following capabilities: 

  • Imports individual tables or entire databases to files in HDFS Generates Java classes to allow you to interact with your imported data 
  • Provides the ability to import from SQL databases straight into your Hive data warehouse
Hope it will answer your query.
answered Jul 20, 2018 by nitinrawat895
• 10,840 points

Related Questions In Big Data Hadoop

0 votes
1 answer

How to print the content of a file in console present in HDFS?

Yes, you can use hdfs dfs command ...READ MORE

answered Apr 19, 2018 in Big Data Hadoop by Shubham
• 13,370 points
824 views
0 votes
1 answer

How to check the size of a file in Hadoop HDFS?

You can use the  hadoop fs -ls command to ...READ MORE

answered Nov 21, 2018 in Big Data Hadoop by Omkar
• 68,880 points
1,365 views
0 votes
1 answer

What is the command to count number of lines in a file in hdfs?

hadoop fs -cat /example2/doc1 | wc -l READ MORE

answered Nov 22, 2018 in Big Data Hadoop by Omkar
• 68,880 points
519 views
0 votes
1 answer

How to find the number of blocks a hdfs file is divided into?

Yes. you can use the hadoop fsck command to do ...READ MORE

answered Nov 29, 2018 in Big Data Hadoop by Omkar
• 68,880 points
890 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,290 points
1,481 views
0 votes
1 answer

How to move data from Oracle database to Hadoop?

Yes, you heard it correctly. Apache Sqoop is ...READ MORE

answered Apr 11, 2018 in Big Data Hadoop by nitinrawat895
• 10,840 points
2,575 views
+1 vote
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,840 points
3,920 views
0 votes
1 answer

How to get started with Hadoop?

Well, hadoop is actually a framework that ...READ MORE

answered Mar 21, 2018 in Big Data Hadoop by coldcode
• 2,050 points
134 views
0 votes
1 answer

How to create a FileSystem object that can be used for reading from and writing to HDFS?

Read operation on HDFS In order to read ...READ MORE

answered Mar 21, 2018 in Big Data Hadoop by nitinrawat895
• 10,840 points

edited Mar 21, 2018 by nitinrawat895 467 views
0 votes
1 answer

How can we transfer a PDF file to HDFS?

You can easily upload any file to ...READ MORE

answered Apr 13, 2018 in Big Data Hadoop by nitinrawat895
• 10,840 points
108 views