[
https://issues.apache.org/jira/browse/HIVE-12299?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15942494#comment-15942494
]
Lefty Leverenz commented on HIVE-12299:
---------------------------------------
[~ngangam], the fix version should be 2.3.0 instead of 2.2.0. (See my comment
on HIVE-12274.)
> Hive Column Data Type definition in schema limited to 4000 characters - too
> small
> ---------------------------------------------------------------------------------
>
> Key: HIVE-12299
> URL: https://issues.apache.org/jira/browse/HIVE-12299
> Project: Hive
> Issue Type: Improvement
> Components: Hive
> Reporter: Lakshmi Ramakrishnan
> Assignee: Naveen Gangam
> Fix For: 2.2.0, 3.0.0
>
>
> The data type definitions in the table schema are limited to 4K characters -
> as per the code here:
> https://github.com/apache/hive/tree/master/metastore/scripts/upgrade/derby
> I checked quickly and all meta stores have similar schema definition for the
> column type.
> Is there any reason why this limit is low? We had a table that had defined a
> struct, which had over 200 columns and the column names were rather verbose
> (for readability). This caused a non-obvious failure like
> FAILED: IllegalArgumentException Error: : expected at the end of
> 'string:array<struct<xyz:string, .....'. Is it possible to make this
> configurable or at least increase it to something much higher?
> Additionally, there is no validation error that communicates this limitation
> to the user, it required non-trivial debugging and looking into the table
> definitions when it failed trying to parse what was essentially a truncated
> type.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
