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

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Query Planning & Optimization
• Assignee: Unassigned
• Reporter: Abhishek Girish
• Created: 10/Apr/15 18:37
• Updated: 01/Oct/15 16:38

Description

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

column ss_net_profit is of type double.

> 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)

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