Return-Path: X-Original-To: apmail-incubator-drill-user-archive@minotaur.apache.org Delivered-To: apmail-incubator-drill-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 50FD411E08 for ; Fri, 27 Jun 2014 13:33:49 +0000 (UTC) Received: (qmail 76954 invoked by uid 500); 27 Jun 2014 13:33:49 -0000 Delivered-To: apmail-incubator-drill-user-archive@incubator.apache.org Received: (qmail 76901 invoked by uid 500); 27 Jun 2014 13:33:49 -0000 Mailing-List: contact drill-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: drill-user@incubator.apache.org Delivered-To: mailing list drill-user@incubator.apache.org Received: (qmail 76888 invoked by uid 99); 27 Jun 2014 13:33:48 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Jun 2014 13:33:48 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of mufeed.usman@gmail.com designates 209.85.214.169 as permitted sender) Received: from [209.85.214.169] (HELO mail-ob0-f169.google.com) (209.85.214.169) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Jun 2014 13:33:43 +0000 Received: by mail-ob0-f169.google.com with SMTP id wp18so5582986obc.14 for ; Fri, 27 Jun 2014 06:33:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=GxgPx3EKx1CynzONb5R3dHODSRAJkKU06OZZJDTBq8Y=; b=qz8RhSIKfu5pF27HpkHXnhP8jS3yeb3JAORxu2KIqjU8XGVYxcCELVax/sdT122OEh vUvdnDCNZxPxx1d3uqjzaiKkL6BsOgd4HeM6wt2lNwuHJemNG/g81DDepXm88rCa954+ cVZCUwxbTOt+/cAR1dRq34Mczu3uQSBLFxC7nxgo+4KJlaYsfXEftaxAeKGJpKjj7Nlj voDn6a71cixC7u4RX/zenrOr90Vr/c1nKqShjiAT+my4UnTXQi88PB7gAvS1+NCWNHbl eE3H1IFyJ67FwTuOb9xMk3avEjZg1jodHQb+gHw+DNPFe9X0WoyUiJAEI2dSx4OBGagy CQ2w== MIME-Version: 1.0 X-Received: by 10.60.103.173 with SMTP id fx13mr23388005oeb.25.1403876003151; Fri, 27 Jun 2014 06:33:23 -0700 (PDT) Received: by 10.60.60.37 with HTTP; Fri, 27 Jun 2014 06:33:23 -0700 (PDT) In-Reply-To: References: Date: Fri, 27 Jun 2014 19:03:23 +0530 Message-ID: Subject: Re: Query to Identify All of the Tables and Views hat Drill Can Access Fails From: mufy To: "drill-user@incubator.apache.org" Content-Type: multipart/alternative; boundary=089e010d8c7a7a079104fcd15af2 X-Virus-Checked: Checked by ClamAV on apache.org --089e010d8c7a7a079104fcd15af2 Content-Type: text/plain; charset=UTF-8 The java stack: 2014-06-27 09:22:26,809 [BitServer-1] DEBUG o.apache.drill.exec.work.WorkManager - Adding pending task org.apache.drill.exec.work.fragment.FragmentExecutor@4b36ce57 2014-06-27 09:22:26,809 [WorkManager Event Thread] DEBUG o.apache.drill.exec.work.WorkManager - Starting pending task org.apache.drill.exec.work.fragment.FragmentExecutor@4b36ce57 2014-06-27 09:22:26,810 [548e9194-6610-4c46-9a3c-b41cf5d57f88:frag:2:0] ERROR o.a.drill.exec.ops.FragmentContext - Fragment Context received failure. {} java.lang.UnsupportedOperationException: Schema tree can only be created in root fragment. This is a non-root fragment. at org.apache.drill.exec.ops.FragmentContext.getRootSchema(FragmentContext.java:127) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.store.ischema.InfoSchemaBatchCreator.getBatch(InfoSchemaBatchCreator.java:35) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.store.ischema.InfoSchemaBatchCreator.getBatch(InfoSchemaBatchCreator.java:30) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:62) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:39) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitSubScan(AbstractPhysicalVisitor.java:92) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractSubScan.accept(AbstractSubScan.java:50) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.getChildren(ImplCreator.java:74) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:62) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:39) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitProject(AbstractPhysicalVisitor.java:47) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.config.Project.accept(Project.java:53) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.getChildren(ImplCreator.java:74) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:59) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:39) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitSender(AbstractPhysicalVisitor.java:77) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitHashPartitionSender(AbstractPhysicalVisitor.java:120) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.config.HashPartitionSender.accept(HashPartitionSender.java:66) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.getExec(ImplCreator.java:87) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:81) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_55] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_55] at java.lang.Thread.run(Thread.java:744) [na:1.7.0_55] 2014-06-27 09:22:26,811 [548e9194-6610-4c46-9a3c-b41cf5d57f88:frag:2:0] ERROR o.a.drill.exec.ops.FragmentContext - Fragment Context received failure. {} java.lang.NullPointerException: null at org.apache.drill.exec.store.ischema.RecordGenerator.scanSchema(RecordGenerator.java:63) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.store.ischema.SelectedTable.getRecordReader(SelectedTable.java:46) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.store.ischema.InfoSchemaBatchCreator.getBatch(InfoSchemaBatchCreator.java:35) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.store.ischema.InfoSchemaBatchCreator.getBatch(InfoSchemaBatchCreator.java:30) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:62) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:39) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitSubScan(AbstractPhysicalVisitor.java:92) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractSubScan.accept(AbstractSubScan.java:50) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.getChildren(ImplCreator.java:74) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:62) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:39) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitProject(AbstractPhysicalVisitor.java:47) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.config.Project.accept(Project.java:53) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.getChildren(ImplCreator.java:74) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:59) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:39) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitSender(AbstractPhysicalVisitor.java:77) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitHashPartitionSender(AbstractPhysicalVisitor.java:120) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.config.HashPartitionSender.accept(HashPartitionSender.java:66) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.getExec(ImplCreator.java:87) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:81) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_55] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_55] at java.lang.Thread.run(Thread.java:744) [na:1.7.0_55] 2014-06-27 09:22:26,813 [548e9194-6610-4c46-9a3c-b41cf5d57f88:frag:2:0] DEBUG o.a.d.e.w.fragment.FragmentExecutor - Failure while initializing operator tree java.lang.NullPointerException: null at org.apache.drill.exec.store.ischema.RecordGenerator.scanSchema(RecordGenerator.java:63) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.store.ischema.SelectedTable.getRecordReader(SelectedTable.java:46) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.store.ischema.InfoSchemaBatchCreator.getBatch(InfoSchemaBatchCreator.java:35) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.store.ischema.InfoSchemaBatchCreator.getBatch(InfoSchemaBatchCreator.java:30) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:62) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:39) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitSubScan(AbstractPhysicalVisitor.java:92) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractSubScan.accept(AbstractSubScan.java:50) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.getChildren(ImplCreator.java:74) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:62) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:39) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitProject(AbstractPhysicalVisitor.java:47) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incub ating-SNAPSHOT] at org.apache.drill.exec.physical.config.Project.accept(Project.java:53) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.getChildren(ImplCreator.java:74) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:59) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:39) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitSender(AbstractPhysicalVisitor.java:77) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitHashPartitionSender(AbstractPhysicalVisitor.java:120) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.config.HashPartitionSender.accept(HashPartitionSender.java:66) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.getExec(ImplCreator.java:87) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:81) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_55] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_55] at java.lang.Thread.run(Thread.java:744) [na:1.7.0_55] 2014-06-27 09:22:26,814 [548e9194-6610-4c46-9a3c-b41cf5d57f88:frag:2:0] ERROR o.a.d.e.w.f.AbstractStatusReporter - Error d9ff80ba-7c45-4543-8476-f37dce74d33b: Failure while running fragment. java.lang.NullPointerException: null at org.apache.drill.exec.store.ischema.RecordGenerator.scanSchema(RecordGenerator.java:63) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.store.ischema.SelectedTable.getRecordReader(SelectedTable.java:46) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.store.ischema.InfoSchemaBatchCreator.getBatch(InfoSchemaBatchCreator.java:35) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.store.ischema.InfoSchemaBatchCreator.getBatch(InfoSchemaBatchCreator.java:30) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:62) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:39) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitSubScan(AbstractPhysicalVisitor.java:92) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractSubScan.accept(AbstractSubScan.java:50) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.getChildren(ImplCreator.java:74) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:62) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:39) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitProject(AbstractPhysicalVisitor.java:47) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.config.Project.accept(Project.java:53) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.getChildren(ImplCreator.java:74) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:59) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.visitOp(ImplCreator.java:39) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitSender(AbstractPhysicalVisitor.java:77) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitHashPartitionSender(AbstractPhysicalVisitor.java:120) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.config.HashPartitionSender.accept(HashPartitionSender.java:66) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.physical.impl.ImplCreator.getExec(ImplCreator.java:87) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:81) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_55] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_55] at java.lang.Thread.run(Thread.java:744) [na:1.7.0_55] 2014-06-27 09:22:26,815 [548e9194-6610-4c46-9a3c-b41cf5d57f88:frag:2:0] DEBUG o.a.d.e.w.f.NonRootStatusReporter - Sending status change message message to remote node: profile { state: FAILED error { error_id: "d9ff80ba-7c45-4543-8476-f37dce74d33b" endpoint { address: "mufeed-drill1" user_port: 31010 control_port: 31011 data_port: 31012 } error_type: 0 message: "Failure while running fragment. < NullPointerException" } start_time: 1403875346805 end_time: 1403875346813 memory_used: 0 } handle { query_id { part1: 6092967412432391238 part2: -7332788056789516408 } major_fragment_id: 2 m --- Mufeed Usman My LinkedIn | My Social Cause | My Blogs : LiveJournal On Fri, Jun 27, 2014 at 6:55 PM, mufy wrote: > Query executed was: SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE FROM > INFORMATION_SCHEMA.`TABLES` ORDER BY TABLE_NAME DESC; > > sqlline.log had the following: > 2014-06-27 09:22:26,663 [Client-1] DEBUG > o.a.d.e.rpc.user.QueryResultHandler - Received QueryId part1: > 6092967412432391238 > part2: -7332788056789516408 > succesfully. Adding listener > org.apache.drill.jdbc.DrillResultSet$Listener@7102adc0 > > drillbit.log had the following: > 2014-06-27 09:22:26,663 [WorkManager Event Thread] DEBUG > o.apache.drill.exec.work.WorkManager - Starting pending task > org.apache.drill.exec.work.foreman.Foreman@619f4fd1 > 2014-06-27 09:22:26,673 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.e.p.s.h.DefaultSqlHandler - Optiq Logical : > SortRel(sort0=[$1], dir0=[DESC]): rowcount = 100.0, cumulative cost = > {5726.20422318571 rows, 501.0 cpu, 0.0 io, 0.0 network}, id = 2531 > ProjectRel(TABLE_SCHEMA=[$1], TABLE_NAME=[$2], TABLE_TYPE=[$3]): > rowcount = 100.0, cumulative cost = {200.0 rows, 401.0 cpu, 0.0 io, 0.0 > network}, id = 2530 > EnumerableTableAccessRel(table=[[INFORMATION_SCHEMA, TABLES]]): > rowcount = 100.0, cumulative cost = {100.0 rows, 101.0 cpu, 0.0 io, 0.0 > network}, id = 2529 > > 2014-06-27 09:22:26,683 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.e.p.s.h.DefaultSqlHandler - Drill Logical : > DrillScreenRel: rowcount = 1000.0, cumulative cost = {84993.06334778565 > rows, 5112.0 cpu, 0.0 io, 0.0 network}, id = 2569 > DrillSortRel(sort0=[$1], dir0=[DESC]): rowcount = 1000.0, cumulative > cost = {84893.06334778565 rows, 5012.0 cpu, 0.0 io, 0.0 network}, id = 2568 > DrillProjectRel(TABLE_SCHEMA=[$1], TABLE_NAME=[$2], TABLE_TYPE=[$3]): > rowcount = 1000.0, cumulative cost = {2000.0 rows, 4012.0 cpu, 0.0 io, 0.0 > network}, id = 2567 > DrillScanRel(table=[[INFORMATION_SCHEMA, TABLES]], > groupscan=[TABLEScolumns=null]): rowcount = 1000.0, cumulative cost = > {1000.0 rows, 4000.0 cpu, 0.0 io, 0.0 network}, id = 2560 > > 2014-06-27 09:22:26,736 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.e.p.s.h.DefaultSqlHandler - Drill Physical : > 00-00 Screen: rowcount = 1000.0, cumulative cost = {7100.0 rows, > 75326.98714153297 cpu, 0.0 io, 2.4576E7 network}, id = 2698 > 00-01 Project(TABLE_SCHEMA=[$0], TABLE_NAME=[$1], TABLE_TYPE=[$2]): > rowcount = 1000.0, cumulative cost = {7000.0 rows, 75226.98714153297 cpu, > 0.0 io, 2.4576E7 network}, id = 2697 > 00-02 SingleMergeExchange(sort0=[1 DESC]): rowcount = 1000.0, > cumulative cost = {6000.0 rows, 75214.98714153297 cpu, 0.0 io, 2.4576E7 > network}, id = 2696 > 01-01 SelectionVectorRemover: rowcount = 1000.0, cumulative cost > = {5000.0 rows, 60875.13713864835 cpu, 0.0 io, 1.2288E7 network}, id = 2695 > 01-02 Sort(sort0=[$1], dir0=[DESC]): rowcount = 1000.0, > cumulative cost = {4000.0 rows, 59875.13713864835 cpu, 0.0 io, 1.2288E7 > network}, id = 2694 > 01-03 HashToRandomExchange(dist0=[[$1]]): rowcount = 1000.0, > cumulative cost = {3000.0 rows, 20012.0 cpu, 0.0 io, 1.2288E7 network}, id > = 2693 > 02-01 Project(TABLE_SCHEMA=[$1], TABLE_NAME=[$2], > TABLE_TYPE=[$3]): rowcount = 1000.0, cumulative cost = {2000.0 rows, 4012.0 > cpu, 0.0 io, 0.0 network}, id = 2692 > 02-02 Scan(groupscan=[TABLEScolumns=null]): rowcount = > 1000.0, cumulative cost = {1000.0 rows, 4000.0 cpu, 0.0 io, 0.0 network}, > id = 2691 > > 2014-06-27 09:22:26,739 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.e.p.s.h.DefaultSqlHandler - Drill Plan : > { > "head" : { > "version" : 1, > "generator" : { > "type" : "DefaultSqlHandler", > "info" : "" > }, > "type" : "APACHE_DRILL_PHYSICAL", > "options" : [ ], > "queue" : 0, > "resultMode" : "EXEC" > }, > "graph" : [ { > "pop" : "info-schema", > "@id" : 131074 > }, { > "pop" : "project", > "@id" : 131073, > "exprs" : [ { > "ref" : "`TABLE_SCHEMA`", > "expr" : "`TABLE_SCHEMA`" > }, { > "ref" : "`TABLE_NAME`", > "expr" : "`TABLE_NAME`" > }, { > "ref" : "`TABLE_TYPE`", > "expr" : "`TABLE_TYPE`" > } ], > "child" : 131074, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, { > "pop" : "hash-to-random-exchange", > "@id" : 65539, > "child" : 131073, > "expr" : "hash(`TABLE_NAME`) ", > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, { > "pop" : "external-sort", > "@id" : 65538, > "child" : 65539, > "orderings" : [ { > "order" : "DESC", > "expr" : "`TABLE_NAME`", > "nullDirection" : "UNSPECIFIED" > } ], > "reverse" : false, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, { > "pop" : "selection-vector-remover", > "@id" : 65537, > "child" : 65538, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, { > "pop" : "single-merge-exchange", > "@id" : 2, > "child" : 65537, > "orderings" : [ { > "order" : "DESC", > "expr" : "`TABLE_NAME`", > "nullDirection" : "UNSPECIFIED" > } ], > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, { > "pop" : "project", > "@id" : 1, > "exprs" : [ { > "ref" : "`TABLE_SCHEMA`", > "expr" : "`TABLE_SCHEMA`" > }, { > "ref" : "`TABLE_NAME`", > "expr" : "`TABLE_NAME`" > }, { > "ref" : "`TABLE_TYPE`", > "expr" : "`TABLE_TYPE`" > } ], > "child" : 2, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, { > "pop" : "screen", > "@id" : 0, > "child" : 1, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > } ] > } > 2014-06-27 09:22:26,743 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 1000000. Pop: org.apache.drill. > exec.physical.config.SingleMergeExchange@135191b > 2014-06-27 09:22:26,743 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 2000000. Pop: org.apache.drill. > exec.physical.config.SelectionVectorRemover@45033c3b > 2014-06-27 09:22:26,744 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 3000000. Pop: org.apache.drill. > exec.physical.config.ExternalSort@576768e2 > 2014-06-27 09:22:26,744 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 4000000. Pop: org.apache.drill. > exec.physical.config.HashToRandomExchange@4616fa42 > 2014-06-27 09:22:26,745 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.e.p.f.SimpleParallelizer - Remote fragment: > handle { > query_id { > part1: 6092967412432391238 > part2: -7332788056789516408 > } > major_fragment_id: 1 > minor_fragment_id: 0 > } > network_cost: 0.0 > cpu_cost: 0.0 > disk_cost: 0.0 > memory_cost: 0.0 > fragment_json: "{ > "pop" : "single-sender", > "@id" : 0, > "receiver-major-fragment" : 0, > "child" : { > "pop" : "selection-vector-remover", > "@id" : 1, > "child" : { > "pop" : "external-sort", > "@id" : 2, > "child" : { > "pop" : "random-receiver", > "@id" : 3, > "sender-major-fragment" : 2, > "senders" : [ "Cg1tdWZlZWQtZHJpbGwxEKLyARij8gEgpPIB" ], > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "orderings" : [ { > "order" : "DESC", > "expr" : "`TABLE_NAME`", > "nullDirection" : "UNSPECIFIED" > } ], > "reverse" : false, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "destination" : "Cg1tdWZlZWQtZHJpbGwxEKLyARij8gEgpPIB", > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }" > leaf_fragment: false > assignment { > address: "mufeed-drill2" > user_port: 31010 > control_port: 31011 > data_port: 31012 > } > foreman { > address: "mufeed-drill1" > user_port: 31010 > control_port: 31011 > data_port: 31012 > } > mem_initial: 4000000 > mem_max: 40000000000 > query_start_time: 1403875346743 > time_zone: 166 > options_json: "[ ]" > > 2014-06-27 09:22:26,745 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 1000000. Pop: org.apache.drill. > exec.physical.config.SingleMergeExchange@135191b > 2014-06-27 09:22:26,746 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 2000000. Pop: org.apache.drill. > exec.physical.config.SelectionVectorRemover@45033c3b > 2014-06-27 09:22:26,746 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 3000000. Pop: org.apache.drill. > exec.physical.config.ExternalSort@576768e2 > 2014-06-27 09:22:26,746 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 4000000. Pop: org.apache.drill. > exec.physical.config.HashToRandomExchange@4616fa42 > 2014-06-27 09:22:26,747 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.e.p.f.SimpleParallelizer - Remote fragment: > handle { > query_id { > part1: 6092967412432391238 > part2: -7332788056789516408 > } > major_fragment_id: 1 > minor_fragment_id: 1 > } > network_cost: 0.0 > cpu_cost: 0.0 > disk_cost: 0.0 > memory_cost: 0.0 > fragment_json: "{ > "pop" : "single-sender", > "@id" : 0, > "receiver-major-fragment" : 0, > "child" : { > "pop" : "selection-vector-remover", > "@id" : 1, > "child" : { > "pop" : "external-sort", > "@id" : 2, > "child" : { > "pop" : "random-receiver", > "@id" : 3, > "sender-major-fragment" : 2, > "senders" : [ "Cg1tdWZlZWQtZHJpbGwxEKLyARij8gEgpPIB" ], > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "orderings" : [ { > "order" : "DESC", > "expr" : "`TABLE_NAME`", > "nullDirection" : "UNSPECIFIED" > } ], > "reverse" : false, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "destination" : "Cg1tdWZlZWQtZHJpbGwxEKLyARij8gEgpPIB", > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }" > leaf_fragment: false > assignment { > address: "mufeed-drill3" > user_port: 31010 > control_port: 31011 > data_port: 31012 > } > foreman { > address: "mufeed-drill1" > user_port: 31010 > control_port: 31011 > data_port: 31012 > } > mem_initial: 4000000 > mem_max: 40000000000 > query_start_time: 1403875346743 > time_zone: 166 > options_json: "[ ]" > > 2014-06-27 09:22:26,748 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 1000000. Pop: org.apache.drill. > exec.physical.config.SingleMergeExchange@135191b > 2014-06-27 09:22:26,748 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 2000000. Pop: org.apache.drill. > exec.physical.config.SelectionVectorRemover@45033c3b > 2014-06-27 09:22:26,748 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 3000000. Pop: org.apache.drill. > exec.physical.config.ExternalSort@576768e2 > 2014-06-27 09:22:26,749 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 4000000. Pop: org.apache.drill. > exec.physical.config.HashToRandomExchange@4616fa42 > 2014-06-27 09:22:26,750 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.e.p.f.SimpleParallelizer - Remote fragment: > handle { > query_id { > part1: 6092967412432391238 > part2: -7332788056789516408 > } > major_fragment_id: 1 > minor_fragment_id: 2 > } > network_cost: 0.0 > cpu_cost: 0.0 > disk_cost: 0.0 > memory_cost: 0.0 > fragment_json: "{ > "pop" : "single-sender", > "@id" : 0, > "receiver-major-fragment" : 0, > "child" : { > "pop" : "selection-vector-remover", > "@id" : 1, > "child" : { > "pop" : "external-sort", > "@id" : 2, > "child" : { > "pop" : "random-receiver", > "@id" : 3, > "sender-major-fragment" : 2, > "senders" : [ "Cg1tdWZlZWQtZHJpbGwxEKLyARij8gEgpPIB" ], > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "orderings" : [ { > "order" : "DESC", > "expr" : "`TABLE_NAME`", > "nullDirection" : "UNSPECIFIED" > } ], > "reverse" : false, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "destination" : "Cg1tdWZlZWQtZHJpbGwxEKLyARij8gEgpPIB", > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }" > leaf_fragment: false > assignment { > address: "mufeed-drill1" > user_port: 31010 > control_port: 31011 > data_port: 31012 > } > foreman { > address: "mufeed-drill1" > user_port: 31010 > control_port: 31011 > data_port: 31012 > } > mem_initial: 4000000 > mem_max: 40000000000 > query_start_time: 1403875346743 > time_zone: 166 > options_json: "[ ]" > > 2014-06-27 09:22:26,750 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 1000000. Pop: org.apache.drill. > exec.physical.config.SingleMergeExchange@135191b > 2014-06-27 09:22:26,750 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 2000000. Pop: org.apache.drill. > exec.physical.config.SelectionVectorRemover@45033c3b > 2014-06-27 09:22:26,751 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 3000000. Pop: org.apache.drill. > exec.physical.config.ExternalSort@576768e2 > 2014-06-27 09:22:26,751 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 4000000. Pop: org.apache.drill. > exec.physical.config.HashToRandomExchange@4616fa42 > 2014-06-27 09:22:26,752 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.e.p.f.SimpleParallelizer - Remote fragment: > handle { > query_id { > part1: 6092967412432391238 > part2: -7332788056789516408 > } > major_fragment_id: 1 > minor_fragment_id: 3 > } > network_cost: 0.0 > cpu_cost: 0.0 > disk_cost: 0.0 > memory_cost: 0.0 > fragment_json: "{ > "pop" : "single-sender", > "@id" : 0, > "receiver-major-fragment" : 0, > "child" : { > "pop" : "selection-vector-remover", > "@id" : 1, > "child" : { > "pop" : "external-sort", > "@id" : 2, > "child" : { > "pop" : "random-receiver", > "@id" : 3, > "sender-major-fragment" : 2, > "senders" : [ "Cg1tdWZlZWQtZHJpbGwxEKLyARij8gEgpPIB" ], > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "orderings" : [ { > "order" : "DESC", > "expr" : "`TABLE_NAME`", > "nullDirection" : "UNSPECIFIED" > } ], > "reverse" : false, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "destination" : "Cg1tdWZlZWQtZHJpbGwxEKLyARij8gEgpPIB", > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }" > leaf_fragment: false > assignment { > address: "mufeed-drill2" > user_port: 31010 > control_port: 31011 > data_port: 31012 > } > foreman { > address: "mufeed-drill1" > user_port: 31010 > control_port: 31011 > data_port: 31012 > } > mem_initial: 4000000 > mem_max: 40000000000 > query_start_time: 1403875346743 > time_zone: 166 > options_json: "[ ]" > > 2014-06-27 09:22:26,752 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 1000000. Pop: org.apache.drill. > exec.physical.config.SingleMergeExchange@135191b > 2014-06-27 09:22:26,752 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 2000000. Pop: org.apache.drill. > exec.physical.config.SelectionVectorRemover@45033c3b > 2014-06-27 09:22:26,753 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 3000000. Pop: org.apache.drill. > exec.physical.config.ExternalSort@576768e2 > 2014-06-27 09:22:26,753 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 4000000. Pop: org.apache.drill. > exec.physical.config.HashToRandomExchange@4616fa42 > 2014-06-27 09:22:26,754 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.e.p.f.SimpleParallelizer - Remote fragment: > handle { > query_id { > part1: 6092967412432391238 > part2: -7332788056789516408 > } > major_fragment_id: 1 > minor_fragment_id: 4 > } > network_cost: 0.0 > cpu_cost: 0.0 > disk_cost: 0.0 > memory_cost: 0.0 > fragment_json: "{ > "pop" : "single-sender", > "@id" : 0, > "receiver-major-fragment" : 0, > "child" : { > "pop" : "selection-vector-remover", > "@id" : 1, > "child" : { > "pop" : "external-sort", > "@id" : 2, > "child" : { > "pop" : "random-receiver", > "@id" : 3, > "sender-major-fragment" : 2, > "senders" : [ "Cg1tdWZlZWQtZHJpbGwxEKLyARij8gEgpPIB" ], > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "orderings" : [ { > "order" : "DESC", > "expr" : "`TABLE_NAME`", > "nullDirection" : "UNSPECIFIED" > } ], > "reverse" : false, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "destination" : "Cg1tdWZlZWQtZHJpbGwxEKLyARij8gEgpPIB", > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }" > leaf_fragment: false > assignment { > address: "mufeed-drill3" > user_port: 31010 > control_port: 31011 > data_port: 31012 > } > foreman { > address: "mufeed-drill1" > user_port: 31010 > control_port: 31011 > data_port: 31012 > } > mem_initial: 4000000 > mem_max: 40000000000 > query_start_time: 1403875346743 > time_zone: 166 > options_json: "[ ]" > > 2014-06-27 09:22:26,754 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 1000000. Pop: org.apache.drill. > exec.physical.config.SingleMergeExchange@135191b > 2014-06-27 09:22:26,755 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 2000000. Pop: org.apache.drill. > exec.physical.config.SelectionVectorRemover@45033c3b > 2014-06-27 09:22:26,755 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 3000000. Pop: org.apache.drill. > exec.physical.config.ExternalSort@576768e2 > 2014-06-27 09:22:26,755 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 4000000. Pop: org.apache.drill. > exec.physical.config.HashToRandomExchange@4616fa42 > 2014-06-27 09:22:26,756 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.e.p.f.SimpleParallelizer - Remote fragment: > handle { > query_id { > part1: 6092967412432391238 > part2: -7332788056789516408 > } > major_fragment_id: 1 > minor_fragment_id: 5 > } > network_cost: 0.0 > cpu_cost: 0.0 > disk_cost: 0.0 > memory_cost: 0.0 > fragment_json: "{ > "pop" : "single-sender", > "@id" : 0, > "receiver-major-fragment" : 0, > "child" : { > "pop" : "selection-vector-remover", > "@id" : 1, > "child" : { > "pop" : "external-sort", > "@id" : 2, > "child" : { > "pop" : "random-receiver", > "@id" : 3, > "sender-major-fragment" : 2, > "senders" : [ "Cg1tdWZlZWQtZHJpbGwxEKLyARij8gEgpPIB" ], > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "orderings" : [ { > "order" : "DESC", > "expr" : "`TABLE_NAME`", > "nullDirection" : "UNSPECIFIED" > } ], > "reverse" : false, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "destination" : "Cg1tdWZlZWQtZHJpbGwxEKLyARij8gEgpPIB", > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }" > leaf_fragment: false > assignment { > address: "mufeed-drill1" > user_port: 31010 > control_port: 31011 > data_port: 31012 > } > foreman { > address: "mufeed-drill1" > user_port: 31010 > control_port: 31011 > data_port: 31012 > } > mem_initial: 4000000 > mem_max: 40000000000 > query_start_time: 1403875346743 > time_zone: 166 > options_json: "[ ]" > > 2014-06-27 09:22:26,757 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 1000000. Pop: org.apache.drill. > exec.physical.config.SingleMergeExchange@135191b > 2014-06-27 09:22:26,757 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 2000000. Pop: org.apache.drill. > exec.physical.config.SelectionVectorRemover@45033c3b > 2014-06-27 09:22:26,757 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 3000000. Pop: org.apache.drill. > exec.physical.config.ExternalSort@576768e2 > 2014-06-27 09:22:26,758 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 4000000. Pop: org.apache.drill. > exec.physical.config.HashToRandomExchange@4616fa42 > 2014-06-27 09:22:26,759 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.e.p.f.SimpleParallelizer - Remote fragment: > handle { > query_id { > part1: 6092967412432391238 > part2: -7332788056789516408 > } > major_fragment_id: 1 > minor_fragment_id: 6 > } > network_cost: 0.0 > cpu_cost: 0.0 > disk_cost: 0.0 > memory_cost: 0.0 > fragment_json: "{ > "pop" : "single-sender", > "@id" : 0, > "receiver-major-fragment" : 0, > "child" : { > "pop" : "selection-vector-remover", > "@id" : 1, > "child" : { > "pop" : "external-sort", > "@id" : 2, > "child" : { > "pop" : "random-receiver", > "@id" : 3, > "sender-major-fragment" : 2, > "senders" : [ "Cg1tdWZlZWQtZHJpbGwxEKLyARij8gEgpPIB" ], > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "orderings" : [ { > "order" : "DESC", > "expr" : "`TABLE_NAME`", > "nullDirection" : "UNSPECIFIED" > } ], > "reverse" : false, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "destination" : "Cg1tdWZlZWQtZHJpbGwxEKLyARij8gEgpPIB", > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }" > leaf_fragment: false > assignment { > address: "mufeed-drill2" > user_port: 31010 > control_port: 31011 > data_port: 31012 > } > foreman { > address: "mufeed-drill1" > user_port: 31010 > control_port: 31011 > data_port: 31012 > } > mem_initial: 4000000 > mem_max: 40000000000 > query_start_time: 1403875346743 > time_zone: 166 > options_json: "[ ]" > > 2014-06-27 09:22:26,759 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 1000000. Pop: org.apache.drill. > exec.physical.config.SingleMergeExchange@135191b > 2014-06-27 09:22:26,759 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 2000000. Pop: org.apache.drill. > exec.physical.config.SelectionVectorRemover@45033c3b > 2014-06-27 09:22:26,760 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 3000000. Pop: org.apache.drill. > exec.physical.config.ExternalSort@576768e2 > 2014-06-27 09:22:26,760 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 4000000. Pop: org.apache.drill. > exec.physical.config.HashToRandomExchange@4616fa42 > 2014-06-27 09:22:26,761 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.e.p.f.SimpleParallelizer - Remote fragment: > handle { > query_id { > part1: 6092967412432391238 > part2: -7332788056789516408 > } > major_fragment_id: 1 > minor_fragment_id: 7 > } > network_cost: 0.0 > cpu_cost: 0.0 > disk_cost: 0.0 > memory_cost: 0.0 > fragment_json: "{ > "pop" : "single-sender", > "@id" : 0, > "receiver-major-fragment" : 0, > "child" : { > "pop" : "selection-vector-remover", > "@id" : 1, > "child" : { > "pop" : "external-sort", > "@id" : 2, > "child" : { > "pop" : "random-receiver", > "@id" : 3, > "sender-major-fragment" : 2, > "senders" : [ "Cg1tdWZlZWQtZHJpbGwxEKLyARij8gEgpPIB" ], > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "orderings" : [ { > "order" : "DESC", > "expr" : "`TABLE_NAME`", > "nullDirection" : "UNSPECIFIED" > } ], > "reverse" : false, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }, > "destination" : "Cg1tdWZlZWQtZHJpbGwxEKLyARij8gEgpPIB", > "initialAllocation" : 1000000, > "maxAllocation" : 10000000000 > }" > leaf_fragment: false > assignment { > address: "mufeed-drill3" > user_port: 31010 > control_port: 31011 > data_port: 31012 > } > foreman { > address: "mufeed-drill1" > user_port: 31010 > control_port: 31011 > data_port: 31012 > } > mem_initial: 4000000 > mem_max: 40000000000 > query_start_time: 1403875346743 > time_zone: 166 > options_json: "[ ]" > > 2014-06-27 09:22:26,761 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 1000000. Pop: org.apache.drill. > exec.physical.config.SingleMergeExchange@135191b > 2014-06-27 09:22:26,762 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 2000000. Pop: org.apache.drill. > exec.physical.config.SelectionVectorRemover@45033c3b > 2014-06-27 09:22:26,762 [548e9194-6610-4c46-9a3c-b41cf5d57f88:foreman] > DEBUG o.a.d.exec.planner.fragment.Wrapper - Incrementing initialAllocation > by 1000000 to 3000000. Pop: org.apache.drill. > exec.physical.config.ExternalSort@576768e2 > ...skipping... > query_id { > part1: 6092967412432391238 > part2: -7332788056789516408 > } > major_fragment_id: 2 > minor_fragment_id: 0 > } > > 2014-06-27 09:22:26,817 [BitServer-1] DEBUG > o.a.d.exec.work.foreman.QueryManager - New fragment status was provided to > Foreman of profile { > state: FAILED > error { > error_id: "d9ff80ba-7c45-4543-8476-f37dce74d33b" > endpoint { > address: "mufeed-drill1" > user_port: 31010 > control_port: 31011 > data_port: 31012 > } > error_type: 0 > message: "Failure while running fragment. < NullPointerException" > } > start_time: 1403875346805 > end_time: 1403875346813 > memory_used: 0 > } > handle { > query_id { > part1: 6092967412432391238 > part2: -7332788056789516408 > } > major_fragment_id: 2 > minor_fragment_id: 0 > } > > (END) > > > --- > Mufeed Usman > > My LinkedIn | My > Social Cause | My Blogs : LiveJournal > > > > > > > On Fri, Jun 27, 2014 at 3:54 PM, AnilKumar B > wrote: > >> Hi Mufy, >> >> As console logs are not informative, can you please once check >> the drillbit.log and sqlline.log? >> >> >> Thanks & Regards, >> B Anil Kumar. >> >> >> On Fri, Jun 27, 2014 at 12:49 PM, mufy wrote: >> >> > What could possibly be causing the below error? >> > >> > 0: jdbc:drill:zk=mufeed-drill1:5181,mufeed-dr> SELECT TABLE_SCHEMA, >> > TABLE_NAME, TABLE_TYPE FROM INFORMATION_SCHEMA.`TABLES` ORDER BY >> TABLE_NAME >> > DESC; >> > Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure >> while >> > running query.[error_id: "8d4ec0ed-ca7f-4aa2-9b11-5c3fdcf8695c" >> > endpoint { >> > address: "mufeed-drill3" >> > user_port: 31010 >> > control_port: 31011 >> > data_port: 31012 >> > } >> > error_type: 0 >> > message: "Failure while running fragment. < NullPointerException" >> > ] >> > Error: exception while executing query (state=,code=0 >> > >> > --- >> > Mufeed Usman >> > My LinkedIn | My >> > Social Cause | My Blogs : LiveJournal >> > >> > >> > > --089e010d8c7a7a079104fcd15af2--