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

["Hao Zhu (JIRA)" <ji...@apache.org>]

Hao Zhu created DRILL-1321:
------------------------------

             Summary: 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
         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.2#6252)