Hi,
I am trying to install apache drill 1.6 on windows 7 laptop.
This is how my drill-override.conf looks like :
drill.exec: {
cluster-id: "drillbits1",
zk.connect: "localhost:2181",
sys.store.provider.local.path="C:/data/drill"
}
When I issue the command I see the below error and I am not able to open up the
drill console using http://localhost:8047
Command: sqlline.bat -u "jdbc:drill:zk=local"
Output:
C:\DEV\drill\apache-drill-1.6.0>bin\sqlline.bat -u "jdbc:drill:zk=local"
DRILL_ARGS - " -u jdbc:drill:zk=local"
HADOOP_HOME not detected...
HBASE_HOME not detected...
Calculating Drill classpath...
16:33:42.894 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - Scanning classpath
for resources with pathname "drill-module.conf".
16:33:42.903 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-common-1.6.0.jar!/drill-module.conf.
16:33:42.903 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-gis-1.6.0.jar!/drill-module.conf.
16:33:42.903 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-hive-exec-shaded-1.6.0.jar!/drill-module.conf.
16:33:42.903 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-java-exec-1.6.0.jar!/drill-module.conf.
16:33:42.904 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-jdbc-storage-1.6.0.jar!/drill-module.conf.
16:33:42.904 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-kudu-storage-1.6.0.jar!/drill-module.conf.
16:33:42.904 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-logical-1.6.0.jar!/drill-module.conf.
16:33:42.904 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-memory-base-1.6.0.jar!/drill-module.conf.
16:33:42.905 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-mongo-storage-1.6.0.jar!/drill-module.conf.
16:33:42.905 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-storage-hbase-1.6.0.jar!/drill-module.conf.
16:33:42.905 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-storage-hive-core-1.6.0.jar!/drill-module.conf.
16:33:42.906 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/3rdparty/drill-memory-base-1.6.0.jar!/drill-module.conf.
16:33:42.936 [main] INFO o.a.drill.common.config.DrillConfig - Configuration
and plugin file(s) identified in 151ms.
Base Configuration:
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-common-1.6.0.jar!/drill-default.conf
Intermediate Configuration and Plugin files, in order of precedence:
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-mongo-storage-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-logical-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-java-exec-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-gis-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-storage-hive-core-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-common-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-kudu-storage-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-storage-hbase-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-memory-base-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/3rdparty/drill-memory-base-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-hive-exec-shaded-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-jdbc-storage-1.6.0.jar!/drill-module.conf
Overridden Properties:
-user =
-password =
-zk = local
16:33:42.942 [main] DEBUG o.a.drill.common.config.DrillConfig - Setting up
DrillConfig object.
16:33:42.964 [main] DEBUG o.a.drill.common.config.DrillConfig - DrillConfig
object initialized.
16:33:42.974 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - Scanning classpath
for resources with pathname "drill-module.conf".
16:33:42.974 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-common-1.6.0.jar!/drill-module.conf.
16:33:42.975 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-gis-1.6.0.jar!/drill-module.conf.
16:33:42.975 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-hive-exec-shaded-1.6.0.jar!/drill-module.conf.
16:33:42.975 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-java-exec-1.6.0.jar!/drill-module.conf.
16:33:42.975 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-jdbc-storage-1.6.0.jar!/drill-module.conf.
16:33:42.975 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-kudu-storage-1.6.0.jar!/drill-module.conf.
16:33:42.976 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-logical-1.6.0.jar!/drill-module.conf.
16:33:42.976 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-memory-base-1.6.0.jar!/drill-module.conf.
16:33:42.976 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-mongo-storage-1.6.0.jar!/drill-module.conf.
16:33:42.976 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-storage-hbase-1.6.0.jar!/drill-module.conf.
16:33:42.976 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-storage-hive-core-1.6.0.jar!/drill-module.conf.
16:33:42.977 [main] DEBUG o.a.d.c.scanner.ClassPathScanner - - collected
resource URL
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/3rdparty/drill-memory-base-1.6.0.jar!/drill-module.conf.
16:33:42.998 [main] INFO o.a.drill.common.config.DrillConfig - Configuration
and plugin file(s) identified in 26ms.
Base Configuration:
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-common-1.6.0.jar!/drill-default.conf
Intermediate Configuration and Plugin files, in order of precedence:
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-mongo-storage-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-logical-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-java-exec-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-gis-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-storage-hive-core-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-common-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-kudu-storage-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-storage-hbase-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-memory-base-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/3rdparty/drill-memory-base-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-hive-exec-shaded-1.6.0.jar!/drill-module.conf
-
jar:file:/C:/DEV/drill/apache-drill-1.6.0/jars/drill-jdbc-storage-1.6.0.jar!/drill-module.conf
16:33:43.002 [main] DEBUG o.a.drill.common.config.DrillConfig - Setting up
DrillConfig object.
16:33:43.011 [main] DEBUG o.a.drill.common.config.DrillConfig - DrillConfig
object initialized.
16:33:43.105 [main] DEBUG i.n.u.i.l.InternalLoggerFactory - Using SLF4J as the
default logging framework
16:33:43.113 [main] DEBUG i.n.util.internal.PlatformDependent0 -
java.nio.Buffer.address: available
16:33:43.113 [main] DEBUG i.n.util.internal.PlatformDependent0 -
sun.misc.Unsafe.theUnsafe: available
16:33:43.114 [main] DEBUG i.n.util.internal.PlatformDependent0 -
sun.misc.Unsafe.copyMemory: available
16:33:43.119 [main] DEBUG i.n.util.internal.PlatformDependent0 -
java.nio.Bits.unaligned: true
16:33:43.124 [main] DEBUG i.n.util.internal.PlatformDependent - Platform:
Windows
16:33:43.129 [main] DEBUG i.n.util.internal.PlatformDependent - Java version: 7
16:33:43.132 [main] DEBUG i.n.util.internal.PlatformDependent -
-Dio.netty.noUnsafe: false
16:33:43.136 [main] DEBUG i.n.util.internal.PlatformDependent -
sun.misc.Unsafe: available
16:33:43.141 [main] DEBUG i.n.util.internal.PlatformDependent -
-Dio.netty.noJavassist: false
16:33:43.232 [main] DEBUG i.n.util.internal.PlatformDependent - Javassist:
available
16:33:43.233 [main] DEBUG i.n.util.internal.PlatformDependent -
-Dio.netty.tmpdir: C:\Users\Z110540\AppData\Local\Temp (java.io.tmpdir)
16:33:43.233 [main] DEBUG i.n.util.internal.PlatformDependent -
-Dio.netty.bitMode: 32 (sun.arch.data.model)
16:33:43.239 [main] DEBUG i.n.util.internal.PlatformDependent -
-Dio.netty.noPreferDirect: false
16:33:43.242 [main] DEBUG i.n.buffer.PooledByteBufAllocator -
-Dio.netty.allocator.numHeapArenas: 4
16:33:43.247 [main] DEBUG i.n.buffer.PooledByteBufAllocator -
-Dio.netty.allocator.numDirectArenas: 0
16:33:43.251 [main] DEBUG i.n.buffer.PooledByteBufAllocator -
-Dio.netty.allocator.pageSize: 8192
16:33:43.255 [main] DEBUG i.n.buffer.PooledByteBufAllocator -
-Dio.netty.allocator.maxOrder: 11
16:33:43.260 [main] DEBUG i.n.buffer.PooledByteBufAllocator -
-Dio.netty.allocator.chunkSize: 16777216
16:33:43.265 [main] DEBUG i.n.buffer.PooledByteBufAllocator -
-Dio.netty.allocator.tinyCacheSize: 512
16:33:43.269 [main] DEBUG i.n.buffer.PooledByteBufAllocator -
-Dio.netty.allocator.smallCacheSize: 256
16:33:43.273 [main] DEBUG i.n.buffer.PooledByteBufAllocator -
-Dio.netty.allocator.normalCacheSize: 64
16:33:43.278 [main] DEBUG i.n.buffer.PooledByteBufAllocator -
-Dio.netty.allocator.maxCachedBufferCapacity: 32768
16:33:43.282 [main] DEBUG i.n.buffer.PooledByteBufAllocator -
-Dio.netty.allocator.cacheTrimInterval: 8192
java.lang.ExceptionInInitializerError
apache drill 1.6.0
"a little sql for your nosql"
0: jdbc:drill:zk=local>
0: jdbc:drill:zk=local> !list
1 active connection:
#0 closed jdbc:drill:zk=local
0: jdbc:drill:zk=local>
Please help.
Lakshmi
