[
https://issues.apache.org/jira/browse/DRILL-1373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14218878#comment-14218878
]
Deneche A. Hakim commented on DRILL-1373:
-----------------------------------------
I started looking into this issue, it seems that sqlline removes the semi-colon
when passing the query to Drill.
I think, if the web UI displayed a proper error message, it could help the user
avoid this problem all together. An example of a proper error message would be:
{code}
Failure while parsing sql : Encountered ";" at line 1, column 15.
Was expecting one of:
<EOF>
"LIKE" ...
"WHERE" ...
{code}
> Executing a query with a semi-colon as the last character causes 500 error in
> the query GUI
> -------------------------------------------------------------------------------------------
>
> Key: DRILL-1373
> URL: https://issues.apache.org/jira/browse/DRILL-1373
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - HTTP
> Affects Versions: 0.4.0
> Environment: MapR Hadoop 3.1.1
> Reporter: Michael England
> Assignee: Deneche A. Hakim
> Priority: Minor
> Labels: 500, admin, colon, error, failed, gui, http, query,
> request, semi
> Fix For: 0.8.0
>
>
> Attempting to execute a query on the Query GUI page (http://node:8047/query)
> that contains a semi-colon at the end of the query statement results in a 500
> error.
> e.g. select count(*) from storageplugin.workspace;
> Removing the semi-colon returns the query result successfully.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
