[HIVE-20940] Bridge cases in which Calcite's type resolution is more stricter than Hive.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Assignee: Zoltan Haindrich
• Reporter: Zoltan Haindrich
• Created: 19/Nov/18 15:58
• Updated: 17/Nov/22 08:54
• Resolved: 23/Nov/18 06:45

Description

Calcite is more stricter w.r.t common types than Hive.

For example in case a CASE with different types on the branches is not something Calcite likes:

CASE
  WHEN cond1 THEN booleanCol
  WHEN cond2 THEN stringCol
  WHEN cond3 THEN floatCol
  ELSE doubleCol
END

issues will only happen with 1.18-SNAPSHOT version