Pros y Contras de Apache Sqoop

It's useful tool to transform structured database data into unstructured dba data. Easy to maintain data transfer jobs. Reseña recopilada por y alojada en G2.com.

Since it works on top of Jvm, takes lots of memory Reseña recopilada por y alojada en G2.com.

Essay to use, good is security, and fast data transferring between source to destination. Reseña recopilada por y alojada en G2.com.

need to update design. otherwise all is good. Reseña recopilada por y alojada en 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 Reseña recopilada por y alojada en G2.com.

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

Not working for unstructured data Reseña recopilada por y alojada en G2.com.

Esta es la herramienta que se utiliza para importar datos de cualquier sistema RDMS. Utiliza un marco de Map-Reduce que proporciona información continua y el estado de los datos importados. Además, ejecutar esta herramienta con un script de shell es mucho más conveniente y efectivo. Reseña recopilada por y alojada en G2.com.

Sqoop no tiene una interfaz gráfica de usuario. Si tuviéramos una GUI para esta herramienta, habría sido mucho más conveniente. Además, las funciones de Map-reduce utilizadas en Sqoop son un poco lentas, sin embargo, las tecnologías modernas tienen muchos avances. Creo que usar herramientas modernas haría que esta herramienta fuera mucho más rápida. Reseña recopilada por y alojada en 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. Reseña recopilada por y alojada en 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. Reseña recopilada por y alojada en 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 Reseña recopilada por y alojada en 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. Reseña recopilada por y alojada en 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 Reseña recopilada por y alojada en 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 Reseña recopilada por y alojada en G2.com.

Great tool designed to transfer data between Hadoop and RDBMS databases or visa versa. Reseña recopilada por y alojada en G2.com.

Not much to dislike here. Tool worked well and had solid error handling throughout product Reseña recopilada por y alojada en 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 Reseña recopilada por y alojada en G2.com.

A little complex to debug issues as it throws irrelevant exceptions for complex tasks. Reseña recopilada por y alojada en G2.com.

Sqoop can be used to load large chunk of data Reseña recopilada por y alojada en G2.com.

Sqoop uses JDBC connection to connect to RDBMS which is inefficient Reseña recopilada por y alojada en G2.com.