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

          Activity

            People

            • Assignee:
              arvind Arvind Prabhakar
              Reporter:
              arvind Arvind Prabhakar
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: