Krystal created DRILL-497:
-----------------------------
Summary: Query with "!=" fails
Key: DRILL-497
URL: https://issues.apache.org/jira/browse/DRILL-497
Project: Apache Drill
Issue Type: Bug
Affects Versions: 1.0.0
Environment: CentOS release 6.2
Reporter: Krystal
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)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
