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,240 points
39 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
• 10,110 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,810 points
216 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
358 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
• 10,110 points
111 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,110 points
1,488 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,240 points
764 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,110 points
2,045 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,010 points
62 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
10,458 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
• 10,110 points
116 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
• 10,110 points
63 views