[jira] [Created] (DRILL-2846) Parse errors result in system error and messages printed multiple times

["Victoria Markman (JIRA)" <ji...@apache.org>]

Victoria Markman created DRILL-2846:
---------------------------------------

             Summary: Parse errors result in system error and messages printed multiple times
                 Key: DRILL-2846
                 URL: https://issues.apache.org/jira/browse/DRILL-2846
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 0.9.0
            Reporter: Victoria Markman


Easy reproduction: select without from clause:

{code}
0: jdbc:drill:schema=dfs> select * sys.options limit 1;
Query failed: SYSTEM ERROR: Failure parsing SQL. Encountered "." at line 1, column 13.
Was expecting one of:
    "FROM" ...
    "," ...
    


[0057de65-930f-45f3-9c13-5ece6be3da2b on atsqa4-133.qa.lab:31010]

  (org.apache.drill.exec.planner.sql.QueryInputException) Failure parsing SQL. Encountered "." at line 1, column 13.
Was expecting one of:
    "FROM" ...
    "," ...
    
    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():124
    org.apache.drill.exec.work.foreman.Foreman.runSQL():772
    org.apache.drill.exec.work.foreman.Foreman.run():204
    java.util.concurrent.ThreadPoolExecutor.runWorker():1145
    java.util.concurrent.ThreadPoolExecutor$Worker.run():615
    java.lang.Thread.run():745
  Caused By (org.eigenbase.sql.parser.SqlParseException) Encountered "." at line 1, column 13.
Was expecting one of:
    "FROM" ...
    "," ...
    
    org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.convertException():335
    org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.normalizeException():71
    org.eigenbase.sql.parser.SqlParser.parseStmt():178
    net.hydromatic.optiq.prepare.PlannerImpl.parse():167
    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():122
    org.apache.drill.exec.work.foreman.Foreman.runSQL():772
    org.apache.drill.exec.work.foreman.Foreman.run():204
    java.util.concurrent.ThreadPoolExecutor.runWorker():1145
    java.util.concurrent.ThreadPoolExecutor$Worker.run():615
    java.lang.Thread.run():745
  Caused By (org.apache.drill.exec.planner.sql.parser.impl.ParseException) Encountered "." at line 1, column 13.
Was expecting one of:
    "FROM" ...
    "," ...
    
    org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.generateParseException():16642
    org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.jj_consume_token():16471
    org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.SqlSelect():1001
    org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.LeafQuery():525
    org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.LeafQueryOrExpr():2401
    org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.QueryOrExpr():2320
    org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.OrderedQueryOrExpr():443
    org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.SqlStmt():701
    org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.SqlStmtEof():743
    org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.parseSqlStmtEof():130
    org.apache.drill.exec.planner.sql.parser.impl.DrillParserWithCompoundIdConverter.parseSqlStmtEof():59
    org.eigenbase.sql.parser.SqlParser.parseStmt():171
    net.hydromatic.optiq.prepare.PlannerImpl.parse():167
    org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():122
    org.apache.drill.exec.work.foreman.Foreman.runSQL():772
    org.apache.drill.exec.work.foreman.Foreman.run():204
    java.util.concurrent.ThreadPoolExecutor.runWorker():1145
    java.util.concurrent.ThreadPoolExecutor$Worker.run():615
    java.lang.Thread.run():745
Error: exception while executing query: Failure while executing query. (state=,code=0)
{code}

#Sat Apr 18 21:26:53 EDT 2015
git.commit.id.abbrev=9ec257e



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)