Hello! Forgive me if you've already done so, but as a sanity check: Have you set up the Windows environment variables as per this article?
http://www.dremio.com/blog/installing-apache-drill-on-microsoft-windows/ It's a little tricky, notice how for the 'Path' variable you need the trailing 'bin' directory, but you don't need it for the JAVA_HOME one. Best, Nathan Griffith Technical Writer Dremio On Wed, May 25, 2016 at 2:36 PM, Doddi, Lakshmi < lakshmi.do...@cvscaremark.com> wrote: > 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 >
