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,260 points
22 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

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
• 9,070 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,590 points
170 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,630 points
278 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
• 9,070 points
95 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
• 9,070 points
1,164 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,260 points
571 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
• 9,070 points
1,677 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
• 1,980 points
41 views
0 votes
10 answers

hadoop fs -put command?

copy command can be used to copy files ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Sujay
8,146 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
• 9,070 points
92 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
• 9,070 points
43 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.