Apache Sqoop Avantages et Inconvénients

It's useful tool to transform structured database data into unstructured dba data. Easy to maintain data transfer jobs. Avis collecté par et hébergé sur G2.com.

Since it works on top of Jvm, takes lots of memory Avis collecté par et hébergé sur G2.com.

Essay to use, good is security, and fast data transferring between source to destination. Avis collecté par et hébergé sur G2.com.

need to update design. otherwise all is good. Avis collecté par et hébergé sur 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 Avis collecté par et hébergé sur G2.com.

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

Not working for unstructured data Avis collecté par et hébergé sur G2.com.

C'est l'outil qui est utilisé pour importer des données à partir de n'importe quel système RDMS. Il utilise un cadre Map-Reduce qui fournit des informations continues et un statut des données importées. De plus, exécuter cet outil avec un script shell est beaucoup plus pratique et efficace. Avis collecté par et hébergé sur G2.com.

Sqoop n'a pas d'interface utilisateur graphique. De plus, les fonctions Map-reduce utilisées dans Sqoop sont un peu lentes, cependant, les technologies modernes ont de nombreux progrès. Je crois que l'utilisation d'outils modernes rendrait cet outil beaucoup plus rapide. Avis collecté par et hébergé sur 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. Avis collecté par et hébergé sur 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. Avis collecté par et hébergé sur 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 Avis collecté par et hébergé sur 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. Avis collecté par et hébergé sur 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 Avis collecté par et hébergé sur 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 Avis collecté par et hébergé sur G2.com.

Great tool designed to transfer data between Hadoop and RDBMS databases or visa versa. Avis collecté par et hébergé sur G2.com.

Not much to dislike here. Tool worked well and had solid error handling throughout product Avis collecté par et hébergé sur 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 Avis collecté par et hébergé sur G2.com.

A little complex to debug issues as it throws irrelevant exceptions for complex tasks. Avis collecté par et hébergé sur G2.com.

Sqoop can be used to load large chunk of data Avis collecté par et hébergé sur G2.com.

Sqoop uses JDBC connection to connect to RDBMS which is inefficient Avis collecté par et hébergé sur G2.com.