[HIVE-21019] Fix autoColumnStats tests to make auto stats gather possible.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 4.0.0
• Component/s: Test
• Assignee: Yongzhi Chen
• Reporter: Yongzhi Chen
• Created: 07/Dec/18 16:11
• Updated: 10/Dec/18 21:36
• Resolved: 07/Dec/18 23:41

Description

Before https://issues.apache.org/jira/browse/HIVE-20915 , the optimizer sort dynamic partitions is turn off for these tests. So these test can have group by in the query plan which can trigger compute statistics. After the jira, the optimizer is enabled, because of a a known bug with dynamic sorted partition optimization (HIVE-16100), the computer statistics does not happen. Fix the tests to disable the optimizer to test the same code path as before.

Issue Links

• is duplicated by: HIVE-16100 Dynamic Sorted Partition optimizer loses sibling operators
• is related to: HIVE-20915 Make dynamic sort partition optimization available to HoS and MR