Feature Differences - Sqoop 1 and Sqoop 2
Feature | Sqoop 1 | Sqoop 2 |
---|---|---|
Connectors for all major RDBMS | Supported. |
Not supported. Workaround: Use the generic JDBC Connector which has been tested on the following databases: Microsoft SQL Server, PostgreSQL, MySQL and Oracle. This connector should work on any other JDBC compliant database. However, performance might not be comparable to that of specialized connectors in Sqoop. |
Kerberos Security Integration | Supported. |
Supported. |
Data transfer from RDBMS to Hive or HBase | Supported. |
Not supported. Workaround: Follow this two-step approach.
|
Data transfer from Hive or HBase to RDBMS | Not supported.
Workaround: Follow this two-step approach.
|
Not supported. Follow the same workaround as for Sqoop 1. |