Abhishek Girish created DRILL-987:
-------------------------------------
Summary: Commands with Unicode characters fail with
SqlParseException
Key: DRILL-987
URL: https://issues.apache.org/jira/browse/DRILL-987
Project: Apache Drill
Issue Type: Bug
Components: SQL Parser
Reporter: Abhishek Girish
On running a create command which contained unicode space '\u00a0', I hit an
SQL parse exception
Succeeds:
> reate view customer_temp1 as select cast(columns[0] as integer) as
> c_customer_sk from `/user/root/cust.tbl`;
Fails:
> create view customer_temp1 as select cast(columns[0] as integer) as
> c_customer_sk from `/user/root/cust.tbl`;
Error message:
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
running query.[error_id: "368ac0bc-143e-4509-937e-af09677eefad"
endpoint {
address: "drillats2.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 69. Encountered: "\u00a0" (160), after : "" ] < TokenMgrError:[
Lexical error at line 1, column 69. Encountered: "\u00a0" (160), after : "" ]"
]
Error: exception while executing query (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
