[DRILL-497] Query with "!=" fails

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 1.0.0
• Fix Version/s: 0.4.0
• Component/s: Functions - Drill

Environment

CentOS release 6.2

• Assignee: Jacques Nadeau
• Reporter: Krystal
• Created: 09/Apr/14 22:46
• Updated: 20/Apr/15 18:34
• Resolved: 29/May/14 15:45

Description

Ran the following query via jdbc/sqlline:
select distinct(registration) from voter where registration != 'independent';

Got the following error:
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "34efdf20-56fe-4bf3-a66f-d0dbf4744814"
endpoint {
address: "qa-node56.qa.lab"
user_port: 31010
control_port: 31011
data_port: 31012
}
error_type: 0
message: "Failure while parsing sql. < SqlParseException:[ Lexical error at line 1, column 61. Encountered: \"!\" (33), after : \"\" ] < TokenMgrError:[ Lexical error at line 1, column 61. Encountered: \"!\" (33), after : \"\" ]"
]
Error: exception while executing query (state=,code=0)