Details
-
Type: Improvement
-
Status: Resolved
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.4.0
-
Component/s: None
-
Labels:None
Description
Sqoop currently uses JDBC interface javax.sql.DatabaseMetaData for retrieving table metadata for things such as identifying the primary key column. This is error prone, not uniformly supported by all vendors and drivers, and usually has lower performance than direct queries. Furthermore, due to inconsistent semantics of users, schemas and privileges across different vendors, this interface is not sufficiently reliable for consistent results.
It would therefore be preferable for Sqoop to use catalog views for obtaining table metadata where possible.
Attachments
1.
|
Use catalog views for MySQLManager | Resolved | Bilung Lee | |
2.
|
Use catalog views for OracleManager | Resolved | Arvind Prabhakar | |
3.
|
Use catalog views for PostgresqlManager | Resolved | Bilung Lee | |
4.
|
Use catalog views for SQLServerManager | Resolved | Bilung Lee |