Sqoop vs Oracle Hadoop Connectors

0 votes
I have used Sqoop to ingest data from Oracle to Hadoop and it worked well but I've no idea how it will work in case of Oracle Hadoop Connector. It took only 3 mins to bring 76 million records from Oracle to Hive table without using partitions on Sqoop.

Can anyone give some details about Oracle Hadoop connectors, Will it perform better than Sqoop?
May 18, 2018 in Big Data Hadoop by kurt_cobain
• 9,390 points
917 views

1 answer to this question.

0 votes

Most of the connectors would have the performance close to same as you'll have a set of MapReduce jobs on the very end of your workflow and this would play the main role in your overall performance.

Oracle provides a set of different connectors for accessing the Hive and you could check a nice overview about standard solutions 
but I doubt that on the very end you will expect significant performance differences other then you see in Sqoop:

https://docs.oracle.com/cd/E37231_01/doc.20/e36961/start.htm#BDCUG119

Personally, I prefer Sqoop for Hadoop-driven import-export operations and connector approach for querying the data in Hadoop.

Hope this will answer your query to some extent.

answered May 18, 2018 by nitinrawat895
• 11,380 points

Related Questions In Big Data Hadoop

0 votes
1 answer

Will hadoop(sqoop) load oracle faster than SQL loader?

down vote Had a similar task of exporting ...READ MORE

answered Sep 4, 2018 in Big Data Hadoop by Frankie
• 9,830 points
1,766 views
0 votes
1 answer

Hadoop vs Data Lake

A data lake is a storage repository that holds ...READ MORE

answered Mar 26, 2018 in Big Data Hadoop by Ashish
• 2,650 points
1,847 views
0 votes
1 answer

RDBMS Vs Hadoop

There are various challenges with RDBMS such ...READ MORE

answered Apr 6, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
804 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 12, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
7,195 views
–1 vote
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,390 points
4,536 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
• 11,380 points
10,911 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,090 points
1,060 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
108,234 views
0 votes
1 answer

Hadoop MapReduce vs MongoDB MapReduce

Hadoop vs MongoDB MR: 1) Hadoop's MR can ...READ MORE

answered Mar 26, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
1,365 views
+1 vote
1 answer

Cassandra and Hadoop - realtime vs batch

Apache Hadoop, is a big data analytics ...READ MORE

answered Mar 26, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
1,708 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP