[jira] [Commented] (DRILL-1373) Executing a query with a semi-colon as the last character causes 500 error in the query GUI

["Deneche A. Hakim (JIRA)" <ji...@apache.org>]

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