[
https://issues.apache.org/jira/browse/HIVE-4921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18058045#comment-18058045
]
Jaeho Yoo commented on HIVE-4921:
---------------------------------
This was resolved when upgrading 3.2 -> 4.0
https://github.com/apache/hive/blob/master/standalone-metastore/metastore-server/src/main/sql/mysql/upgrade-3.2.0-to-4.0.0-alpha-1.mysql.sql#L18
> Upgrade COMMENT column size in table COLUMNS_V2 and TYPE_FIELDS from 256 to
> 4000
> --------------------------------------------------------------------------------
>
> Key: HIVE-4921
> URL: https://issues.apache.org/jira/browse/HIVE-4921
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 0.10.0, 0.11.0
> Reporter: Xuefu Zhang
> Assignee: Xuefu Zhang
> Priority: Major
>
> There are three tables in Hive metastore schema having COMMENT COLUMN:
> PARTITIION_KEYS, COLUMNS_V2, and TYPE_FIELDS, and their sizes are different.
> PARTITIION_KEYS.COMMENT has a size of 4000. To be consistent, and to make it
> more reasonable, we need to promote the column in other two tables from the
> current size (256) to 4000.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
