[jira] [Updated] (DRILL-1321) SQL ending with semicolon will fail on Web Query GUI page

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-1321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Nadeau updated DRILL-1321:
----------------------------------
    Fix Version/s: Future

> SQL ending with semicolon will fail on Web Query GUI page
> ---------------------------------------------------------
>
>                 Key: DRILL-1321
>                 URL: https://issues.apache.org/jira/browse/DRILL-1321
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>    Affects Versions: 0.4.0
>         Environment: Centos 6.4 x86 64bit
> MapR 3.1.1
> drill 0.4.0
>            Reporter: Hao Zhu
>            Priority: Minor
>             Fix For: Future
>
>         Attachments: Screen Shot 2014-08-21 at 2.27.46 PM.png
>
>
> When running a SQL ending with semicolon in query Web GUI, for example:SELECT * FROM dfs.`/mynamevol/region.parquet`;
> The webpage will fail with below error page:
> "
> HTTP ERROR 500
> Problem accessing /query. Reason:
>     Request failed.
> Powered by Jetty://
> "
> Please see attached picture.
> I can only find the reason from drillbit.log:
> {code}
> 2014-08-21 13:37:51,983 [8cc1afb1-37b8-491b-99f3-34529f88ed87:foreman] ERROR o.a.drill.exec.work.foreman.Foreman - Error 8937853c-596e-43fb-8db7-5f544cd5de6a: Failure while parsing sql.
> org.eigenbase.sql.parser.SqlParseException: Encountered ";" at line 1, column 46.
> {code}
> This SQL works fine in sqlline CLI. 
> If we remove ";", then the SQL works fine in web query GUI also.
> So here are 2 issues:
> 1. web query GUI should not fail for SQL ending with ";".
> 2. even if it should fail, web query GUI should provide better error message, For example: "syntax error..."
>  



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)