You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Aditya Shah (Jira)" <ji...@apache.org> on 2020/07/06 11:05:00 UTC

[jira] [Commented] (HIVE-23804) Adding defaults for Columns Stats table in the schema to make them backward compatible

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