[HIVE-19073] StatsOptimizer may mangle constant columns

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.2
• Fix Version/s: 3.0.0
• Component/s: Physical Optimizer
• Target Version/s: 3.0.0
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 29/Mar/18 04:48
• Updated: 27/Feb/24 22:23
• Resolved: 02/Apr/18 20:50

Description

Following query is giving wrong result:

SELECT DATE_SUB(CURRENT_DATE,0) as GROUP_BY_FIELD, count (*)  as src_cnt from mytable WHERE 1=1 group by DATE_SUB(CURRENT_DATE,0);
+-----------------+----------+--+
| group_by_field  | src_cnt  |
+-----------------+----------+--+
| 239             | NULL     |
+-----------------+----------+--+
1 row selected (5.175 seconds)