You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Arina Ielchiieva (JIRA)" <ji...@apache.org> on 2019/04/08 15:15:00 UTC
[jira] [Resolved] (DRILL-7144) sqlline option : !set
useLineContinuation false, fails with ParseException
[ https://issues.apache.org/jira/browse/DRILL-7144?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arina Ielchiieva resolved DRILL-7144.
-------------------------------------
Resolution: Fixed
> sqlline option : !set useLineContinuation false, fails with ParseException
> --------------------------------------------------------------------------
>
> Key: DRILL-7144
> URL: https://issues.apache.org/jira/browse/DRILL-7144
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.13.0, 1.15.0
> Reporter: Khurram Faraaz
> Assignee: Arina Ielchiieva
> Priority: Major
>
> sqlline option does not work as intended. Returns ParseException instead.
> !set useLineContinuation false
> On mapr-drill-1.13.0 we hit the below Exception.
> {noformat}
> 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.
> {noformat}
> It does not work on drill-1.15.0-mapr-r1
> git.branch=drill-1.15.0-mapr-r1
> git.commit.id=ebc9fe49d4477b04701fdd81884d5a0b748a13ae
> {noformat}
> [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)
> {noformat}
> {noformat}
> [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
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)