Khurram Faraaz created DRILL-7144:
-------------------------------------
Summary: 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.15.0, 1.13.0
Reporter: Khurram Faraaz
Assignee: Arina Ielchiieva
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)
