[
https://issues.apache.org/jira/browse/HIVE-23804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Aditya Shah updated HIVE-23804:
-------------------------------
Attachment: HIVE-23804-1.patch
Status: Patch Available (was: Open)
[~ngangam] thanks for reviewing the patch. I have run the DB install tests now
and have made a few corrections in oracle db scripts. To answer your other
questions:
1. For user who has already upgraded to 3.1.2 his analyze statistics commands
would anyway not be working from a lower version's JVM. But for someone who is
looking forward to upgrading to 3.1.2 which is officially released until now
the backward compatibility is expected. We should probably not leave 3.1/3.0
version backward-incompatible whereas making 4 so.
2. This has been taken care of already setting explicitly
3. I ran the DB install tests and they passed successfully after some changes
(new patch).
4. For Postgres I found the create table commands for this stats tables did not
have a not null constraint in fresh schema script whereas upgrade scripts did.
I mentioned this and thought it should be addressed separately.
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.3.7, 2.1.1
> 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)
