[ https://issues.apache.org/jira/browse/DRILL-1321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arina Ielchiieva resolved DRILL-1321. ------------------------------------- Resolution: Fixed > 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: 1.15.0 > > 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 (v7.6.3#76005)