Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-21337

HMS Metadata migration from Postgres/Derby to other DBs fail

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.0.0
    • Fix Version/s: 4.0.0
    • Component/s: Metastore
    • Labels:
      None
    • Target Version/s:

      Description

      Customer recently was migrating from Postgres to Oracle for HMS metastore. During import of the [exported] data from HMS metastore from postgres, failures are seen as the COLUMNS_V2.COMMENT is 4000 bytes long whereas oracle and other schemas define it to be 256 bytes.
      This inconsistency in the schema makes the migration cumbersome and manual. This jira makes this column consistent in length across all databases.

        Attachments

        1. HIVE-21337.patch
          2 kB
          Naveen Gangam
        2. HIVE-21337.2.patch
          5 kB
          Naveen Gangam

          Activity

            People

            • Assignee:
              ngangam Naveen Gangam
              Reporter:
              ngangam Naveen Gangam
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: