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
There are no Sub-Tasks for this issue.