Apache Sqoop Pros and Cons

It's useful tool to transform structured database data into unstructured dba data. Easy to maintain data transfer jobs. Review collected by and hosted on G2.com.

Since it works on top of Jvm, takes lots of memory Review collected by and hosted on G2.com.

Essay to use, good is security, and fast data transferring between source to destination. Review collected by and hosted on G2.com.

need to update design. otherwise all is good. Review collected by and hosted on G2.com.

Sqoop command easy to write for getting data from database to hdfs

And export data from hdfs to database.

Incremental load and sqoop job most best feature in sqoop Review collected by and hosted on G2.com.

Sqoop only working for database import and export as like structure data.

Not working for unstructured data Review collected by and hosted on G2.com.

This is the tool that is used to import data from any RDMS systems. It uses a Map-Reduce framework which gives a continuous and running info and status of imported data. In addition, running this tool with a shell script is a lot convenient and effective. Review collected by and hosted on G2.com.

Sqoop doesn't have a Graphical user interface. If we have GUI for this tool it would have been a lot more convenient. Moreover, Map-reduce functions used in Sqoop is a little slow, however, modern technologies have many advances. I believe using modern tools would make this tool a lot faster. Review collected by and hosted on G2.com.

Best tool to efficiently transfer bulk data between structured datastores such as relational databases and Apache Hadoop. Works well with relational databases such as Teradata, Netezza, Oracle, MySQL, Postgres, and HSQLDB. Parallel data transfer function helps to faster performance and optimal system utilization.

Also helps to import sequential datasets from mainframe and direct to ORCFiles , fast data copies, efficient data analysis and load balancing. Review collected by and hosted on G2.com.

Can be applicable with structured database related transfer only. It uses a JDBC connection to connect with RDBMS based data stores which creates performance issue and makes inefficient. Review collected by and hosted on G2.com.

Provides generalized JDBC extensions to migrate data between most database systems

When combined with Cloudera's HUE, it can enable non-technical users to easily import relational data into Hadoop

Allows for both import and export features

Generates Java classes upon reading database records for use in other code utilizing Hadoop's client libraries Review collected by and hosted on G2.com.

Sqoop isn't very user-friendly for those uncomfortable with a CLI.

Sqoop2 development seems to have stalled. I have set it up outside of a Cloudera CDH installation, and I actually prefer it's "Sqoop Server" model better than just the CLI client version that is Sqoop1. This works especially well in a microservices environment, where there would be only one place to maintain the JDBC drivers to use for Sqoop. Review collected by and hosted on G2.com.

Using sqoop on the command line has provided me a quick and easy way to transfer data into sandbox databases or data lakes. This has made it easier for people in Analytics roles like myself to get the data sources together quickly to create models using real data while not being in a production environment Review collected by and hosted on G2.com.

I have only ever used Sqoop as a command line tool but think an integration into a UI like Hue would be great Review collected by and hosted on G2.com.

Great tool designed to transfer data between Hadoop and RDBMS databases or visa versa. Review collected by and hosted on G2.com.

Not much to dislike here. Tool worked well and had solid error handling throughout product Review collected by and hosted on G2.com.

Sqoop works perfectly with Hadoop. The import export functionality is easier to perform using sqoop. It works well with both data warehouses and databases Review collected by and hosted on G2.com.

A little complex to debug issues as it throws irrelevant exceptions for complex tasks. Review collected by and hosted on G2.com.

Sqoop can be used to load large chunk of data Review collected by and hosted on G2.com.

Sqoop uses JDBC connection to connect to RDBMS which is inefficient Review collected by and hosted on G2.com.