Introducing G2.ai, the future of software buying.Try now
Astro by Astronomer
Sponsored
Astro by Astronomer
Visit Website
Product Avatar Image
Apache Sqoop

By The Apache Software Foundation

Unclaimed Profile

Claim your company’s G2 profile

Claiming this profile confirms that you work at Apache Sqoop and allows you to manage how it appears on G2.

    Once approved, you can:

  • Update your company and product details

  • Boost your brand's visibility on G2, search and LLMs

  • Access insights on visitors and competitors

  • Respond to customer reviews

  • We’ll verify your work email before granting access.

Claim Now
4.3 out of 5 stars
3 star
0%
2 star
0%
1 star
0%

How would you rate your experience with Apache Sqoop?

Astro by Astronomer
Sponsored
Astro by Astronomer
Visit Website
It's been two months since this profile received a new review
Leave a Review
srinu k.
SK
Senior ETL Consultant
Enterprise (> 1000 emp.)
"It’s designed to transfer the huge data between Database and Cluster"
What do you like best about Apache Sqoop?

Transferring the structural data between RDBMS and Cluster Review collected by and hosted on G2.com.

What do you dislike about Apache Sqoop?

It’s little bit difficult to trace the error log Review collected by and hosted on G2.com.

Apache Sqoop

Apache Sqoop Reviews & Product Details

Value at a Glance

Averages based on real user reviews.

Perceived Cost

$$$$$
Product Avatar Image

Have you used Apache Sqoop before?

Answer a few questions to help the Apache Sqoop community

Apache Sqoop Reviews (30)

View 1 Video Reviews
Reviews

Apache Sqoop Reviews (30)

View 1 Video Reviews
4.3
31 reviews

Search reviews
Filter Reviews
Clear Results
G2 reviews are authentic and verified.
Shubhashish V.
SV
Data Engineer
Enterprise (> 1000 emp.)
"Data sqoop from informatica and oracle in Big data applications"
What do you like best about Apache Sqoop?

Apache is very helpful in extracting big data set with minimal time .It can be integrated and implemented with many of similar application where big data is involved with frequency use Review collected by and hosted on G2.com.

What do you dislike about Apache Sqoop?

Sometimes query takes more time in execution when many join or left outer join or other join involved with extra filter in where condition . The failure during partial import happened in long query Review collected by and hosted on G2.com.

Zubin D.
ZD
Associate Software Engineering Manager
Enterprise (> 1000 emp.)
"A versatile utility for data move movement and basic sql functions."
What do you like best about Apache Sqoop?

The simplicity with which the tool can be used at the get with minimal setup in a distributed environment and the short learning curve. Review collected by and hosted on G2.com.

What do you dislike about Apache Sqoop?

The logging seemed to be something I personally struggled with identifying data anomalies when came to data movement in my use cases. Review collected by and hosted on G2.com.

Verified User in Accounting
UA
Small-Business (50 or fewer emp.)
"Command line interface application for transferring data between database and hadoop"
What do you like best about Apache Sqoop?

Data transfer is in parallel,making it fast and cost effective. Review collected by and hosted on G2.com.

What do you dislike about Apache Sqoop?

The failure during partial import and export need special handling. Review collected by and hosted on G2.com.

A P.
AP
Freelance Data science/ big data trainer
Mid-Market (51-1000 emp.)
"Data import/export from/to RDBMS with Sqoop"
What do you like best about Apache Sqoop?

Incremental imports are most useful in sqoop Review collected by and hosted on G2.com.

What do you dislike about Apache Sqoop?

sometimes when the same database is used for other business applications and my queries involve multiple joins, performance is impacted Review collected by and hosted on G2.com.

Kubendra Reddy M.
KM
Data Engineer
Enterprise (> 1000 emp.)
"Standard CLI tool for importing and exporting data from Hadoop"
What do you like best about Apache Sqoop?

Best thing about is it excutes the data transfer parallel.It allows to transfer the data from variety of structured databases. It has huge support community. Review collected by and hosted on G2.com.

