drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pavel Semenov (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (DRILL-7144) sqlline option : !set useLineContinuation false, fails with ParseException
Date Tue, 14 May 2019 15:18:00 GMT

     [ https://issues.apache.org/jira/browse/DRILL-7144?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Pavel Semenov closed DRILL-7144.
--------------------------------

> 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)

Mime
View raw message