Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-15206 Add a validation functionality to hiveSchemaTool
  3. HIVE-16912

Improve table validator's performance against Oracle

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 3.0.0
    • 3.0.0
    • Hive
    • None

    Description

      Currently, this validator uses DatabaseMetaData.getTables() that takes in the order of minutes to return because of the number of SYSTEM tables present in Oracle.
      Providing a schema name via a system property would limit the number of tables being returned and thus improve performance.

      Attachments

        1. HIVE-16912.2.patch
          0.7 kB
          Naveen Gangam
        2. HIVE-16912.patch
          0.9 kB
          Naveen Gangam

        Activity

          People

            ngangam Naveen Gangam
            ngangam Naveen Gangam
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: