Thanks for responding Aditya.
I reran with log level set to debug. Log is attached.
Thanks for any guidance you can provide.
---------- Forwarded message ----------
> From: Aditya <[email protected]>
> To: user <[email protected]>
> Cc:
> Date: Fri, 23 Jan 2015 19:46:05 -0800
> Subject: Re: Drill 0.7 | Every query hangs
> The actual error is getting masked somewhere. Could you please enable DEBUG
> logging, restart drill, re-run the query and post here any other error
> message you see.
>
> In $DRILL_HOME/conf/logback.xml, change
>
> <logger name="org.apache.drill" additivity="false">
> <level value="info" />
> <appender-ref ref="FILE" />
> </logger>
>
> to
>
> <logger name="org.apache.drill" additivity="false">
> <level value="debug" />
> <appender-ref ref="FILE" />
> </logger>
>
>
>
> On Fri, Jan 23, 2015 at 5:12 PM, Minnow Noir <[email protected]> wrote:
>
> > I'm trying to follow the "Drill in 10 Minutes" tutorial because Drill
> keeps
> > hanging.
> >
> > I have Java 7 installed on my Fedora 20 workstation.
> >
> > I downloaded 0.7 and dropped it at /opt/apache-drill-0.7.0/ .
> >
> > When I run Drill per the tutorial, it starts fine:
> >
> > bin/sqlline -u jdbc:drill:zk=local
> > Jan 23, 2015 8:01:59 PM org.glassfish.jersey.server.ApplicationHandler
> > initialize
> > INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29
> > 01:25:26...
> > sqlline version 1.1.6
> > 0: jdbc:drill:zk=local>
> >
> > However, if I try to do any type of query, it just hangs indefinitely.
> I
> > can't even use CTRL-C or CTRL-D to kill the sqlline session. I have to
> > kill the process.
> >
> > SELECT * FROM cp.`employee.json`;
> >
> >
> > I see the following error in the logs:
> >
> > 2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit
> -
> > Drillbit
> >
> >
> environment:.java.library.path=/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
> > 2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit
> -
> > Drillbit environment:.java.io.tmpdir=/tmp
> > 2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit
> -
> > Drillbit environment:.java.compiler=<NA>
> > 2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit
> -
> > Drillbit environment:.os.name=Linux
> > 2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit
> -
> > Drillbit environment:.os.arch=amd64
> > 2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit
> -
> > Drillbit environment:.os.version=3.11.10
> > 2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit
> -
> > Drillbit environment:.user.name=user
> > 2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit
> -
> > Drillbit environment:.user.home=/home/user
> > 2015-01-23 20:01:56,735 [main] INFO o.apache.drill.exec.server.Drillbit
> -
> > Drillbit environment:.user.dir=/opt/apache-drill-0.7.0
> > 2015-01-23 20:06:09,820 [WorkManager-1] ERROR
> > o.apache.drill.exec.work.WorkManager - Failure while running wrapper
> > [Foreman: 2b3d0ffe-7960-ed95-f21f-8de0052e701f]
> > java.lang.NullPointerException: null
> > at
> >
> >
> org.apache.drill.exec.work.foreman.Foreman.cancelExecutingFragments(Foreman.java:483)
> > ~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
> > at
> > org.apache.drill.exec.work.foreman.Foreman.moveToState(Foreman.java:436)
> > ~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
> > at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:194)
> > ~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
> > at
> >
> >
> org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:254)
> > ~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
> > at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
> > [na:1.7.0_45]
> > at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
> > [na:1.7.0_45]
> > at java.lang.Thread.run(Unknown Source) [na:1.7.0_45]
> >
> >
> > Any ideas?
> >
> > Thanks!
> >
>
>
2015-01-24 09:49:01,731 [main] DEBUG o.a.drill.common.config.DrillConfig -
Loading configs at the following URLs
[jar:file:/opt/apache-drill-0.7.0/jars/drill-storage-hbase-0.7.0.jar!/drill-module.conf,
jar:file:/opt/apache-drill-0.7.0/jars/drill-common-0.7.0-rebuffed.jar!/drill-module.conf,
jar:file:/opt/apache-drill-0.7.0/jars/drill-java-exec-0.7.0-rebuffed.jar!/drill-module.conf,
jar:file:/opt/apache-drill-0.7.0/jars/drill-storage-hive-core-0.7.0.jar!/drill-module.conf,
jar:file:/opt/apache-drill-0.7.0/jars/drill-mongo-storage-0.7.0.jar!/drill-module.conf,
jar:file:/opt/apache-drill-0.7.0/jars/drill-hive-exec-shaded-0.7.0.jar!/drill-module.conf]
2015-01-24 09:49:03,417 [main] DEBUG o.a.d.c.l.data.LogicalOperatorBase -
Adding Logical Operator sub types: [class
org.apache.drill.common.logical.data.Flatten, class
org.apache.drill.common.logical.data.Constant, class
org.apache.drill.common.logical.data.Store, class
org.apache.drill.common.logical.data.Filter, class
org.apache.drill.common.logical.data.Window, class
org.apache.drill.common.logical.data.Limit, class
org.apache.drill.common.logical.data.Scan, class
org.apache.drill.common.logical.data.GroupingAggregate, class
org.apache.drill.common.logical.data.Writer, class
org.apache.drill.common.logical.data.Order, class
org.apache.drill.common.logical.data.Join, class
org.apache.drill.common.logical.data.Sequence, class
org.apache.drill.common.logical.data.Union, class
org.apache.drill.common.logical.data.Project, class
org.apache.drill.common.logical.data.RunningAggregate, class
org.apache.drill.common.logical.data.Transform]
2015-01-24 09:49:03,421 [main] DEBUG o.a.d.c.l.StoragePluginConfigBase - Adding
Storage Engine Configs including [class
org.apache.drill.exec.store.hive.HiveStoragePluginConfig, class
org.apache.drill.exec.store.dfs.FileSystemConfig, class
org.apache.drill.exec.store.hbase.HBaseStoragePluginConfig, class
org.apache.drill.exec.store.ischema.InfoSchemaConfig, class
org.apache.drill.exec.store.mock.MockStorageEngineConfig, class
org.apache.drill.exec.store.dfs.FileSystemFormatConfig, class
org.apache.drill.exec.store.NamedStoragePluginConfig, class
org.apache.drill.exec.store.sys.SystemTablePluginConfig, class
org.apache.drill.exec.store.mongo.MongoStoragePluginConfig]
2015-01-24 09:49:03,423 [main] DEBUG o.a.d.c.l.FormatPluginConfigBase - Adding
Format Plugin Configs including [class
org.apache.drill.exec.store.parquet.ParquetFormatConfig, class
org.apache.drill.exec.store.easy.json.JSONFormatPlugin$JSONFormatConfig, class
org.apache.drill.exec.store.dfs.NamedFormatPluginConfig, class
org.apache.drill.exec.store.easy.text.TextFormatPlugin$TextFormatConfig]
2015-01-24 09:49:03,517 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.zookeeper.version=3.4.5-1392090, built on 09/30/2012
17:52 GMT
2015-01-24 09:49:03,517 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.host.name=localhost.localdomain
2015-01-24 09:49:03,517 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.java.version=1.7.0_45
2015-01-24 09:49:03,517 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.java.vendor=Oracle Corporation
2015-01-24 09:49:03,517 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.java.home=/opt/jre1.7.0_45-x64
2015-01-24 09:49:03,517 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit
environment:.java.class.path=/opt/apache-drill-0.7.0/conf:/opt/apache-drill-0.7.0/jars/drill-common-0.7.0-rebuffed.jar:/opt/apache-drill-0.7.0/jars/drill-hive-exec-shaded-0.7.0.jar:/opt/apache-drill-0.7.0/jars/tpch-sample-data-0.7.0.jar:/opt/apache-drill-0.7.0/jars/drill-mongo-storage-0.7.0.jar:/opt/apache-drill-0.7.0/jars/drill-storage-hive-core-0.7.0.jar:/opt/apache-drill-0.7.0/jars/drill-storage-hbase-0.7.0.jar:/opt/apache-drill-0.7.0/jars/drill-java-exec-0.7.0-rebuffed.jar:/opt/apache-drill-0.7.0/jars/drill-jdbc-0.7.0.jar:/opt/apache-drill-0.7.0/jars/drill-protocol-0.7.0-rebuffed.jar:/opt/apache-drill-0.7.0/jars/ext/zookeeper-3.4.5.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-pool2-2.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.sulky.formatting-0.9.17.jar:/opt/apache-drill-0.7.0/jars/3rdparty/snappy-java-1.0.5-M3.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-configuration-1.6.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jetty-server-9.1.5.v20140505.jar:/opt/apache-drill-0.7.0/jars/3rdparty/netty-buffer-4.0.24.Final.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jackson-xc-1.8.8.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jsp-api-2.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/log4j-over-slf4j-1.7.5.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jsch-0.1.42.jar:/opt/apache-drill-0.7.0/jars/3rdparty/hadoop-mapreduce-client-common-2.4.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/derby-10.10.1.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jackson-databind-2.4.3.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-beanutils-core-1.8.0.jar:/opt/apache-drill-0.7.0/jars/3rdparty/hibernate-validator-4.3.1.Final.jar:/opt/apache-drill-0.7.0/jars/3rdparty/netty-handler-4.0.24.Final.jar:/opt/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.lilith.logback.appender.multiplex-core-0.9.44.jar:/opt/apache-drill-0.7.0/jars/3rdparty/parquet-format-2.1.1-drill-r1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/httpclient-4.2.5.jar:/opt/apache-drill-0.7.0/jars/3rdparty/protostuff-json-1.0.8.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-math3-3.1.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/hadoop-hdfs-2.4.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/netty-transport-native-epoll-4.0.24.Final-linux-x86_64.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-pool-1.5.4.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jul-to-slf4j-1.7.5.jar:/opt/apache-drill-0.7.0/jars/3rdparty/parquet-generator-1.5.1-drill-r4.jar:/opt/apache-drill-0.7.0/jars/3rdparty/curator-framework-2.5.0.jar:/opt/apache-drill-0.7.0/jars/3rdparty/metrics-healthchecks-3.0.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/sqlline-1.1.6.jar:/opt/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.lilith.sender-0.9.44.jar:/opt/apache-drill-0.7.0/jars/3rdparty/datanucleus-rdbms-3.2.9.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-io-2.4.jar:/opt/apache-drill-0.7.0/jars/3rdparty/optiq-avatica-0.9-drill-r12.jar:/opt/apache-drill-0.7.0/jars/3rdparty/xercesImpl-2.11.0.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jsr305-1.3.9.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jackson-module-jaxb-annotations-2.4.3.jar:/opt/apache-drill-0.7.0/jars/3rdparty/antlr-runtime-3.4.jar:/opt/apache-drill-0.7.0/jars/3rdparty/freemarker-2.3.19.jar:/opt/apache-drill-0.7.0/jars/3rdparty/javassist-3.16.1-GA.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jackson-core-2.4.3.jar:/opt/apache-drill-0.7.0/jars/3rdparty/guava-14.0.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/parquet-common-1.5.1-drill-r4.jar:/opt/apache-drill-0.7.0/jars/3rdparty/metrics-core-2.1.2.jar:/opt/apache-drill-0.7.0/jars/3rdparty/javax.inject-1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jdo-api-3.0.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/hadoop-mapreduce-client-shuffle-2.4.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/metrics-servlets-3.0.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jetty-security-9.1.5.v20140505.jar:/opt/apache-drill-0.7.0/jars/3rdparty/curator-x-discovery-2.5.0.jar:/opt/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.lilith.logback.classic-0.9.44.jar:/opt/apache-drill-0.7.0/jars/3rdparty/hive-metastore-0.13.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/protostuff-core-1.0.8.jar:/opt/apache-drill-0.7.0/jars/3rdparty/config-1.0.0.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-net-3.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.lilith.data.logging.protobuf-0.9.44.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jetty-io-9.1.5.v20140505.jar:/opt/apache-drill-0.7.0/jars/3rdparty/paranamer-2.5.6.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-beanutils-1.7.0.jar:/opt/apache-drill-0.7.0/jars/3rdparty/hadoop-mapreduce-client-app-2.4.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-compiler-jdk-2.7.4.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jackson-annotations-2.4.3.jar:/opt/apache-drill-0.7.0/jars/3rdparty/xml-apis-1.4.01.jar:/opt/apache-drill-0.7.0/jars/3rdparty/hadoop-yarn-common-2.4.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jetty-servlet-9.1.5.v20140505.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jdk.tools-1.7.jar:/opt/apache-drill-0.7.0/jars/3rdparty/xmlenc-0.52.jar:/opt/apache-drill-0.7.0/jars/3rdparty/validation-api-1.0.0.GA.jar:/opt/apache-drill-0.7.0/jars/3rdparty/mondrian-data-foodmart-json-0.3.2.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jasper-compiler-5.5.23.jar:/opt/apache-drill-0.7.0/jars/3rdparty/bonecp-0.8.0.RELEASE.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-collections-3.2.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/hbase-0.94.22-drill-r1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/stax-api-1.0-2.jar:/opt/apache-drill-0.7.0/jars/3rdparty/mongo-java-driver-2.12.2.jar:/opt/apache-drill-0.7.0/jars/3rdparty/joda-time-2.3.jar:/opt/apache-drill-0.7.0/jars/3rdparty/parquet-column-1.5.1-drill-r5.jar:/opt/apache-drill-0.7.0/jars/3rdparty/antlr-2.7.7.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-codec-1.4.jar:/opt/apache-drill-0.7.0/jars/3rdparty/xz-1.0.jar:/opt/apache-drill-0.7.0/jars/3rdparty/stringtemplate-3.2.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/hive-hbase-handler-0.13.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/javassist-3.12.1.GA.jar:/opt/apache-drill-0.7.0/jars/3rdparty/hadoop-annotations-2.4.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/metrics-core-3.0.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/xalan-2.7.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/netty-codec-4.0.24.Final.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-lang3-3.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/curator-client-2.5.0.jar:/opt/apache-drill-0.7.0/jars/3rdparty/parquet-hadoop-1.5.1-drill-r4.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-cli-1.2.jar:/opt/apache-drill-0.7.0/jars/3rdparty/tpch-sample-data-0.7.0.jar:/opt/apache-drill-0.7.0/jars/3rdparty/dom4j-1.6.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/netty-transport-4.0.24.Final.jar:/opt/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.lilith.data.eventsource-0.9.44.jar:/opt/apache-drill-0.7.0/jars/3rdparty/asm-debug-all-5.0.3.jar:/opt/apache-drill-0.7.0/jars/3rdparty/hadoop-yarn-client-2.4.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/log4j-1.2.16.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jetty-continuation-9.1.1.v20140108.jar:/opt/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.lilith.logback.converter-classic-0.9.44.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-compiler-2.7.3.jar:/opt/apache-drill-0.7.0/jars/3rdparty/libthrift-0.9.0.jar:/opt/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.lilith.logback.appender.multiplex-classic-0.9.44.jar:/opt/apache-drill-0.7.0/jars/3rdparty/protobuf-java-2.5.0.jar:/opt/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.lilith.data.logging-0.9.44.jar:/opt/apache-drill-0.7.0/jars/3rdparty/parquet-encoding-1.5.1-drill-r4.jar:/opt/apache-drill-0.7.0/jars/3rdparty/metrics-jvm-3.0.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jcommander-1.30.jar:/opt/apache-drill-0.7.0/jars/3rdparty/curator-recipes-2.5.0.jar:/opt/apache-drill-0.7.0/jars/3rdparty/optiq-core-0.9-drill-r12.jar:/opt/apache-drill-0.7.0/jars/3rdparty/protostuff-api-1.0.8.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jcl-over-slf4j-1.7.5.jar:/opt/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.sulky.codec-0.9.17.jar:/opt/apache-drill-0.7.0/jars/3rdparty/mockito-all-1.9.0.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jetty-xml-9.1.1.v20140108.jar:/opt/apache-drill-0.7.0/jars/3rdparty/libfb303-0.9.0.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jetty-webapp-9.1.1.v20140108.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jackson-jaxrs-1.8.8.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jasper-runtime-5.5.23.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-httpclient-3.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/serializer-2.7.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/json-simple-1.1.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-math-2.2.jar:/opt/apache-drill-0.7.0/jars/3rdparty/metrics-json-3.0.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jline-2.10.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-el-1.0.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-lang-2.6.jar:/opt/apache-drill-0.7.0/jars/3rdparty/parquet-jackson-1.5.1-drill-r4.jar:/opt/apache-drill-0.7.0/jars/3rdparty/msgpack-0.6.6.jar:/opt/apache-drill-0.7.0/jars/3rdparty/avro-1.7.4.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jetty-http-9.1.5.v20140505.jar:/opt/apache-drill-0.7.0/jars/3rdparty/slf4j-api-1.7.5.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-compress-1.4.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jackson-jaxrs-base-2.4.3.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jetty-util-9.1.5.v20140505.jar:/opt/apache-drill-0.7.0/jars/3rdparty/hadoop-auth-2.4.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/hadoop-mapreduce-client-jobclient-2.4.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jackson-mapper-asl-1.9.11.jar:/opt/apache-drill-0.7.0/jars/3rdparty/hamcrest-core-1.3.jar:/opt/apache-drill-0.7.0/jars/3rdparty/datanucleus-api-jdo-3.2.6.jar:/opt/apache-drill-0.7.0/jars/3rdparty/httpcore-4.2.4.jar:/opt/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.lilith.data.converter-0.9.44.jar:/opt/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.sulky.io-0.9.17.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jackson-core-asl-1.9.13.jar:/opt/apache-drill-0.7.0/jars/3rdparty/netty-common-4.0.24.Final.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jta-1.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-dbcp-1.4.jar:/opt/apache-drill-0.7.0/jars/3rdparty/eigenbase-properties-1.1.4.jar:/opt/apache-drill-0.7.0/jars/3rdparty/linq4j-0.4.jar:/opt/apache-drill-0.7.0/jars/3rdparty/hadoop-yarn-server-common-2.4.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/hppc-0.4.2.jar:/opt/apache-drill-0.7.0/jars/3rdparty/hadoop-mapreduce-client-core-2.4.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/commons-digester-1.8.jar:/opt/apache-drill-0.7.0/jars/3rdparty/hadoop-common-2.4.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/jackson-jaxrs-json-provider-2.4.3.jar:/opt/apache-drill-0.7.0/jars/3rdparty/hadoop-client-2.4.1.jar:/opt/apache-drill-0.7.0/jars/3rdparty/janino-2.7.4.jar:/opt/apache-drill-0.7.0/jars/3rdparty/datanucleus-core-3.2.10.jar:/opt/apache-drill-0.7.0/jars/classb/jersey-container-jetty-servlet-2.8.jar:/opt/apache-drill-0.7.0/jars/classb/logback-core-1.0.13.jar:/opt/apache-drill-0.7.0/jars/classb/jetty-util-6.1.26.jar:/opt/apache-drill-0.7.0/jars/classb/logback-classic-1.0.13.jar:/opt/apache-drill-0.7.0/jars/classb/activation-1.1.jar:/opt/apache-drill-0.7.0/jars/classb/javax.inject-2.2.0.jar:/opt/apache-drill-0.7.0/jars/classb/jersey-guava-2.8.jar:/opt/apache-drill-0.7.0/jars/classb/hk2-utils-2.2.0.jar:/opt/apache-drill-0.7.0/jars/classb/jersey-container-servlet-core-2.8.jar:/opt/apache-drill-0.7.0/jars/classb/jersey-container-jetty-http-2.8.jar:/opt/apache-drill-0.7.0/jars/classb/jersey-mvc-2.8.jar:/opt/apache-drill-0.7.0/jars/classb/javax.ws.rs-api-2.0.jar:/opt/apache-drill-0.7.0/jars/classb/aopalliance-repackaged-2.2.0.jar:/opt/apache-drill-0.7.0/jars/classb/hk2-locator-2.2.0.jar:/opt/apache-drill-0.7.0/jars/classb/jersey-server-2.8.jar:/opt/apache-drill-0.7.0/jars/classb/hk2-api-2.2.0.jar:/opt/apache-drill-0.7.0/jars/classb/jersey-media-multipart-2.8.jar:/opt/apache-drill-0.7.0/jars/classb/codemodel-2.6.jar:/opt/apache-drill-0.7.0/jars/classb/jetty-6.1.26.jar:/opt/apache-drill-0.7.0/jars/classb/osgi-resource-locator-1.0.1.jar:/opt/apache-drill-0.7.0/jars/classb/jersey-mvc-freemarker-2.8.jar:/opt/apache-drill-0.7.0/jars/classb/jersey-client-2.8.jar:/opt/apache-drill-0.7.0/jars/classb/jaxb-api-2.2.2.jar:/opt/apache-drill-0.7.0/jars/classb/javax.annotation-api-1.2.jar:/opt/apache-drill-0.7.0/jars/classb/javax.servlet-api-3.1.0.jar:/opt/apache-drill-0.7.0/jars/classb/jersey-container-servlet-2.8.jar:/opt/apache-drill-0.7.0/jars/classb/reflections-0.9.8.jar:/opt/apache-drill-0.7.0/jars/classb/mimepull-1.9.3.jar:/opt/apache-drill-0.7.0/jars/classb/jersey-common-2.8.jar:/opt/apache-drill-0.7.0/jars/classb/high-scale-lib-1.1.1.jar
2015-01-24 09:49:03,517 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit
environment:.java.library.path=/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
2015-01-24 09:49:03,517 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.java.io.tmpdir=/tmp
2015-01-24 09:49:03,517 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.java.compiler=<NA>
2015-01-24 09:49:03,518 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.os.name=Linux
2015-01-24 09:49:03,518 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.os.arch=amd64
2015-01-24 09:49:03,518 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.os.version=3.11.10
2015-01-24 09:49:03,518 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.user.name=user
2015-01-24 09:49:03,518 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.user.home=/home/user
2015-01-24 09:49:03,518 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.user.dir=/opt/apache-drill-0.7.0
2015-01-24 09:49:03,542 [main] DEBUG o.a.drill.common.config.DrillConfig -
Loading configs at the following URLs
[jar:file:/opt/apache-drill-0.7.0/jars/drill-storage-hbase-0.7.0.jar!/drill-module.conf,
jar:file:/opt/apache-drill-0.7.0/jars/drill-common-0.7.0-rebuffed.jar!/drill-module.conf,
jar:file:/opt/apache-drill-0.7.0/jars/drill-java-exec-0.7.0-rebuffed.jar!/drill-module.conf,
jar:file:/opt/apache-drill-0.7.0/jars/drill-storage-hive-core-0.7.0.jar!/drill-module.conf,
jar:file:/opt/apache-drill-0.7.0/jars/drill-mongo-storage-0.7.0.jar!/drill-module.conf,
jar:file:/opt/apache-drill-0.7.0/jars/drill-hive-exec-shaded-0.7.0.jar!/drill-module.conf]
2015-01-24 09:49:03,554 [main] DEBUG o.a.d.c.l.data.LogicalOperatorBase -
Adding Logical Operator sub types: [class
org.apache.drill.common.logical.data.Flatten, class
org.apache.drill.common.logical.data.Constant, class
org.apache.drill.common.logical.data.Store, class
org.apache.drill.common.logical.data.Filter, class
org.apache.drill.common.logical.data.Window, class
org.apache.drill.common.logical.data.Limit, class
org.apache.drill.common.logical.data.Scan, class
org.apache.drill.common.logical.data.GroupingAggregate, class
org.apache.drill.common.logical.data.Writer, class
org.apache.drill.common.logical.data.Order, class
org.apache.drill.common.logical.data.Join, class
org.apache.drill.common.logical.data.Sequence, class
org.apache.drill.common.logical.data.Union, class
org.apache.drill.common.logical.data.Project, class
org.apache.drill.common.logical.data.RunningAggregate, class
org.apache.drill.common.logical.data.Transform]
2015-01-24 09:49:03,554 [main] DEBUG o.a.d.c.l.StoragePluginConfigBase - Adding
Storage Engine Configs including [class
org.apache.drill.exec.store.hive.HiveStoragePluginConfig, class
org.apache.drill.exec.store.dfs.FileSystemConfig, class
org.apache.drill.exec.store.hbase.HBaseStoragePluginConfig, class
org.apache.drill.exec.store.ischema.InfoSchemaConfig, class
org.apache.drill.exec.store.mock.MockStorageEngineConfig, class
org.apache.drill.exec.store.dfs.FileSystemFormatConfig, class
org.apache.drill.exec.store.NamedStoragePluginConfig, class
org.apache.drill.exec.store.sys.SystemTablePluginConfig, class
org.apache.drill.exec.store.mongo.MongoStoragePluginConfig]
2015-01-24 09:49:03,555 [main] DEBUG o.a.d.c.l.FormatPluginConfigBase - Adding
Format Plugin Configs including [class
org.apache.drill.exec.store.parquet.ParquetFormatConfig, class
org.apache.drill.exec.store.easy.json.JSONFormatPlugin$JSONFormatConfig, class
org.apache.drill.exec.store.dfs.NamedFormatPluginConfig, class
org.apache.drill.exec.store.easy.text.TextFormatPlugin$TextFormatConfig]
2015-01-24 09:49:03,943 [main] DEBUG o.a.d.e.c.l.LocalClusterCoordinator -
Local Cluster Coordinator started.
2015-01-24 09:49:03,975 [main] DEBUG o.apache.drill.exec.rpc.BasicServer -
Server started on port 31010 of type UserServer
2015-01-24 09:49:03,992 [main] DEBUG o.apache.drill.exec.rpc.BasicServer -
Server started on port 31011 of type ControlServer
2015-01-24 09:49:04,000 [main] DEBUG o.apache.drill.exec.rpc.BasicServer -
Server started on port 31012 of type DataServer
2015-01-24 09:49:04,056 [main] DEBUG o.a.d.e.p.base.PhysicalOperatorUtil -
Adding Physical Operator sub types: [class
org.apache.drill.exec.physical.config.OrderedPartitionExchange, class
org.apache.drill.exec.physical.config.UnionExchange, class
org.apache.drill.exec.physical.config.OrderedPartitionSender, class
org.apache.drill.exec.physical.config.Project, class
org.apache.drill.exec.store.mock.MockSubScanPOP, class
org.apache.drill.exec.store.ischema.InfoSchemaSubScan, class
org.apache.drill.exec.physical.config.Filter, class
org.apache.drill.exec.physical.config.Sort, class
org.apache.drill.exec.physical.config.HashToMergeExchange, class
org.apache.drill.exec.store.parquet.ParquetRowGroupScan, class
org.apache.drill.exec.store.sys.SystemTableScan, class
org.apache.drill.exec.physical.config.SingleMergeExchange, class
org.apache.drill.exec.physical.config.UnionAll, class
org.apache.drill.exec.physical.config.HashToRandomExchange, class
org.apache.drill.exec.store.hive.HiveSubScan, class
org.apache.drill.exec.physical.config.HashPartitionSender, class
org.apache.drill.exec.physical.config.BroadcastSender, class
org.apache.drill.exec.physical.config.ProducerConsumer, class
org.apache.drill.exec.physical.config.SelectionVectorRemover, class
org.apache.drill.exec.physical.config.MergeJoinPOP, class
org.apache.drill.exec.physical.config.StreamingAggregate, class
org.apache.drill.exec.physical.config.ComplexToJson, class
org.apache.drill.exec.physical.config.FlattenPOP, class
org.apache.drill.exec.physical.config.Trace, class
org.apache.drill.exec.store.parquet.ParquetWriter, class
org.apache.drill.exec.physical.config.IteratorValidator, class
org.apache.drill.exec.physical.config.Limit, class
org.apache.drill.exec.store.mock.MockGroupScanPOP, class
org.apache.drill.exec.physical.config.WindowPOP, class
org.apache.drill.exec.store.hive.HiveScan, class
org.apache.drill.exec.physical.config.MergingReceiverPOP, class
org.apache.drill.exec.store.dfs.easy.EasyWriter, class
org.apache.drill.exec.physical.config.TopN, class
org.apache.drill.exec.physical.config.SingleSender, class
org.apache.drill.exec.store.mock.MockStorePOP, class
org.apache.drill.exec.physical.config.UnorderedReceiver, class
org.apache.drill.exec.store.parquet.ParquetGroupScan, class
org.apache.drill.exec.physical.config.ExternalSort, class
org.apache.drill.exec.store.ischema.InfoSchemaGroupScan, class
org.apache.drill.exec.physical.config.RangeSender, class
org.apache.drill.exec.store.dfs.easy.EasySubScan, class
org.apache.drill.exec.store.mongo.MongoGroupScan, class
org.apache.drill.exec.physical.config.BroadcastExchange, class
org.apache.drill.exec.store.direct.DirectSubScan, class
org.apache.drill.exec.store.dfs.easy.EasyGroupScan, class
org.apache.drill.exec.physical.config.HashAggregate, class
org.apache.drill.exec.store.mongo.MongoSubScan, class
org.apache.drill.exec.store.hbase.HBaseGroupScan, class
org.apache.drill.exec.store.direct.DirectGroupScan, class
org.apache.drill.exec.physical.config.HashJoinPOP, class
org.apache.drill.exec.physical.config.Screen, class
org.apache.drill.exec.store.hbase.HBaseSubScan]
2015-01-24 09:49:04,094 [main] DEBUG org.apache.drill.common.JSONOptions -
Creating Deserializer.
2015-01-24 09:49:04,094 [main] DEBUG org.apache.drill.common.JSONOptions -
Creating Deserializer.
2015-01-24 09:49:04,127 [main] DEBUG o.a.d.e.p.i.OperatorCreatorRegistry -
Adding Operator Creator map: {class
org.apache.drill.exec.physical.config.WindowPOP=public
org.apache.drill.exec.physical.impl.window.StreamingWindowFrameBatchCreator(),
class org.apache.drill.exec.physical.config.MergingReceiverPOP=public
org.apache.drill.exec.physical.impl.MergingReceiverCreator(), class
org.apache.drill.exec.store.dfs.easy.EasyWriter=public
org.apache.drill.exec.store.dfs.easy.EasyWriterBatchCreator(), class
org.apache.drill.exec.physical.config.OrderedPartitionSender=public
org.apache.drill.exec.physical.impl.orderedpartitioner.OrderedPartitionSenderCreator(),
class org.apache.drill.exec.physical.config.SingleSender=public
org.apache.drill.exec.physical.impl.SingleSenderCreator(), class
org.apache.drill.exec.physical.config.Project=public
org.apache.drill.exec.physical.impl.project.ProjectBatchCreator(), class
org.apache.drill.exec.physical.config.TopN=public
org.apache.drill.exec.physical.impl.TopN.TopNSortBatchCreator(), class
org.apache.drill.exec.store.mock.MockSubScanPOP=public
org.apache.drill.exec.store.mock.MockScanBatchCreator(), class
org.apache.drill.exec.store.ischema.InfoSchemaSubScan=public
org.apache.drill.exec.store.ischema.InfoSchemaBatchCreator(), class
org.apache.drill.exec.physical.config.UnorderedReceiver=public
org.apache.drill.exec.physical.impl.unorderedreceiver.UnorderedReceiverCreator(),
class org.apache.drill.exec.physical.config.Filter=public
org.apache.drill.exec.physical.impl.filter.FilterBatchCreator(), class
org.apache.drill.exec.physical.config.Sort=public
org.apache.drill.exec.physical.impl.sort.SortBatchCreator(), class
org.apache.drill.exec.store.parquet.ParquetRowGroupScan=public
org.apache.drill.exec.store.parquet.ParquetScanBatchCreator(), class
org.apache.drill.exec.store.sys.SystemTableScan=public
org.apache.drill.exec.store.sys.SystemTableBatchCreator(), class
org.apache.drill.exec.physical.config.UnionAll=public
org.apache.drill.exec.physical.impl.union.UnionAllBatchCreator(), class
org.apache.drill.exec.physical.config.ExternalSort=public
org.apache.drill.exec.physical.impl.xsort.ExternalSortBatchCreator(), class
org.apache.drill.exec.store.dfs.easy.EasySubScan=public
org.apache.drill.exec.store.dfs.easy.EasyReaderBatchCreator(), class
org.apache.drill.exec.store.hive.HiveSubScan=public
org.apache.drill.exec.store.hive.HiveScanBatchCreator(), class
org.apache.drill.exec.physical.config.HashPartitionSender=public
org.apache.drill.exec.physical.impl.partitionsender.PartitionSenderCreator(),
class org.apache.drill.exec.physical.config.BroadcastSender=public
org.apache.drill.exec.physical.impl.broadcastsender.BroadcastSenderCreator(),
class org.apache.drill.exec.physical.config.ProducerConsumer=public
org.apache.drill.exec.physical.impl.producer.ProducerConsumerBatchCreator(),
class org.apache.drill.exec.store.direct.DirectSubScan=public
org.apache.drill.exec.store.direct.DirectBatchCreator(), class
org.apache.drill.exec.physical.config.SelectionVectorRemover=public
org.apache.drill.exec.physical.impl.svremover.SVRemoverCreator(), class
org.apache.drill.exec.physical.config.HashAggregate=public
org.apache.drill.exec.physical.impl.aggregate.HashAggBatchCreator(), class
org.apache.drill.exec.physical.config.MergeJoinPOP=public
org.apache.drill.exec.physical.impl.join.MergeJoinCreator(), class
org.apache.drill.exec.store.mongo.MongoSubScan=public
org.apache.drill.exec.store.mongo.MongoScanBatchCreator(), class
org.apache.drill.exec.physical.config.StreamingAggregate=public
org.apache.drill.exec.physical.impl.aggregate.StreamingAggBatchCreator(), class
org.apache.drill.exec.physical.config.ComplexToJson=public
org.apache.drill.exec.physical.impl.project.ComplexToJsonBatchCreator(), class
org.apache.drill.exec.physical.config.FlattenPOP=public
org.apache.drill.exec.physical.impl.flatten.FlattenBatchCreator(), class
org.apache.drill.exec.physical.config.Trace=public
org.apache.drill.exec.physical.impl.trace.TraceBatchCreator(), class
org.apache.drill.exec.store.parquet.ParquetWriter=public
org.apache.drill.exec.store.parquet.ParquetWriterBatchCreator(), class
org.apache.drill.exec.physical.config.HashJoinPOP=public
org.apache.drill.exec.physical.impl.join.HashJoinBatchCreator(), class
org.apache.drill.exec.physical.config.IteratorValidator=public
org.apache.drill.exec.physical.impl.validate.IteratorValidatorCreator(), class
org.apache.drill.exec.physical.config.Screen=public
org.apache.drill.exec.physical.impl.ScreenCreator(), class
org.apache.drill.exec.physical.config.Limit=public
org.apache.drill.exec.physical.impl.limit.LimitBatchCreator(), class
org.apache.drill.exec.store.hbase.HBaseSubScan=public
org.apache.drill.exec.store.hbase.HBaseScanBatchCreator()}
2015-01-24 09:49:06,014 [main] DEBUG o.a.d.e.store.StoragePluginRegistry -
Loading storage plugins [class
org.apache.drill.exec.store.sys.SystemTablePlugin, class
org.apache.drill.exec.store.mongo.MongoStoragePlugin, class
org.apache.drill.exec.store.ischema.InfoSchemaStoragePlugin, class
org.apache.drill.exec.store.dfs.FileSystemPlugin, class
org.apache.drill.exec.store.hive.HiveStoragePlugin, class
org.apache.drill.exec.store.hbase.HBaseStoragePlugin, class
org.apache.drill.exec.store.mock.MockStorageEngine]
2015-01-24 09:49:06,123 [main] DEBUG o.a.d.e.s.h.HBaseStoragePluginConfig -
Initializing HBase StoragePlugin configuration with zookeeper quorum
'localhost', port '2181'.
2015-01-24 09:49:06,134 [main] DEBUG o.a.d.exec.store.pojo.PojoDataType -
org.apache.drill.exec.server.options.OptionValue
2015-01-24 09:49:06,146 [main] DEBUG o.a.d.exec.store.pojo.PojoDataType -
org.apache.drill.exec.store.sys.DrillbitIterator$DrillbitInstance
2015-01-24 09:49:06,146 [main] DEBUG o.a.d.exec.store.pojo.PojoDataType -
org.apache.drill.exec.store.sys.VersionIterator$VersionInfo
2015-01-24 09:49:06,178 [main] DEBUG o.a.d.e.c.l.LocalClusterCoordinator -
Endpoint registered address: "localhost.localdomain"
user_port: 31010
control_port: 31011
data_port: 31012
.
2015-01-24 09:49:06,863 [main] DEBUG o.a.drill.exec.client.DrillClient -
Connecting to server localhost.localdomain:31010
2015-01-24 09:49:46,847 [UserServer-1] DEBUG o.a.drill.exec.rpc.user.UserServer
- Received query to run. Returning query handle.
2015-01-24 09:49:46,928 [WorkManager Event Thread] DEBUG
o.apache.drill.exec.work.WorkManager - Starting pending task
org.apache.drill.exec.work.WorkManager$RunnableWrapper@74103727
2015-01-24 09:49:46,940 [Client-1] DEBUG o.a.d.e.rpc.user.QueryResultHandler -
Received QueryId part1: 3115451854546433743
part2: 8282573379218972172
succesfully. Adding listener
org.apache.drill.jdbc.DrillResultSet$Listener@1dc9843c
2015-01-24 09:49:47,005 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.d.e.s.h.HBaseStoragePluginConfig - Initializing HBase StoragePlugin
configuration with zookeeper quorum 'localhost', port '2181'.
2015-01-24 09:49:47,013 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.drill.exec.store.SchemaFactory - Took 12 ms to register schemas.
2015-01-24 09:49:47,208 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.d.e.s.dfs.WorkspaceSchemaFactory - The filesystem for this workspace does
not support this operation.
java.lang.UnsupportedOperationException: ClassPathFileSystem doesn't currently
support listing files.
at
org.apache.drill.exec.store.ClassPathFileSystem.listStatus(ClassPathFileSystem.java:105)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at org.apache.hadoop.fs.Globber.listStatus(Globber.java:69)
~[hadoop-common-2.4.1.jar:na]
at org.apache.hadoop.fs.Globber.glob(Globber.java:217)
~[hadoop-common-2.4.1.jar:na]
at org.apache.hadoop.fs.FileSystem.globStatus(FileSystem.java:1623)
~[hadoop-common-2.4.1.jar:na]
at
org.apache.drill.exec.dotdrill.DotDrillUtil.getDotDrills(DotDrillUtil.java:61)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
org.apache.drill.exec.store.dfs.WorkspaceSchemaFactory$WorkspaceSchema.getTable(WorkspaceSchemaFactory.java:260)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
org.apache.drill.exec.store.dfs.FileSystemSchemaFactory$FileSystemSchema.getTable(FileSystemSchemaFactory.java:97)
[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
net.hydromatic.optiq.jdbc.SimpleOptiqSchema.getTable(SimpleOptiqSchema.java:75)
[optiq-core-0.9-drill-r12.jar:na]
at
net.hydromatic.optiq.prepare.OptiqCatalogReader.getTableFrom(OptiqCatalogReader.java:87)
[optiq-core-0.9-drill-r12.jar:na]
at
net.hydromatic.optiq.prepare.OptiqCatalogReader.getTable(OptiqCatalogReader.java:70)
[optiq-core-0.9-drill-r12.jar:na]
at
net.hydromatic.optiq.prepare.OptiqCatalogReader.getTable(OptiqCatalogReader.java:42)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.EmptyScope.getTableNamespace(EmptyScope.java:67)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:75)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:85)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:779)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:768)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2599)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2807)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:85)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:779)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:768)
[optiq-core-0.9-drill-r12.jar:na]
at org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:208)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:742)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:458)
[optiq-core-0.9-drill-r12.jar:na]
at
net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:176)
[optiq-core-0.9-drill-r12.jar:na]
at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:145)
[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:125)
[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:145)
[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:507)
[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:185)
[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:254)
[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[na:1.7.0_45]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[na:1.7.0_45]
at java.lang.Thread.run(Unknown Source) [na:1.7.0_45]
2015-01-24 09:49:47,252 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.d.e.p.s.h.DefaultSqlHandler - Optiq Logical :
ProjectRel(*=[$0]): rowcount = 100.0, cumulative cost = {200.0 rows, 201.0 cpu,
0.0 io, 0.0 network, 0.0 memory}, id = 5
EnumerableTableAccessRel(table=[[cp, employee.json]]): rowcount = 100.0,
cumulative cost = {100.0 rows, 101.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id
= 2
2015-01-24 09:49:47,279 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.d.e.s.schedule.BlockMapBuilder - Took 0 ms to build endpoint map
2015-01-24 09:49:47,301 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.d.e.s.schedule.BlockMapBuilder - Failure finding Drillbit running on host
localhost. Skipping affinity to that host.
2015-01-24 09:49:47,301 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.d.e.s.schedule.BlockMapBuilder - FileWork group (/employee.json,0) max
bytes 0
2015-01-24 09:49:47,302 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.d.e.s.schedule.BlockMapBuilder - Took 21 ms to set endpoint bytes
2015-01-24 09:49:47,304 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.d.e.s.schedule.AffinityCreator - Took 0 ms to get operator affinity
2015-01-24 09:49:47,310 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.d.e.p.s.h.DefaultSqlHandler - Drill Logical :
DrillScreenRel: rowcount = 463.0, cumulative cost = {509.3 rows, 4630046.3 cpu,
0.0 io, 0.0 network, 0.0 memory}, id = 22
DrillScanRel(table=[[cp, employee.json]], groupscan=[EasyGroupScan
[selectionRoot=/employee.json, numFiles=1, columns=[`*`],
files=[/employee.json]]]): rowcount = 463.0, cumulative cost = {463.0 rows,
4630000.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 21
2015-01-24 09:49:47,324 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.d.e.p.s.h.DefaultSqlHandler - Drill Physical :
00-00 Screen: rowcount = 463.0, cumulative cost = {509.3 rows, 509.3 cpu,
0.0 io, 0.0 network, 0.0 memory}, id = 46
00-01 Scan(groupscan=[EasyGroupScan [selectionRoot=/employee.json,
numFiles=1, columns=[`*`], files=[/employee.json]]]): rowcount = 463.0,
cumulative cost = {463.0 rows, 463.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id
= 45
2015-01-24 09:49:47,365 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c: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" : "fs-scan",
"@id" : 1,
"files" : [ "/employee.json" ],
"storage" : {
"type" : "file",
"enabled" : true,
"connection" : "classpath:///",
"workspaces" : null,
"formats" : {
"csv" : {
"type" : "text",
"extensions" : [ "csv" ],
"delimiter" : ","
},
"tsv" : {
"type" : "text",
"extensions" : [ "tsv" ],
"delimiter" : "\t"
},
"json" : {
"type" : "json"
},
"parquet" : {
"type" : "parquet"
}
}
},
"format" : {
"type" : "json"
},
"columns" : [ "`*`" ],
"selectionRoot" : "/employee.json",
"cost" : 463.0
}, {
"pop" : "screen",
"@id" : 0,
"child" : 1,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 463.0
} ]
}
2015-01-24 09:49:47,370 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.d.e.s.schedule.AssignmentCreator - Assigning 1 units to 1 endpoints
2015-01-24 09:49:47,370 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.d.e.s.schedule.AssignmentCreator - Assigned unit: File: /employee.json
start: 0 length: 474630 to minorFragmentId: 0
2015-01-24 09:49:47,370 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.d.e.s.schedule.AssignmentCreator - Took 0 ms to apply assignments
2015-01-24 09:49:47,409 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.d.e.p.f.SimpleParallelizer - Root fragment:
handle {
query_id {
part1: 3115451854546433743
part2: 8282573379218972172
}
major_fragment_id: 0
minor_fragment_id: 0
}
fragment_json: "{
"pop" : "screen",
"@id" : 0,
"child" : {
"pop" : "fs-sub-scan",
"@id" : 1,
"files" : [ {
"start" : 0,
"length" : 474630,
"path" : "/employee.json"
} ],
"storage" : {
"type" : "file",
"enabled" : true,
"connection" : "classpath:///",
"workspaces" : null,
"formats" : {
"csv" : {
"type" : "text",
"extensions" : [ "csv" ],
"delimiter" : ","
},
"tsv" : {
"type" : "text",
"extensions" : [ "tsv" ],
"delimiter" : "\t"
},
"json" : {
"type" : "json"
},
"parquet" : {
"type" : "parquet"
}
}
},
"format" : {
"type" : "named",
"name" : "json"
},
"columns" : [ "`*`" ],
"selectionRoot" : "/employee.json",
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 0.0
},
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 0.0
}"
leaf_fragment: true
assignment {
address: "localhost.localdomain"
user_port: 31010
control_port: 31011
data_port: 31012
}
foreman {
address: "localhost.localdomain"
user_port: 31010
control_port: 31011
data_port: 31012
}
mem_initial: 1000000
mem_max: 10000000000
query_start_time: 1422110987370
credentials {
user_name: ""
}
time_zone: 166
options_json: "[ ]"
2015-01-24 09:49:47,410 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.d.exec.rpc.control.WorkEventBus - Adding fragment status listener for
queryId part1: 3115451854546433743
part2: 8282573379218972172
.
2015-01-24 09:49:47,410 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.drill.exec.work.foreman.Foreman - Submitting fragments to run.
2015-01-24 09:49:47,419 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.drill.exec.ops.FragmentContext - Getting initial memory allocation of
1000000
2015-01-24 09:49:47,420 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.drill.exec.ops.FragmentContext - Fragment max allocation: 10000000000
2015-01-24 09:49:47,421 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.d.exec.memory.TopLevelAllocator - New child allocator with initial
reservation 1000000
2015-01-24 09:49:47,435 [2b3c4ef4-9112-76cf-72f1-9c9afe741e0c:foreman] DEBUG
o.a.drill.exec.work.foreman.Foreman - State change requested. PENDING -->
FAILED
2015-01-24 09:49:47,473 [WorkManager-1] ERROR
o.apache.drill.exec.work.WorkManager - Failure while running wrapper [Foreman:
2b3c4ef4-9112-76cf-72f1-9c9afe741e0c]
java.lang.NullPointerException: null
at
org.apache.drill.exec.work.foreman.Foreman.cancelExecutingFragments(Foreman.java:483)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
org.apache.drill.exec.work.foreman.Foreman.moveToState(Foreman.java:436)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:194)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:254)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[na:1.7.0_45]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[na:1.7.0_45]
at java.lang.Thread.run(Unknown Source) [na:1.7.0_45]
2015-01-24 09:52:06,253 [main] DEBUG o.a.drill.common.config.DrillConfig -
Loading configs at the following URLs
[jar:file:/home/user/Downloads/apache-drill-0.7.0/jars/drill-storage-hbase-0.7.0.jar!/drill-module.conf,
jar:file:/home/user/Downloads/apache-drill-0.7.0/jars/drill-storage-hive-core-0.7.0.jar!/drill-module.conf,
jar:file:/home/user/Downloads/apache-drill-0.7.0/jars/drill-hive-exec-shaded-0.7.0.jar!/drill-module.conf,
jar:file:/home/user/Downloads/apache-drill-0.7.0/jars/drill-java-exec-0.7.0-rebuffed.jar!/drill-module.conf,
jar:file:/home/user/Downloads/apache-drill-0.7.0/jars/drill-common-0.7.0-rebuffed.jar!/drill-module.conf,
jar:file:/home/user/Downloads/apache-drill-0.7.0/jars/drill-mongo-storage-0.7.0.jar!/drill-module.conf]
2015-01-24 09:52:07,942 [main] DEBUG o.a.d.c.l.data.LogicalOperatorBase -
Adding Logical Operator sub types: [class
org.apache.drill.common.logical.data.Flatten, class
org.apache.drill.common.logical.data.Transform, class
org.apache.drill.common.logical.data.Store, class
org.apache.drill.common.logical.data.Scan, class
org.apache.drill.common.logical.data.Writer, class
org.apache.drill.common.logical.data.Limit, class
org.apache.drill.common.logical.data.Project, class
org.apache.drill.common.logical.data.Sequence, class
org.apache.drill.common.logical.data.RunningAggregate, class
org.apache.drill.common.logical.data.Union, class
org.apache.drill.common.logical.data.Filter, class
org.apache.drill.common.logical.data.GroupingAggregate, class
org.apache.drill.common.logical.data.Order, class
org.apache.drill.common.logical.data.Window, class
org.apache.drill.common.logical.data.Join, class
org.apache.drill.common.logical.data.Constant]
2015-01-24 09:52:07,946 [main] DEBUG o.a.d.c.l.StoragePluginConfigBase - Adding
Storage Engine Configs including [class
org.apache.drill.exec.store.hbase.HBaseStoragePluginConfig, class
org.apache.drill.exec.store.ischema.InfoSchemaConfig, class
org.apache.drill.exec.store.dfs.FileSystemConfig, class
org.apache.drill.exec.store.sys.SystemTablePluginConfig, class
org.apache.drill.exec.store.NamedStoragePluginConfig, class
org.apache.drill.exec.store.mongo.MongoStoragePluginConfig, class
org.apache.drill.exec.store.mock.MockStorageEngineConfig, class
org.apache.drill.exec.store.dfs.FileSystemFormatConfig, class
org.apache.drill.exec.store.hive.HiveStoragePluginConfig]
2015-01-24 09:52:07,947 [main] DEBUG o.a.d.c.l.FormatPluginConfigBase - Adding
Format Plugin Configs including [class
org.apache.drill.exec.store.easy.json.JSONFormatPlugin$JSONFormatConfig, class
org.apache.drill.exec.store.easy.text.TextFormatPlugin$TextFormatConfig, class
org.apache.drill.exec.store.dfs.NamedFormatPluginConfig, class
org.apache.drill.exec.store.parquet.ParquetFormatConfig]
2015-01-24 09:52:08,035 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.zookeeper.version=3.4.5-1392090, built on 09/30/2012
17:52 GMT
2015-01-24 09:52:08,036 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.host.name=localhost.localdomain
2015-01-24 09:52:08,036 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.java.version=1.7.0_45
2015-01-24 09:52:08,036 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.java.vendor=Oracle Corporation
2015-01-24 09:52:08,036 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.java.home=/opt/jre1.7.0_45-x64
2015-01-24 09:52:08,036 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit
environment:.java.class.path=/home/user/Downloads/apache-drill-0.7.0/conf:/home/user/Downloads/apache-drill-0.7.0/jars/tpch-sample-data-0.7.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/drill-storage-hive-core-0.7.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/drill-java-exec-0.7.0-rebuffed.jar:/home/user/Downloads/apache-drill-0.7.0/jars/drill-jdbc-0.7.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/drill-protocol-0.7.0-rebuffed.jar:/home/user/Downloads/apache-drill-0.7.0/jars/drill-mongo-storage-0.7.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/drill-common-0.7.0-rebuffed.jar:/home/user/Downloads/apache-drill-0.7.0/jars/drill-hive-exec-shaded-0.7.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/drill-storage-hbase-0.7.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/ext/zookeeper-3.4.5.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jasper-runtime-5.5.23.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.lilith.data.converter-0.9.44.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/tpch-sample-data-0.7.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/hadoop-common-2.4.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/datanucleus-core-3.2.10.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/datanucleus-api-jdo-3.2.6.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/protostuff-json-1.0.8.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-math3-3.1.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/mondrian-data-foodmart-json-0.3.2.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/netty-transport-4.0.24.Final.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/optiq-avatica-0.9-drill-r12.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/validation-api-1.0.0.GA.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.sulky.io-0.9.17.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-pool-1.5.4.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jetty-util-9.1.5.v20140505.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jetty-http-9.1.5.v20140505.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/javassist-3.16.1-GA.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/slf4j-api-1.7.5.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-el-1.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/bonecp-0.8.0.RELEASE.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-compiler-jdk-2.7.4.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/netty-codec-4.0.24.Final.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/curator-client-2.5.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jetty-xml-9.1.1.v20140108.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/javax.inject-1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/xercesImpl-2.11.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/hibernate-validator-4.3.1.Final.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/hppc-0.4.2.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/mockito-all-1.9.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-compiler-2.7.3.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/protobuf-java-2.5.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/stringtemplate-3.2.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/linq4j-0.4.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/hamcrest-core-1.3.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.sulky.formatting-0.9.17.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/parquet-jackson-1.5.1-drill-r4.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/metrics-core-3.0.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/paranamer-2.5.6.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/libthrift-0.9.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/hadoop-yarn-server-common-2.4.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/netty-buffer-4.0.24.Final.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-pool2-2.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jetty-server-9.1.5.v20140505.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/hadoop-hdfs-2.4.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-beanutils-core-1.8.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/json-simple-1.1.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/parquet-common-1.5.1-drill-r4.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jline-2.10.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/janino-2.7.4.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/hadoop-auth-2.4.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-lang-2.6.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/xmlenc-0.52.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jackson-module-jaxb-annotations-2.4.3.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/optiq-core-0.9-drill-r12.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jetty-io-9.1.5.v20140505.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/parquet-encoding-1.5.1-drill-r4.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/snappy-java-1.0.5-M3.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/hadoop-mapreduce-client-common-2.4.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.lilith.logback.classic-0.9.44.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/metrics-core-2.1.2.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jackson-jaxrs-json-provider-2.4.3.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/eigenbase-properties-1.1.4.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/xalan-2.7.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/hadoop-annotations-2.4.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-collections-3.2.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/log4j-1.2.16.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/httpcore-4.2.4.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/curator-framework-2.5.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.lilith.logback.converter-classic-0.9.44.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/hadoop-mapreduce-client-app-2.4.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/parquet-generator-1.5.1-drill-r4.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jetty-webapp-9.1.1.v20140108.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/parquet-hadoop-1.5.1-drill-r4.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/netty-transport-native-epoll-4.0.24.Final-linux-x86_64.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/metrics-healthchecks-3.0.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jsp-api-2.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jcl-over-slf4j-1.7.5.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jdo-api-3.0.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jackson-jaxrs-base-2.4.3.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.sulky.codec-0.9.17.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/dom4j-1.6.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jdk.tools-1.7.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/metrics-servlets-3.0.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/hadoop-mapreduce-client-core-2.4.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/httpclient-4.2.5.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-lang3-3.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.lilith.logback.appender.multiplex-core-0.9.44.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jcommander-1.30.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/joda-time-2.3.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jackson-annotations-2.4.3.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-httpclient-3.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.lilith.data.eventsource-0.9.44.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/hive-metastore-0.13.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-dbcp-1.4.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/libfb303-0.9.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/guava-14.0.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/protostuff-core-1.0.8.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jackson-core-asl-1.9.13.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/hadoop-mapreduce-client-shuffle-2.4.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jul-to-slf4j-1.7.5.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.lilith.sender-0.9.44.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jasper-compiler-5.5.23.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jackson-databind-2.4.3.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/parquet-column-1.5.1-drill-r5.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/mongo-java-driver-2.12.2.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/hive-hbase-handler-0.13.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/curator-x-discovery-2.5.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/metrics-json-3.0.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-compress-1.4.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jackson-jaxrs-1.8.8.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jetty-servlet-9.1.5.v20140505.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/log4j-over-slf4j-1.7.5.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jackson-core-2.4.3.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/freemarker-2.3.19.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/protostuff-api-1.0.8.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/hbase-0.94.22-drill-r1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/msgpack-0.6.6.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-net-3.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.lilith.data.logging.protobuf-0.9.44.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-math-2.2.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/stax-api-1.0-2.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jetty-continuation-9.1.1.v20140108.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jetty-security-9.1.5.v20140505.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jsr305-1.3.9.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jsch-0.1.42.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/netty-common-4.0.24.Final.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.lilith.data.logging-0.9.44.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/antlr-2.7.7.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-io-2.4.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/javassist-3.12.1.GA.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/metrics-jvm-3.0.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/parquet-format-2.1.1-drill-r1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/de.huxhorn.lilith.logback.appender.multiplex-classic-0.9.44.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-digester-1.8.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/hadoop-yarn-client-2.4.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-codec-1.4.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/derby-10.10.1.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/config-1.0.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/netty-handler-4.0.24.Final.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/avro-1.7.4.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/hadoop-client-2.4.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/hadoop-yarn-common-2.4.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/sqlline-1.1.6.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/asm-debug-all-5.0.3.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-beanutils-1.7.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jackson-xc-1.8.8.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/xml-apis-1.4.01.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-configuration-1.6.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jackson-mapper-asl-1.9.11.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/jta-1.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/curator-recipes-2.5.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/hadoop-mapreduce-client-jobclient-2.4.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/xz-1.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/serializer-2.7.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/datanucleus-rdbms-3.2.9.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/commons-cli-1.2.jar:/home/user/Downloads/apache-drill-0.7.0/jars/3rdparty/antlr-runtime-3.4.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/jetty-6.1.26.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/jersey-server-2.8.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/jersey-container-servlet-2.8.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/jetty-util-6.1.26.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/jersey-container-jetty-http-2.8.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/javax.ws.rs-api-2.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/jersey-client-2.8.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/activation-1.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/hk2-utils-2.2.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/logback-classic-1.0.13.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/hk2-api-2.2.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/jaxb-api-2.2.2.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/jersey-mvc-2.8.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/mimepull-1.9.3.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/jersey-guava-2.8.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/javax.servlet-api-3.1.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/jersey-container-servlet-core-2.8.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/high-scale-lib-1.1.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/logback-core-1.0.13.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/codemodel-2.6.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/javax.annotation-api-1.2.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/jersey-media-multipart-2.8.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/reflections-0.9.8.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/jersey-mvc-freemarker-2.8.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/javax.inject-2.2.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/osgi-resource-locator-1.0.1.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/jersey-container-jetty-servlet-2.8.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/aopalliance-repackaged-2.2.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/hk2-locator-2.2.0.jar:/home/user/Downloads/apache-drill-0.7.0/jars/classb/jersey-common-2.8.jar
2015-01-24 09:52:08,036 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit
environment:.java.library.path=/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
2015-01-24 09:52:08,036 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.java.io.tmpdir=/tmp
2015-01-24 09:52:08,036 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.java.compiler=<NA>
2015-01-24 09:52:08,036 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.os.name=Linux
2015-01-24 09:52:08,036 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.os.arch=amd64
2015-01-24 09:52:08,036 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.os.version=3.11.10
2015-01-24 09:52:08,036 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.user.name=user
2015-01-24 09:52:08,036 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.user.home=/home/user
2015-01-24 09:52:08,036 [main] INFO o.apache.drill.exec.server.Drillbit -
Drillbit environment:.user.dir=/home/user/Downloads/apache-drill-0.7.0
2015-01-24 09:52:08,060 [main] DEBUG o.a.drill.common.config.DrillConfig -
Loading configs at the following URLs
[jar:file:/home/user/Downloads/apache-drill-0.7.0/jars/drill-storage-hbase-0.7.0.jar!/drill-module.conf,
jar:file:/home/user/Downloads/apache-drill-0.7.0/jars/drill-storage-hive-core-0.7.0.jar!/drill-module.conf,
jar:file:/home/user/Downloads/apache-drill-0.7.0/jars/drill-hive-exec-shaded-0.7.0.jar!/drill-module.conf,
jar:file:/home/user/Downloads/apache-drill-0.7.0/jars/drill-java-exec-0.7.0-rebuffed.jar!/drill-module.conf,
jar:file:/home/user/Downloads/apache-drill-0.7.0/jars/drill-common-0.7.0-rebuffed.jar!/drill-module.conf,
jar:file:/home/user/Downloads/apache-drill-0.7.0/jars/drill-mongo-storage-0.7.0.jar!/drill-module.conf]
2015-01-24 09:52:08,072 [main] DEBUG o.a.d.c.l.data.LogicalOperatorBase -
Adding Logical Operator sub types: [class
org.apache.drill.common.logical.data.Flatten, class
org.apache.drill.common.logical.data.Transform, class
org.apache.drill.common.logical.data.Store, class
org.apache.drill.common.logical.data.Scan, class
org.apache.drill.common.logical.data.Writer, class
org.apache.drill.common.logical.data.Limit, class
org.apache.drill.common.logical.data.Project, class
org.apache.drill.common.logical.data.Sequence, class
org.apache.drill.common.logical.data.RunningAggregate, class
org.apache.drill.common.logical.data.Union, class
org.apache.drill.common.logical.data.Filter, class
org.apache.drill.common.logical.data.GroupingAggregate, class
org.apache.drill.common.logical.data.Order, class
org.apache.drill.common.logical.data.Window, class
org.apache.drill.common.logical.data.Join, class
org.apache.drill.common.logical.data.Constant]
2015-01-24 09:52:08,073 [main] DEBUG o.a.d.c.l.StoragePluginConfigBase - Adding
Storage Engine Configs including [class
org.apache.drill.exec.store.hbase.HBaseStoragePluginConfig, class
org.apache.drill.exec.store.ischema.InfoSchemaConfig, class
org.apache.drill.exec.store.dfs.FileSystemConfig, class
org.apache.drill.exec.store.sys.SystemTablePluginConfig, class
org.apache.drill.exec.store.NamedStoragePluginConfig, class
org.apache.drill.exec.store.mongo.MongoStoragePluginConfig, class
org.apache.drill.exec.store.mock.MockStorageEngineConfig, class
org.apache.drill.exec.store.dfs.FileSystemFormatConfig, class
org.apache.drill.exec.store.hive.HiveStoragePluginConfig]
2015-01-24 09:52:08,073 [main] DEBUG o.a.d.c.l.FormatPluginConfigBase - Adding
Format Plugin Configs including [class
org.apache.drill.exec.store.easy.json.JSONFormatPlugin$JSONFormatConfig, class
org.apache.drill.exec.store.easy.text.TextFormatPlugin$TextFormatConfig, class
org.apache.drill.exec.store.dfs.NamedFormatPluginConfig, class
org.apache.drill.exec.store.parquet.ParquetFormatConfig]
2015-01-24 09:52:08,447 [main] DEBUG o.a.d.e.c.l.LocalClusterCoordinator -
Local Cluster Coordinator started.
2015-01-24 09:52:08,475 [main] DEBUG o.apache.drill.exec.rpc.BasicServer -
Server started on port 31010 of type UserServer
2015-01-24 09:52:08,491 [main] DEBUG o.apache.drill.exec.rpc.BasicServer -
Server started on port 31011 of type ControlServer
2015-01-24 09:52:08,499 [main] DEBUG o.apache.drill.exec.rpc.BasicServer -
Server started on port 31012 of type DataServer
2015-01-24 09:52:08,557 [main] DEBUG o.a.d.e.p.base.PhysicalOperatorUtil -
Adding Physical Operator sub types: [class
org.apache.drill.exec.physical.config.StreamingAggregate, class
org.apache.drill.exec.store.mongo.MongoGroupScan, class
org.apache.drill.exec.store.dfs.easy.EasyWriter, class
org.apache.drill.exec.physical.config.HashJoinPOP, class
org.apache.drill.exec.store.ischema.InfoSchemaGroupScan, class
org.apache.drill.exec.store.hive.HiveSubScan, class
org.apache.drill.exec.physical.config.SingleMergeExchange, class
org.apache.drill.exec.physical.config.MergeJoinPOP, class
org.apache.drill.exec.physical.config.OrderedPartitionExchange, class
org.apache.drill.exec.store.hbase.HBaseGroupScan, class
org.apache.drill.exec.store.parquet.ParquetGroupScan, class
org.apache.drill.exec.physical.config.ExternalSort, class
org.apache.drill.exec.physical.config.TopN, class
org.apache.drill.exec.physical.config.Project, class
org.apache.drill.exec.physical.config.Screen, class
org.apache.drill.exec.physical.config.MergingReceiverPOP, class
org.apache.drill.exec.store.dfs.easy.EasySubScan, class
org.apache.drill.exec.physical.config.BroadcastSender, class
org.apache.drill.exec.physical.config.SingleSender, class
org.apache.drill.exec.physical.config.Limit, class
org.apache.drill.exec.store.parquet.ParquetRowGroupScan, class
org.apache.drill.exec.store.direct.DirectSubScan, class
org.apache.drill.exec.store.direct.DirectGroupScan, class
org.apache.drill.exec.store.hbase.HBaseSubScan, class
org.apache.drill.exec.physical.config.ProducerConsumer, class
org.apache.drill.exec.store.mock.MockGroupScanPOP, class
org.apache.drill.exec.physical.config.UnionExchange, class
org.apache.drill.exec.physical.config.ComplexToJson, class
org.apache.drill.exec.physical.config.IteratorValidator, class
org.apache.drill.exec.store.mock.MockStorePOP, class
org.apache.drill.exec.physical.config.Filter, class
org.apache.drill.exec.physical.config.UnionAll, class
org.apache.drill.exec.physical.config.WindowPOP, class
org.apache.drill.exec.physical.config.FlattenPOP, class
org.apache.drill.exec.physical.config.HashToMergeExchange, class
org.apache.drill.exec.store.mongo.MongoSubScan, class
org.apache.drill.exec.physical.config.Sort, class
org.apache.drill.exec.physical.config.HashAggregate, class
org.apache.drill.exec.physical.config.BroadcastExchange, class
org.apache.drill.exec.store.sys.SystemTableScan, class
org.apache.drill.exec.store.mock.MockSubScanPOP, class
org.apache.drill.exec.physical.config.UnorderedReceiver, class
org.apache.drill.exec.physical.config.OrderedPartitionSender, class
org.apache.drill.exec.store.ischema.InfoSchemaSubScan, class
org.apache.drill.exec.physical.config.HashPartitionSender, class
org.apache.drill.exec.physical.config.RangeSender, class
org.apache.drill.exec.physical.config.HashToRandomExchange, class
org.apache.drill.exec.store.hive.HiveScan, class
org.apache.drill.exec.physical.config.Trace, class
org.apache.drill.exec.physical.config.SelectionVectorRemover, class
org.apache.drill.exec.store.dfs.easy.EasyGroupScan, class
org.apache.drill.exec.store.parquet.ParquetWriter]
2015-01-24 09:52:08,598 [main] DEBUG org.apache.drill.common.JSONOptions -
Creating Deserializer.
2015-01-24 09:52:08,598 [main] DEBUG org.apache.drill.common.JSONOptions -
Creating Deserializer.
2015-01-24 09:52:08,630 [main] DEBUG o.a.d.e.p.i.OperatorCreatorRegistry -
Adding Operator Creator map: {class
org.apache.drill.exec.store.hbase.HBaseSubScan=public
org.apache.drill.exec.store.hbase.HBaseScanBatchCreator(), class
org.apache.drill.exec.physical.config.StreamingAggregate=public
org.apache.drill.exec.physical.impl.aggregate.StreamingAggBatchCreator(), class
org.apache.drill.exec.physical.config.ProducerConsumer=public
org.apache.drill.exec.physical.impl.producer.ProducerConsumerBatchCreator(),
class org.apache.drill.exec.store.dfs.easy.EasyWriter=public
org.apache.drill.exec.store.dfs.easy.EasyWriterBatchCreator(), class
org.apache.drill.exec.physical.config.ComplexToJson=public
org.apache.drill.exec.physical.impl.project.ComplexToJsonBatchCreator(), class
org.apache.drill.exec.physical.config.HashJoinPOP=public
org.apache.drill.exec.physical.impl.join.HashJoinBatchCreator(), class
org.apache.drill.exec.physical.config.IteratorValidator=public
org.apache.drill.exec.physical.impl.validate.IteratorValidatorCreator(), class
org.apache.drill.exec.store.hive.HiveSubScan=public
org.apache.drill.exec.store.hive.HiveScanBatchCreator(), class
org.apache.drill.exec.physical.config.Filter=public
org.apache.drill.exec.physical.impl.filter.FilterBatchCreator(), class
org.apache.drill.exec.physical.config.MergeJoinPOP=public
org.apache.drill.exec.physical.impl.join.MergeJoinCreator(), class
org.apache.drill.exec.physical.config.UnionAll=public
org.apache.drill.exec.physical.impl.union.UnionAllBatchCreator(), class
org.apache.drill.exec.physical.config.WindowPOP=public
org.apache.drill.exec.physical.impl.window.StreamingWindowFrameBatchCreator(),
class org.apache.drill.exec.physical.config.FlattenPOP=public
org.apache.drill.exec.physical.impl.flatten.FlattenBatchCreator(), class
org.apache.drill.exec.store.mongo.MongoSubScan=public
org.apache.drill.exec.store.mongo.MongoScanBatchCreator(), class
org.apache.drill.exec.physical.config.ExternalSort=public
org.apache.drill.exec.physical.impl.xsort.ExternalSortBatchCreator(), class
org.apache.drill.exec.physical.config.TopN=public
org.apache.drill.exec.physical.impl.TopN.TopNSortBatchCreator(), class
org.apache.drill.exec.physical.config.Sort=public
org.apache.drill.exec.physical.impl.sort.SortBatchCreator(), class
org.apache.drill.exec.store.sys.SystemTableScan=public
org.apache.drill.exec.store.sys.SystemTableBatchCreator(), class
org.apache.drill.exec.physical.config.HashAggregate=public
org.apache.drill.exec.physical.impl.aggregate.HashAggBatchCreator(), class
org.apache.drill.exec.store.mock.MockSubScanPOP=public
org.apache.drill.exec.store.mock.MockScanBatchCreator(), class
org.apache.drill.exec.physical.config.Project=public
org.apache.drill.exec.physical.impl.project.ProjectBatchCreator(), class
org.apache.drill.exec.physical.config.Screen=public
org.apache.drill.exec.physical.impl.ScreenCreator(), class
org.apache.drill.exec.physical.config.UnorderedReceiver=public
org.apache.drill.exec.physical.impl.unorderedreceiver.UnorderedReceiverCreator(),
class org.apache.drill.exec.physical.config.OrderedPartitionSender=public
org.apache.drill.exec.physical.impl.orderedpartitioner.OrderedPartitionSenderCreator(),
class org.apache.drill.exec.store.ischema.InfoSchemaSubScan=public
org.apache.drill.exec.store.ischema.InfoSchemaBatchCreator(), class
org.apache.drill.exec.physical.config.HashPartitionSender=public
org.apache.drill.exec.physical.impl.partitionsender.PartitionSenderCreator(),
class org.apache.drill.exec.physical.config.MergingReceiverPOP=public
org.apache.drill.exec.physical.impl.MergingReceiverCreator(), class
org.apache.drill.exec.store.dfs.easy.EasySubScan=public
org.apache.drill.exec.store.dfs.easy.EasyReaderBatchCreator(), class
org.apache.drill.exec.physical.config.BroadcastSender=public
org.apache.drill.exec.physical.impl.broadcastsender.BroadcastSenderCreator(),
class org.apache.drill.exec.physical.config.SingleSender=public
org.apache.drill.exec.physical.impl.SingleSenderCreator(), class
org.apache.drill.exec.physical.config.Trace=public
org.apache.drill.exec.physical.impl.trace.TraceBatchCreator(), class
org.apache.drill.exec.store.parquet.ParquetRowGroupScan=public
org.apache.drill.exec.store.parquet.ParquetScanBatchCreator(), class
org.apache.drill.exec.physical.config.Limit=public
org.apache.drill.exec.physical.impl.limit.LimitBatchCreator(), class
org.apache.drill.exec.store.direct.DirectSubScan=public
org.apache.drill.exec.store.direct.DirectBatchCreator(), class
org.apache.drill.exec.physical.config.SelectionVectorRemover=public
org.apache.drill.exec.physical.impl.svremover.SVRemoverCreator(), class
org.apache.drill.exec.store.parquet.ParquetWriter=public
org.apache.drill.exec.store.parquet.ParquetWriterBatchCreator()}
2015-01-24 09:52:10,433 [main] DEBUG o.a.d.e.store.StoragePluginRegistry -
Loading storage plugins [class
org.apache.drill.exec.store.hive.HiveStoragePlugin, class
org.apache.drill.exec.store.ischema.InfoSchemaStoragePlugin, class
org.apache.drill.exec.store.mongo.MongoStoragePlugin, class
org.apache.drill.exec.store.dfs.FileSystemPlugin, class
org.apache.drill.exec.store.sys.SystemTablePlugin, class
org.apache.drill.exec.store.hbase.HBaseStoragePlugin, class
org.apache.drill.exec.store.mock.MockStorageEngine]
2015-01-24 09:52:10,546 [main] DEBUG o.a.d.e.s.h.HBaseStoragePluginConfig -
Initializing HBase StoragePlugin configuration with zookeeper quorum
'localhost', port '2181'.
2015-01-24 09:52:10,555 [main] DEBUG o.a.d.exec.store.pojo.PojoDataType -
org.apache.drill.exec.server.options.OptionValue
2015-01-24 09:52:10,564 [main] DEBUG o.a.d.exec.store.pojo.PojoDataType -
org.apache.drill.exec.store.sys.DrillbitIterator$DrillbitInstance
2015-01-24 09:52:10,564 [main] DEBUG o.a.d.exec.store.pojo.PojoDataType -
org.apache.drill.exec.store.sys.VersionIterator$VersionInfo
2015-01-24 09:52:10,595 [main] DEBUG o.a.d.e.c.l.LocalClusterCoordinator -
Endpoint registered address: "localhost.localdomain"
user_port: 31010
control_port: 31011
data_port: 31012
.
2015-01-24 09:52:11,310 [main] DEBUG o.a.drill.exec.client.DrillClient -
Connecting to server localhost.localdomain:31010
2015-01-24 09:52:29,268 [UserServer-1] DEBUG o.a.drill.exec.rpc.user.UserServer
- Received query to run. Returning query handle.
2015-01-24 09:52:29,343 [WorkManager Event Thread] DEBUG
o.apache.drill.exec.work.WorkManager - Starting pending task
org.apache.drill.exec.work.WorkManager$RunnableWrapper@25b0e082
2015-01-24 09:52:29,354 [Client-1] DEBUG o.a.d.e.rpc.user.QueryResultHandler -
Received QueryId part1: 3115451154277094032
part2: -3949962637415327264
succesfully. Adding listener
org.apache.drill.jdbc.DrillResultSet$Listener@17a0cd49
2015-01-24 09:52:29,417 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.d.e.s.h.HBaseStoragePluginConfig - Initializing HBase StoragePlugin
configuration with zookeeper quorum 'localhost', port '2181'.
2015-01-24 09:52:29,424 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.drill.exec.store.SchemaFactory - Took 11 ms to register schemas.
2015-01-24 09:52:29,600 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.d.e.s.dfs.WorkspaceSchemaFactory - The filesystem for this workspace does
not support this operation.
java.lang.UnsupportedOperationException: ClassPathFileSystem doesn't currently
support listing files.
at
org.apache.drill.exec.store.ClassPathFileSystem.listStatus(ClassPathFileSystem.java:105)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at org.apache.hadoop.fs.Globber.listStatus(Globber.java:69)
~[hadoop-common-2.4.1.jar:na]
at org.apache.hadoop.fs.Globber.glob(Globber.java:217)
~[hadoop-common-2.4.1.jar:na]
at org.apache.hadoop.fs.FileSystem.globStatus(FileSystem.java:1623)
~[hadoop-common-2.4.1.jar:na]
at
org.apache.drill.exec.dotdrill.DotDrillUtil.getDotDrills(DotDrillUtil.java:61)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
org.apache.drill.exec.store.dfs.WorkspaceSchemaFactory$WorkspaceSchema.getTable(WorkspaceSchemaFactory.java:260)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
org.apache.drill.exec.store.dfs.FileSystemSchemaFactory$FileSystemSchema.getTable(FileSystemSchemaFactory.java:97)
[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
net.hydromatic.optiq.jdbc.SimpleOptiqSchema.getTable(SimpleOptiqSchema.java:75)
[optiq-core-0.9-drill-r12.jar:na]
at
net.hydromatic.optiq.prepare.OptiqCatalogReader.getTableFrom(OptiqCatalogReader.java:87)
[optiq-core-0.9-drill-r12.jar:na]
at
net.hydromatic.optiq.prepare.OptiqCatalogReader.getTable(OptiqCatalogReader.java:70)
[optiq-core-0.9-drill-r12.jar:na]
at
net.hydromatic.optiq.prepare.OptiqCatalogReader.getTable(OptiqCatalogReader.java:42)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.EmptyScope.getTableNamespace(EmptyScope.java:67)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:75)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:85)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:779)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:768)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2599)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2807)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:85)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:779)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:768)
[optiq-core-0.9-drill-r12.jar:na]
at org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:208)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:742)
[optiq-core-0.9-drill-r12.jar:na]
at
org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:458)
[optiq-core-0.9-drill-r12.jar:na]
at
net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:176)
[optiq-core-0.9-drill-r12.jar:na]
at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:145)
[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:125)
[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:145)
[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:507)
[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:185)
[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:254)
[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[na:1.7.0_45]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[na:1.7.0_45]
at java.lang.Thread.run(Unknown Source) [na:1.7.0_45]
2015-01-24 09:52:29,642 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.d.e.p.s.h.DefaultSqlHandler - Optiq Logical :
ProjectRel(*=[$0]): rowcount = 100.0, cumulative cost = {200.0 rows, 201.0 cpu,
0.0 io, 0.0 network, 0.0 memory}, id = 5
EnumerableTableAccessRel(table=[[cp, employee.json]]): rowcount = 100.0,
cumulative cost = {100.0 rows, 101.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id
= 2
2015-01-24 09:52:29,667 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.d.e.s.schedule.BlockMapBuilder - Took 0 ms to build endpoint map
2015-01-24 09:52:29,690 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.d.e.s.schedule.BlockMapBuilder - Failure finding Drillbit running on host
localhost. Skipping affinity to that host.
2015-01-24 09:52:29,690 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.d.e.s.schedule.BlockMapBuilder - FileWork group (/employee.json,0) max
bytes 0
2015-01-24 09:52:29,690 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.d.e.s.schedule.BlockMapBuilder - Took 22 ms to set endpoint bytes
2015-01-24 09:52:29,692 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.d.e.s.schedule.AffinityCreator - Took 0 ms to get operator affinity
2015-01-24 09:52:29,698 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.d.e.p.s.h.DefaultSqlHandler - Drill Logical :
DrillScreenRel: rowcount = 463.0, cumulative cost = {509.3 rows, 4630046.3 cpu,
0.0 io, 0.0 network, 0.0 memory}, id = 22
DrillScanRel(table=[[cp, employee.json]], groupscan=[EasyGroupScan
[selectionRoot=/employee.json, numFiles=1, columns=[`*`],
files=[/employee.json]]]): rowcount = 463.0, cumulative cost = {463.0 rows,
4630000.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 21
2015-01-24 09:52:29,711 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.d.e.p.s.h.DefaultSqlHandler - Drill Physical :
00-00 Screen: rowcount = 463.0, cumulative cost = {509.3 rows, 509.3 cpu,
0.0 io, 0.0 network, 0.0 memory}, id = 46
00-01 Scan(groupscan=[EasyGroupScan [selectionRoot=/employee.json,
numFiles=1, columns=[`*`], files=[/employee.json]]]): rowcount = 463.0,
cumulative cost = {463.0 rows, 463.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id
= 45
2015-01-24 09:52:29,753 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0: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" : "fs-scan",
"@id" : 1,
"files" : [ "/employee.json" ],
"storage" : {
"type" : "file",
"enabled" : true,
"connection" : "classpath:///",
"workspaces" : null,
"formats" : {
"csv" : {
"type" : "text",
"extensions" : [ "csv" ],
"delimiter" : ","
},
"tsv" : {
"type" : "text",
"extensions" : [ "tsv" ],
"delimiter" : "\t"
},
"json" : {
"type" : "json"
},
"parquet" : {
"type" : "parquet"
}
}
},
"format" : {
"type" : "json"
},
"columns" : [ "`*`" ],
"selectionRoot" : "/employee.json",
"cost" : 463.0
}, {
"pop" : "screen",
"@id" : 0,
"child" : 1,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 463.0
} ]
}
2015-01-24 09:52:29,758 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.d.e.s.schedule.AssignmentCreator - Assigning 1 units to 1 endpoints
2015-01-24 09:52:29,758 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.d.e.s.schedule.AssignmentCreator - Assigned unit: File: /employee.json
start: 0 length: 474630 to minorFragmentId: 0
2015-01-24 09:52:29,758 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.d.e.s.schedule.AssignmentCreator - Took 0 ms to apply assignments
2015-01-24 09:52:29,797 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.d.e.p.f.SimpleParallelizer - Root fragment:
handle {
query_id {
part1: 3115451154277094032
part2: -3949962637415327264
}
major_fragment_id: 0
minor_fragment_id: 0
}
fragment_json: "{
"pop" : "screen",
"@id" : 0,
"child" : {
"pop" : "fs-sub-scan",
"@id" : 1,
"files" : [ {
"start" : 0,
"length" : 474630,
"path" : "/employee.json"
} ],
"storage" : {
"type" : "file",
"enabled" : true,
"connection" : "classpath:///",
"workspaces" : null,
"formats" : {
"csv" : {
"type" : "text",
"extensions" : [ "csv" ],
"delimiter" : ","
},
"tsv" : {
"type" : "text",
"extensions" : [ "tsv" ],
"delimiter" : "\t"
},
"json" : {
"type" : "json"
},
"parquet" : {
"type" : "parquet"
}
}
},
"format" : {
"type" : "named",
"name" : "json"
},
"columns" : [ "`*`" ],
"selectionRoot" : "/employee.json",
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 0.0
},
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 0.0
}"
leaf_fragment: true
assignment {
address: "localhost.localdomain"
user_port: 31010
control_port: 31011
data_port: 31012
}
foreman {
address: "localhost.localdomain"
user_port: 31010
control_port: 31011
data_port: 31012
}
mem_initial: 1000000
mem_max: 10000000000
query_start_time: 1422111149758
credentials {
user_name: ""
}
time_zone: 166
options_json: "[ ]"
2015-01-24 09:52:29,798 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.d.exec.rpc.control.WorkEventBus - Adding fragment status listener for
queryId part1: 3115451154277094032
part2: -3949962637415327264
.
2015-01-24 09:52:29,798 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.drill.exec.work.foreman.Foreman - Submitting fragments to run.
2015-01-24 09:52:29,807 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.drill.exec.ops.FragmentContext - Getting initial memory allocation of
1000000
2015-01-24 09:52:29,807 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.drill.exec.ops.FragmentContext - Fragment max allocation: 10000000000
2015-01-24 09:52:29,808 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.d.exec.memory.TopLevelAllocator - New child allocator with initial
reservation 1000000
2015-01-24 09:52:29,821 [2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0:foreman] DEBUG
o.a.drill.exec.work.foreman.Foreman - State change requested. PENDING -->
FAILED
2015-01-24 09:52:29,862 [WorkManager-1] ERROR
o.apache.drill.exec.work.WorkManager - Failure while running wrapper [Foreman:
2b3c4e51-85c4-5290-c92e-e9e8b8cb59e0]
java.lang.NullPointerException: null
at
org.apache.drill.exec.work.foreman.Foreman.cancelExecutingFragments(Foreman.java:483)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
org.apache.drill.exec.work.foreman.Foreman.moveToState(Foreman.java:436)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:194)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:254)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[na:1.7.0_45]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[na:1.7.0_45]
at java.lang.Thread.run(Unknown Source) [na:1.7.0_45]
