[HIVE-9278] Cached expression feature broken in one case

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 0.14.0
• Fix Version/s: 1.0.0
• Component/s: Query Processor
• Assignee: Navis Ryu
• Reporter: Matt McCline
• Created: 07/Jan/15 01:44
• Updated: 19/Feb/15 18:22
• Resolved: 08/Jan/15 17:50

Description

Different query result depending on whether hive.cache.expr.evaluation is true or false. When true, no query results are produced (this is wrong).

The q file:

set hive.cache.expr.evaluation=true;

CREATE TABLE cache_expr_repro (date_str STRING);
LOAD DATA LOCAL INPATH '../../data/files/cache_expr_repro.txt' INTO TABLE cache_expr_repro;

SELECT MONTH(date_str) AS `mon`, CAST((MONTH(date_str) - 1) / 3 + 1 AS int) AS `quarter`,   YEAR(date_str) AS `year` FROM cache_expr_repro WHERE ((CAST((MONTH(date_str) - 1) / 3 + 1 AS int) = 1) AND (YEAR(date_str) = 2015)) GROUP BY MONTH(date_str), CAST((MONTH(date_str) - 1) / 3 + 1 AS int),   YEAR(date_str) ;

cache_expr_repro.txt

2015-01-01 00:00:00
2015-02-01 00:00:00
2015-01-01 00:00:00
2015-02-01 00:00:00
2015-01-01 00:00:00
2015-01-01 00:00:00
2015-02-01 00:00:00
2015-02-01 00:00:00
2015-01-01 00:00:00
2015-01-01 00:00:00

Issue Links

• is duplicated by: HIVE-9459 Concat plus date functions appear to be broken in 0.14
• is duplicated by: HIVE-9632 inconsistent results between year(), month(), day(), and the actual values in formulas