Apache Sqoop Pros and Cons

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.

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.

It’s simple way to connect to any Database to pull or push data is the best part. It can be integrated with any of your scripts or programs for data transformation by simple use of SQL. Review collected by and hosted on G2.com.

Still there is scope of improvement to make it more robust for many NoSql based databases. Review collected by and hosted on G2.com.

Seemless intergartion with relational databases. Review collected by and hosted on G2.com.

Not very effective with de-normalized data as we need to execute multiple joins in map reduce. Review collected by and hosted on G2.com.

The command are very lightweight. And easily used to import data Review collected by and hosted on G2.com.

This service is a Simple tool with no flaws to notice. Review collected by and hosted on G2.com.

It provides an ease to transfer data between RDBMS and Hadoop. It's simply a command line tool. Does a good job in data migration. Review collected by and hosted on G2.com.

Sqoop is simply based on command line, it would have been better if presented in a good UI format. Review collected by and hosted on G2.com.

Incremental exports and incremental imports Review collected by and hosted on G2.com.

Nothing as such, I found the tool very useful Review collected by and hosted on G2.com.

Sqoop makes data fetch from other databases outside hadoop so easy. Review collected by and hosted on G2.com.

It is less performant. And violates data policy. Review collected by and hosted on G2.com.

We can connect easily with RSBMA Source systems to migrate data to On premise environment or cloud environment. Review collected by and hosted on G2.com.

If Sqoop will come up with other than RDBMS Then that will be better what I thought Review collected by and hosted on G2.com.

Transferring data between relational database and Hadoop. Review collected by and hosted on G2.com.

Swoop doesn't support file types like orc,rc which I don't like. Review collected by and hosted on G2.com.

Import data from rdbms and dump it into hdfs Review collected by and hosted on G2.com.

Taking too much time when data was huge Review collected by and hosted on G2.com.