[jira] [Created] (DRILL-4914) need better error message to handle invalid inputs to AGE function

[Khurram Faraaz (JIRA)]

Khurram Faraaz created DRILL-4914:
-------------------------------------

             Summary: need better error message to handle invalid inputs to AGE 
function
                 Key: DRILL-4914
                 URL: https://issues.apache.org/jira/browse/DRILL-4914
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Flow
    Affects Versions: 1.9.0
            Reporter: Khurram Faraaz
            Priority: Minor


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

{noformat}
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)
{noformat}

{noformat}
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)
{noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)