Return-Path: X-Original-To: apmail-drill-issues-archive@minotaur.apache.org Delivered-To: apmail-drill-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id B424417A00 for ; Fri, 10 Oct 2014 23:57:58 +0000 (UTC) Received: (qmail 33884 invoked by uid 500); 10 Oct 2014 23:57:58 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 33858 invoked by uid 500); 10 Oct 2014 23:57:58 -0000 Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.incubator.apache.org Delivered-To: mailing list issues@drill.incubator.apache.org Received: (qmail 33849 invoked by uid 99); 10 Oct 2014 23:57:58 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Oct 2014 23:57:58 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 10 Oct 2014 23:57:36 +0000 Received: (qmail 32278 invoked by uid 99); 10 Oct 2014 23:57:34 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Oct 2014 23:57:34 +0000 Date: Fri, 10 Oct 2014 23:57:34 +0000 (UTC) From: "Venkata krishnan Sowrirajan (JIRA)" To: issues@drill.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (DRILL-1527) Explain plan on a Create query fails MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org Venkata krishnan Sowrirajan created DRILL-1527: -------------------------------------------------- Summary: Explain plan on a Create query fails Key: DRILL-1527 URL: https://issues.apache.org/jira/browse/DRILL-1527 Project: Apache Drill Issue Type: Bug Components: Query Planning & Optimization Affects Versions: 0.6.0 Reporter: Venkata krishnan Sowrirajan 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 (v6.3.4#6332)