[
https://issues.apache.org/jira/browse/HIVE-23804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17151958#comment-17151958
]
Aditya Shah commented on HIVE-23804:
------------------------------------
[~pvary] [~gates] can you please take a look. One additional observation was to
check the create table commands for column stats tables in Postgres scripts.
The upgrade scripts seem different in column constraints than the fresh schema
scripts.
Thanks,
Aditya
> 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.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)