What do you dislike about Apache Sqoop?

Under the hood it uses MapReduce which takes time for even small data transfer. Implementing Change data capture and incremental loads is quite complex.It cannot be paused and resumed. Review collected by and hosted on G2.com.

GS
Data Scientist
Mid-Market (51-1000 emp.)
"Apache Sqoop for collecting social data"
What do you like best about Apache Sqoop?

The best thing about apache sqoop is it provides easy configuration for getting the data in real time from source system Review collected by and hosted on G2.com.

What do you dislike about Apache Sqoop?

The thing which i disliked about apache sqoop is once the pipleline is broked then it is tough to recover lost messages Review collected by and hosted on G2.com.

Nikunj P.
NP
Senior Software Engineer
Computer Software
Enterprise (> 1000 emp.)
"Very useful and easy to use."
What do you like best about Apache Sqoop?

The usage is very simple. It's very user friendly. We need not write lot of lines of code to get the data from db or write back to db Review collected by and hosted on G2.com.

What do you dislike about Apache Sqoop?

There is nothing I can see as of now. If we get supporfor swooping nosql dbs that would be great Review collected by and hosted on G2.com.

Saurav M.
SM
Big Data Developer
Enterprise (> 1000 emp.)
"The Best application for transferring data between relational databases and Hadoop"
What do you like best about Apache Sqoop?

The simplicity and effectiveness of the application wins my heart. Also, user-centric design is awesome. I am using Sqoop to import data from external datastores into Hadoop Distributed File System or related Hadoop eco-systems like Hive and HBase. The best benefit is how easy it is to use and how fast it is. Sqoop can easily integrate with Hadoop and dump structured data from relational databases on HDFS, complimenting the power of Hadoop. This is why Big Data and Hadoop certification mandates a sound knowledge of Apache Sqoop and Flume. Review collected by and hosted on G2.com.

What do you dislike about Apache Sqoop?

I did not really find anything that I didn't like but if in future I did, I would love to share it. There are few issues using sqoop which buged me initially but are easy to handle:

Sqoop Connector:

Issue:

Use of incorrect connector for the Database to be connected while doing sqoop export or sqoop import.

Missing driver or use of correct driver name of the respective jdbc class for sqoop command.

Missing connection-manager name in some cases of sqoop command.

Incorrect approach of giving password or username of the Database to be connected.

Format of the data stored in HDFS/Hive Tables can create issues. There are few formats such as ORC files which wont allow direct data transfer using sqoop.

Non-matching or incorrect names of columns of source and destination tables where HCatalog is used in sqoop command can show successful sqoop job without the data being transferred. Review collected by and hosted on G2.com.

Verified User in Telecommunications
UT
Enterprise (> 1000 emp.)
"Making imports easier from Relational DB to HDFS"
What do you like best about Apache Sqoop?

Replication of Relational DB onto HDFS for MR jobs Review collected by and hosted on G2.com.

What do you dislike about Apache Sqoop?

The data had to be re-imported every time the data was changed Review collected by and hosted on G2.com.

Vijay A.
VA
Engineer
Enterprise (> 1000 emp.)
"Sqoop as a key tool in our ETL Pipeline"
What do you like best about Apache Sqoop?

Best suited in our pipeline where we load/unload data from postgreSQL.

Suited for out data format in AVRO.

Under normal circumstances execution is fast and cost effective. Review collected by and hosted on G2.com.

What do you dislike about Apache Sqoop?

When loading huge data it is becoming performance bottle neck for other apps working with same datastore.

There is no pause & resume feature. We have to start job again. Review collected by and hosted on G2.com.

Pricing

Pricing details for this product isn’t currently available. Visit the vendor’s website to learn more.

Apache Sqoop Comparisons
Product Avatar Image
Apache NiFi
Compare Now
Product Avatar Image
Azure Data Factory
Compare Now
Product Avatar Image
AWS Glue
Compare Now
Product Avatar Image
Apache Sqoop
View Alternatives