hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Naveen Gangam (JIRA)" <>
Subject [jira] [Updated] (HIVE-21337) HMS Metadata migration from Postgres/Derby to other DBs fail
Date Tue, 05 Mar 2019 22:05:01 GMT


Naveen Gangam updated HIVE-21337:
    Attachment: HIVE-21337.2.patch
        Status: Patch Available  (was: Open)

Instead of downsizing the COMMENT in Postgres and derby, I am upsizing it in MSSQL, MySQL
and Oracle DBs.

> HMS Metadata migration from Postgres/Derby to other DBs fail
> ------------------------------------------------------------
>                 Key: HIVE-21337
>                 URL:
>             Project: Hive
>          Issue Type: Improvement
>          Components: Metastore
>    Affects Versions: 3.0.0
>            Reporter: Naveen Gangam
>            Assignee: Naveen Gangam
>            Priority: Minor
>         Attachments: HIVE-21337.2.patch, HIVE-21337.patch
> 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.

This message was sent by Atlassian JIRA

View raw message