You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Igor Guzenko (Jira)" <ji...@apache.org> on 2020/02/20 11:59:00 UTC
[jira] [Resolved] (DRILL-1527) Add explain plan support for non
SELECT queries (such as CREATE)
[ https://issues.apache.org/jira/browse/DRILL-1527?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Igor Guzenko resolved DRILL-1527.
---------------------------------
Resolution: Duplicate
Duplicates DRILL-767.
> Add explain plan support for non SELECT queries (such as CREATE)
> ----------------------------------------------------------------
>
> Key: DRILL-1527
> URL: https://issues.apache.org/jira/browse/DRILL-1527
> Project: Apache Drill
> Issue Type: Improvement
> Components: Query Planning & Optimization
> Affects Versions: 0.6.0
> Reporter: Venkata krishnan Sowrirajan
> Priority: Major
> Fix For: Future
>
>
> Query:
> explain plan for create table `data1` as select * from `data.json` limit 100;
> Error:
> 2014-10-10 15:54:58,329 [00c88dde-39fb-43a9-856f-1ec573b1201e:foreman] ERROR o.a.drill.exec.work.foreman.Foreman - Error 74e0987a-38ff-46c9-80c1-4522c7e2d2a5: Failure while parsing sql.
> org.eigenbase.sql.parser.SqlParseException: Encountered "create" at line 1, column 18.
> at org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.convertException(DrillParserImpl.java:328) ~[drill-java-exec-0.6.0-incubating-SNAPSHOT-rebuffed.jar:0.6.0-incubating-SNAPSHOT]
> at org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.normalizeException(DrillParserImpl.java:70) ~[drill-java-exec-0.6.0-incubating-SNAPSHOT-rebuffed.jar:0.6.0-incubating-SNAPSHOT]
> at org.eigenbase.sql.parser.SqlParser.parseStmt(SqlParser.java:150) ~[optiq-core-0.9-drill-r4.jar:na]
> at net.hydromatic.optiq.prepare.PlannerImpl.parse(PlannerImpl.java:164) ~[optiq-core-0.9-drill-r4.jar:na]
> at org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:109) ~[drill-java-exec-0.6.0-incubating-SNAPSHOT-rebuffed.jar:0.6.0-incubating-SNAPSHOT]
> at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:425) [drill-java-exec-0.6.0-incubating-SNAPSHOT-rebuffed.jar:0.6.0-incubating-SNAPSHOT]
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:219) [drill-java-exec-0.6.0-incubating-SNAPSHOT-rebuffed.jar:0.6.0-incubating-SNAPSHOT]
> at org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:250) [drill-java-exec-0.6.0-incubating-SNAPSHOT-rebuffed.jar:0.6.0-incubating-SNAPSHOT]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_65]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_65]
> at java.lang.Thread.run(Thread.java:745) [na:1.7.0_65]
> Caused by: org.apache.drill.exec.planner.sql.parser.impl.ParseException: Encountered "create" at line 1, column 18.
> Was expecting one of:...
> at org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.generateParseException(DrillParserImpl.java:16635) ~[drill-java-exec-0.6.0-incubating-SNAPSHOT-rebuffed.jar:0.6.0-incubating-SNAPSHOT]
> at org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.jj_consume_token(DrillParserImpl.java:16464) ~[drill-java-exec-0.6.0-incubating-SNAPSHOT-rebuffed.jar:0.6.0-incubating-SNAPSHOT]
> at org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.SqlExplain(DrillParserImpl.java:1053) ~[drill-java-exec-0.6.0-incubating-SNAPSHOT-rebuffed.jar:0.6.0-incubating-SNAPSHOT]
> at org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.SqlStmt(DrillParserImpl.java:696) ~[drill-java-exec-0.6.0-incubating-SNAPSHOT-rebuffed.jar:0.6.0-incubating-SNAPSHOT]
> at org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.SqlStmtEof(DrillParserImpl.java:736) ~[drill-java-exec-0.6.0-incubating-SNAPSHOT-rebuffed.jar:0.6.0-incubating-SNAPSHOT]
> at org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.parseSqlStmtEof(DrillParserImpl.java:123) ~[drill-java-exec-0.6.0-incubating-SNAPSHOT-rebuffed.jar:0.6.0-incubating-SNAPSHOT]
> at org.apache.drill.exec.planner.sql.parser.impl.DrillParserWithCompoundIdConverter.parseSqlStmtEof(DrillParserWithCompoundIdConverter.java:55) ~[drill-java-exec-0.6.0-incubating-SNAPSHOT-rebuffed.jar:0.6.0-incubating-SNAPSHOT]
> at org.eigenbase.sql.parser.SqlParser.parseStmt(SqlParser.java:143) ~[optiq-core-0.9-drill-r4.jar:na]
> ... 8 common frames omitted
--
This message was sent by Atlassian Jira
(v8.3.4#803005)