[jira] [Created] (DRILL-2752) Error message must be improved when incompatible types are used in an expression

["Abhishek Girish (JIRA)" <ji...@apache.org>]

Abhishek Girish created DRILL-2752:
--------------------------------------

             Summary: Error message must be improved when incompatible types are used in an expression
                 Key: DRILL-2752
                 URL: https://issues.apache.org/jira/browse/DRILL-2752
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
            Reporter: Abhishek Girish
            Assignee: Jinfeng Ni
            Priority: Minor


Query with a filter expression containing incompatible types must fail gracefully. 

column ss_net_profit  is of type double.
{code:sql}

> select * from store_sales  where ss_net_profit = 'abc' limit 1;
Query failed: RemoteRpcException: Failure while running fragment., abc [ 2206cb8a-1f5f-4c4e-9906-8b84237291c4 on abhi8.qa.lab:31010 ]
[ 2206cb8a-1f5f-4c4e-9906-8b84237291c4 on abhi8.qa.lab:31010 ]
Error: exception while executing query: Failure while executing query. (state=,code=0)
{code}

Error message must indicate that the value provided is of incompatible type. 




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