[
https://issues.apache.org/jira/browse/HIVE-23804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17158515#comment-17158515
]
Abhishek Somani edited comment on HIVE-23804 at 7/15/20, 4:33 PM:
------------------------------------------------------------------
[~ngangam] the issue exists in all metastore schemas of 3.0 and above. When any
such schema is used with an HMS version < 3.0, one will hit the issue.
So for example, if you use metastore db schema of 4.0.0, but HMS version 2.3,
one will hit the issue.
So basically the backward compatibility of metastore db with older HMS versions
is broken.
was (Author: asomani):
[~ngangam] the issue exists in all metastore schemas of 3.0 and above. When any
such schema is used with an HMS version <= 3.0, one will hit the issue.
So for example, if you use metastore db schema of 4.0.0, but HMS version 2.3,
one will hit the issue.
So basically the backward compatibility of metastore db with older HMS versions
is broken.
> Adding defaults for Columns Stats table in the schema to make them backward
> compatible
> --------------------------------------------------------------------------------------
>
> Key: HIVE-23804
> URL: https://issues.apache.org/jira/browse/HIVE-23804
> Project: Hive
> Issue Type: Sub-task
> Affects Versions: 2.1.1, 2.3.7
> Reporter: Aditya Shah
> Assignee: Aditya Shah
> Priority: Major
> Attachments: HIVE-23804-1.patch, HIVE-23804.patch
>
>
> Since the table/part column statistics tables have added a new `CAT_NAME`
> column with `NOT NULL` constraint in version >3.0.0, queries to analyze
> statistics break for Hive versions <3.0.0 when used against an upgraded DB.
> One such miss is handled in HIVE-21739.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
