[DRILL-4938] Report UserException when constant expression reduction fails

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.9.0
• Fix Version/s: 1.10.0
• Component/s: Execution - Data Types
• Assignee: Serhii Harnyk
• Reporter: Khurram Faraaz
• Reviewer: Khurram Faraaz
• Created: 10/Oct/16 13:25
• Updated: 28/Mar/17 03:51
• Resolved: 13/Dec/16 00:50

Description

We need a better error message instead of DrillRuntimeException
Drill 1.9.0 git commit ID : 4edabe7a

0: jdbc:drill:schema=dfs.tmp> select (res1 = 2016/09/22) res2
. . . . . . . . . . . . . . > from
. . . . . . . . . . . . . . > (
. . . . . . . . . . . . . . >     select (case when (false) then null else cast('2016/09/22' as date) end) res1
. . . . . . . . . . . . . . >     from (values(1)) foo
. . . . . . . . . . . . . . > ) foobar;
Error: SYSTEM ERROR: DrillRuntimeException: Failure while materializing expression in constant expression evaluator [CASE(false, =(null, /(/(2016, 9), 22)), =(CAST('2016/09/22'):DATE NOT NULL, /(/(2016, 9), 22)))].  Errors:
Error in expression at index -1.  Error: Missing function implementation: [castTIMESTAMP(INT-REQUIRED)].  Full expression: --UNKNOWN EXPRESSION--.
Error in expression at index -1.  Error: Missing function implementation: [castTIMESTAMP(INT-REQUIRED)].  Full expression: --UNKNOWN EXPRESSION--.

Issue Links

• links to: GitHub Pull Request #689