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:
Powered by Jetty://
Please see attached picture.
I can only find the reason from drillbit.log:
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..."