[
https://issues.apache.org/jira/browse/HIVE-21178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Venu Yanamandra updated HIVE-21178:
-----------------------------------
Description:
Based on the sql scripts present for derby db, the size of COLUMNS_V2[COMMENT]
is 4000.
[https://github.com/apache/hive/tree/master/metastore/scripts/upgrade/derby]
However, if we see those present in say - mysql, we see them limited at 256.
[https://github.com/apache/hive/tree/master/metastore/scripts/upgrade/mysql]
For a requirement to store larger amount of comments, non-derby dbs limit the
maximum size of the column comments.
Kindly review the discrepancy.
was:
Based on the sql scripts present for derby db, the size of COLUMNS_V2[COMMENT]
is 4000.
[https://github.com/apache/hive/tree/master/metastore/scripts/upgrade/derby]
However, if we see those present in say - mysql, we see them limited at 256.
[https://github.com/apache/hive/tree/master/metastore/scripts/upgrade/mysql]
For a requirement to store larger amount of comments, non-derby dbs, limit the
maximum size of the column comments.
Kindly review the discrepancy.
> COLUMNS_V2[COMMENT] size different between derby db & other dbs.
> ----------------------------------------------------------------
>
> Key: HIVE-21178
> URL: https://issues.apache.org/jira/browse/HIVE-21178
> Project: Hive
> Issue Type: Bug
> Reporter: Venu Yanamandra
> Priority: Minor
>
> Based on the sql scripts present for derby db, the size of
> COLUMNS_V2[COMMENT] is 4000.
> [https://github.com/apache/hive/tree/master/metastore/scripts/upgrade/derby]
>
> However, if we see those present in say - mysql, we see them limited at 256.
> [https://github.com/apache/hive/tree/master/metastore/scripts/upgrade/mysql]
>
> For a requirement to store larger amount of comments, non-derby dbs limit the
> maximum size of the column comments.
>
> Kindly review the discrepancy.
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
