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

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.4.0
• Fix Version/s: 1.15.0
• Component/s: Query Planning & Optimization

Environment

Centos 6.4 x86 64bit
MapR 3.1.1
drill 0.4.0

• Assignee: Unassigned
• Reporter: Hao Zhu
• Created: 21/Aug/14 22:16
• Updated: 31/Dec/18 17:54
• Resolved: 31/Dec/18 17:54

Description

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:

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.

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..."