[DRILL-4914] need better error message to handle invalid inputs to AGE function

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.9.0
• Component/s: Execution - Flow
• Assignee: Unassigned
• Reporter: Khurram Faraaz
• Created: 29/Sep/16 10:53
• Updated: 29/Sep/16 10:53

Description

Need a better error message when invalid inputs are given to AGE function
Drill 1.9.0

0: jdbc:drill:schema=dfs.tmp> SELECT AGE(-1) FROM `date_data.csv`;
Error: SYSTEM ERROR: DrillRuntimeException: Failure while materializing expression in constant expression evaluator [AGE(-1)].  Errors:
Error in expression at index -1.  Error: Missing function implementation: [castTIMESTAMP(INT-REQUIRED)].  Full expression: --UNKNOWN EXPRESSION--.


[Error Id: 4f91d5cc-95b1-4bad-903e-138facea5f63 on centos-01.qa.lab:31010] (state=,code=0)

0: jdbc:drill:schema=dfs.tmp> SELECT AGE(0) FROM `date_data.csv`;
Error: SYSTEM ERROR: DrillRuntimeException: Failure while materializing expression in constant expression evaluator [AGE(0)].  Errors:
Error in expression at index -1.  Error: Missing function implementation: [castTIMESTAMP(INT-REQUIRED)].  Full expression: --UNKNOWN EXPRESSION--.


[Error Id: c641647d-ef6b-4847-aaea-2de4af646a9c on centos-01.qa.lab:31010] (state=,code=0)