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

sqlline option : !set useLineContinuation false, fails with ParseException

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.13.0, 1.15.0
    • Fix Version/s: 1.16.0
    • Component/s: None
    • Labels:
      None

      Description

      sqlline option does not work as intended. Returns ParseException instead.
      !set useLineContinuation false

      On mapr-drill-1.13.0 we hit the below Exception.

      0: jdbc:drill:drillbit=drill-abcd-dev.dev.schw> !set useLineContinuation false
      Error setting configuration: useLineContinuation: java.lang.IllegalArgumentException: No method matching "setuseLineContinuation" was found in sqlline.SqlLineOpts.
      

      It does not work on drill-1.15.0-mapr-r1

      git.branch=drill-1.15.0-mapr-r1
      git.commit.id=ebc9fe49d4477b04701fdd81884d5a0b748a13ae

      [test@test-ab bin]# ./sqlline -u "jdbc:drill:schema=dfs.tmp;auth=MAPRSASL;drillbit=test-ab.qa.lab" -n mapr -p mapr
      Apache Drill 1.15.0.3-mapr
      "Start your SQL engine."
      0: jdbc:drill:schema=dfs.tmp> !set useLineContinuation false
      0: jdbc:drill:schema=dfs.tmp> select * from sys.version
      > select * from sys.memory
      Error: PARSE ERROR: Encountered "select" at line 2, column 1.
      Was expecting one of:
       <EOF>
       "ORDER" ...
       "LIMIT" ...
       "OFFSET" ...
       "FETCH" ...
       "NATURAL" ...
       "JOIN" ...
       "INNER" ...
       "LEFT" ...
       "RIGHT" ...
       "FULL" ...
       "CROSS" ...
       "," ...
       "OUTER" ...
       "EXTEND" ...
       "(" ...
       "MATCH_RECOGNIZE" ...
       "AS" ...
       <IDENTIFIER> ...
       <QUOTED_IDENTIFIER> ...
       <BACK_QUOTED_IDENTIFIER> ...
       <BRACKET_QUOTED_IDENTIFIER> ...
       <UNICODE_QUOTED_IDENTIFIER> ...
       "TABLESAMPLE" ...
       "WHERE" ...
       "GROUP" ...
       "HAVING" ...
       "WINDOW" ...
       "UNION" ...
       "INTERSECT" ...
       "EXCEPT" ...
       "MINUS" ...
       "." ...
       "[" ...
      
      
      SQL Query select * from sys.version
      select * from sys.memory
      ^
      
      [Error Id: 067d5402-b965-4660-8981-34491ab5a051 on test-ab.qa.lab:31010] (state=,code=0)
      
      [Error Id: 067d5402-b965-4660-8981-34491ab5a051 ]
       at org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:633) ~[drill-common-1.15.0.3-mapr.jar:1.15.0.3-mapr]
       at org.apache.drill.exec.planner.sql.SqlConverter.parse(SqlConverter.java:185) [drill-java-exec-1.15.0.3-mapr.jar:1.15.0.3-mapr]
       at org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:138) [drill-java-exec-1.15.0.3-mapr.jar:1.15.0.3-mapr]
       at org.apache.drill.exec.planner.sql.DrillSqlWorker.convertPlan(DrillSqlWorker.java:110) [drill-java-exec-1.15.0.3-mapr.jar:1.15.0.3-mapr]
       at org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:76) [drill-java-exec-1.15.0.3-mapr.jar:1.15.0.3-mapr]
       at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:584) [drill-java-exec-1.15.0.3-mapr.jar:1.15.0.3-mapr]
       at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:272) [drill-java-exec-1.15.0.3-mapr.jar:1.15.0.3-mapr]
       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_151]
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_151]
       at java.lang.Thread.run(Thread.java:748) [na:1.8.0_151]
      Caused by: org.apache.calcite.sql.parser.SqlParseException: Encountered "select" at line 2, column 1.
      Was expecting one of:
       <EOF>
       "ORDER" ...
       "LIMIT" ...
       "OFFSET" ...
       "FETCH" ...
       ...
       "[" ...
      
      at org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.convertException(DrillParserImpl.java:350) ~[drill-java-exec-1.15.0.3-mapr.jar:1.15.0.3-mapr]
       at org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.normalizeException(DrillParserImpl.java:131) ~[drill-java-exec-1.15.0.3-mapr.jar:1.15.0.3-mapr]
       at org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:137) ~[calcite-core-1.17.0-drill-r2.jar:1.17.0-drill-r2]
       at org.apache.calcite.sql.parser.SqlParser.parseStmt(SqlParser.java:162) ~[calcite-core-1.17.0-drill-r2.jar:1.17.0-drill-r2]
       at org.apache.drill.exec.planner.sql.SqlConverter.parse(SqlConverter.java:177) [drill-java-exec-1.15.0.3-mapr.jar:1.15.0.3-mapr]
       ... 8 common frames omitted
      Caused by: org.apache.drill.exec.planner.sql.parser.impl.ParseException: Encountered "select" at line 2, column 1.
      Was expecting one of:
       <EOF>
       "ORDER" ...
       "LIMIT" ...
       "OFFSET" ...
       "FETCH" ...
       "NATURAL" ...
       ...
       ...
       "[" ...
      
      at org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.generateParseException(DrillParserImpl.java:24076) ~[drill-java-exec-1.15.0.3-mapr.jar:1.15.0.3-mapr]
       at org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.jj_consume_token(DrillParserImpl.java:23893) ~[drill-java-exec-1.15.0.3-mapr.jar:1.15.0.3-mapr]
       at org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.SqlStmtEof(DrillParserImpl.java:899) ~[drill-java-exec-1.15.0.3-mapr.jar:1.15.0.3-mapr]
       at org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.parseSqlStmtEof(DrillParserImpl.java:187) ~[drill-java-exec-1.15.0.3-mapr.jar:1.15.0.3-mapr]
       at org.apache.drill.exec.planner.sql.parser.impl.DrillParserWithCompoundIdConverter.parseSqlStmtEof(DrillParserWithCompoundIdConverter.java:59) ~[drill-java-exec-1.15.0.3-mapr.jar:1.15.0.3-mapr]
       at org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:130) ~[calcite-core-1.17.0-drill-r2.jar:1.17.0-drill-r2]
       ... 10 common frames omitted
      

        Attachments

          Activity

            People

            • Assignee:
              arina Arina Ielchiieva
              Reporter:
              khfaraaz Khurram Faraaz
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: