Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-1321

SQL ending with semicolon will fail on Web Query GUI page

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 0.4.0
    • Fix Version/s: 1.15.0
    • Labels:
      None
    • Environment:

      Centos 6.4 x86 64bit
      MapR 3.1.1
      drill 0.4.0

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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              haozhu Hao Zhu
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: