[
https://issues.apache.org/jira/browse/DRILL-7144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16839532#comment-16839532
]
Pavel Semenov commented on DRILL-7144:
--------------------------------------
Verified in v1.15.0 and v1.17.0 - java.lang.IllegalArgumentException does *not*
appear
After using query in "two rows" format, like -
{code}
select * from sys.version
select * from sys.version
{code}
"PARSE ERROR" still appears, as in v1.15.0 and v1.17.0, but it is a known
SqlLine issue https://github.com/julianhyde/sqlline/issues/237
> 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
> Fix For: 1.16.0
>
>
> 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)
