[CALCITE-1651] Difference in DATE cast between Hive and Calcite

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Component/s: core
• Assignee: Julian Hyde
• Reporter: Remus Rusanu
• Created: 21/Feb/17 17:20
• Updated: 26/Feb/17 10:41
• Resolved: 26/Feb/17 10:41

Description

Hive CAST('<literal>' as DATE) is handled by Java's Date.valueOf and thus expects yyyy-mm-dd. In Hive SELECT CAST('1' as DATE); yields NULL but in Calcite is 0001-12-31.

I'm opening this as Calcite issue to track HIVE-15708 (migrate to Calcite 1.12) blockers, not sure if solution will require Calcite changes.

Issue Links

• Blocked: HIVE-15708 Upgrade calcite version to 1.12
• is duplicated by: CALCITE-1653 Pass an expression executor to RexUtil.simplify for constant reduction
• is related to: CALCITE-1653 Pass an expression executor to RexUtil.simplify for constant reduction