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

• Type: Sub-task
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.1.1, 2.3.7
• Assignee: Aditya Shah
• Reporter: Aditya Shah
• Created: 06/Jul/20 10:59
• Updated: 15/Jul/20 16:33

Description

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.