Prós e Contras de Apache Sqoop

It's useful tool to transform structured database data into unstructured dba data. Easy to maintain data transfer jobs. Análise coletada por e hospedada no G2.com.

Since it works on top of Jvm, takes lots of memory Análise coletada por e hospedada no G2.com.

Essay to use, good is security, and fast data transferring between source to destination. Análise coletada por e hospedada no G2.com.

need to update design. otherwise all is good. Análise coletada por e hospedada no 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 Análise coletada por e hospedada no G2.com.

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

Not working for unstructured data Análise coletada por e hospedada no G2.com.

Este é o instrumento utilizado para importar dados de qualquer sistema RDMS. Ele utiliza uma estrutura Map-Reduce que fornece informações contínuas e o status dos dados importados. Além disso, executar este instrumento com um script shell é muito conveniente e eficaz. Análise coletada por e hospedada no G2.com.

Sqoop não possui uma interface gráfica de usuário. Se tivéssemos uma GUI para esta ferramenta, seria muito mais conveniente. Além disso, as funções de Map-reduce usadas no Sqoop são um pouco lentas, no entanto, as tecnologias modernas têm muitos avanços. Acredito que o uso de ferramentas modernas tornaria esta ferramenta muito mais rápida. Análise coletada por e hospedada no 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. Análise coletada por e hospedada no 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. Análise coletada por e hospedada no 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 Análise coletada por e hospedada no 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. Análise coletada por e hospedada no 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 Análise coletada por e hospedada no 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 Análise coletada por e hospedada no G2.com.

Great tool designed to transfer data between Hadoop and RDBMS databases or visa versa. Análise coletada por e hospedada no G2.com.

Not much to dislike here. Tool worked well and had solid error handling throughout product Análise coletada por e hospedada no 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 Análise coletada por e hospedada no G2.com.

A little complex to debug issues as it throws irrelevant exceptions for complex tasks. Análise coletada por e hospedada no G2.com.

Sqoop can be used to load large chunk of data Análise coletada por e hospedada no G2.com.

Sqoop uses JDBC connection to connect to RDBMS which is inefficient Análise coletada por e hospedada no G2.com.