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