hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aditya Shah (Jira)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-23804) Adding defaults for Columns Stats table in the schema to make them backward compatible
Date Mon, 06 Jul 2020 11:05:00 GMT

    [ 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)

Mime
View raw message