[ https://issues.apache.org/jira/browse/HIVE-23804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17152335#comment-17152335 ]
Naveen Gangam commented on HIVE-23804: -------------------------------------- [~aditya-shah] Can you explain a bit more on what is failing? "queries to analyze statistics break for Hive versions <3.0.0 when used against an upgraded DB". So does this mean "analyze table compute statistics" is failing? what is the failure? do you have the stack trace? I am wondering if this requires a code fix to account for a null/empty CAT_NAME value like we do for other API calls on the HMS side that do not have a catalog name passed in. (MetastoreUtils.parseDBName) I will get to your comment above later. I am trying to understand the issue better to see what the best fix is. > 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)