[
https://issues.apache.org/jira/browse/HIVE-21337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
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: https://issues.apache.org/jira/browse/HIVE-21337
> 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
(v7.6.3#76005)
