[ https://issues.apache.org/jira/browse/DRILL-1907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14299259#comment-14299259 ]
Brandon Newell edited comment on DRILL-1907 at 2/16/15 5:14 PM: ---------------------------------------------------------------- UPDATE: I addressed the %HADOOP_HOME% to point to the local MapR Client folder where the winutils.exe is located. I chose C:\opt\mapr\hadoop\hadoop-2.5.1 I then modified the c:\drill\conf\drill-override.conf to show: {noformat} drill.exec: { cluster-id: "drillbits1", zk.connect: "localhost:2181", tmp: { directories: ["c:/drill/tmp/drill"], filesystem: "drill-local:///" } sys.store.provider: { class: "org.apache.drill.exec.store.sys.zk.ZkPStoreProvider", # The following section is used by ZkPStoreProvider zk: { blobroot: "file:///var/log/drill" }, # The following section is only required by LocalPStoreProvider local: { path: "c:/drill/tmp/drill", write: true } } } {noformat} Once you are in the drill\bin folder, execute sqlline.bat -u "jdbc:drill:zk=local" I successfully was able to interact with the Drill shell. was (Author: bnewell): UPDATE: I addressed the %HADOOP_HOME% to point to the local MapR Client folder where the winutils.exe is located. I chose C:\opt\mapr\hadoop\hadoop-2.5.1 I then modified the c:\drill\conf\drill-override.conf to show: """ drill.exec: { cluster-id: "drillbits1", zk.connect: "localhost:2181", tmp: { directories: ["c:/drill/tmp/drill"], filesystem: "drill-local:///" } sys.store.provider: { class: "org.apache.drill.exec.store.sys.zk.ZkPStoreProvider", # The following section is used by ZkPStoreProvider zk: { blobroot: "file:///var/log/drill" }, # The following section is only required by LocalPStoreProvider local: { path: "c:/drill/tmp/drill", write: true } } } """ Once you are in the drill\bin folder, execute sqlline.bat -u "jdbc:drill:zk=local" I successfully was able to interact with the Drill shell. > "Failure while attempting to start Drillbit in embedded mode" on Windows 2012 > ----------------------------------------------------------------------------- > > Key: DRILL-1907 > URL: https://issues.apache.org/jira/browse/DRILL-1907 > Project: Apache Drill > Issue Type: Improvement > Affects Versions: 0.7.0 > Environment: Windows Server 2012 > java version "1.7.0_60" > Java(TM) SE Runtime Environment (build 1.7.0_60-b19) > Java HotSpot(TM) Client VM (build 24.60-b09, mixed mode) > Reporter: Geoffrey Cleaves > Assignee: Patrick Wong > Fix For: 0.8.0 > > > I am following the Apache Drill in 10 minutes tut on running on Windows. I > double click on sqlline.bat, enter "!connect jdbc:drill:zk=local" then > "admin" and "admin". This results in the following errors: > 17:30:35.668 [main] ERROR org.apache.hadoop.util.Shell - Failed to locate the > wi > nutils binary in the hadoop binary path > java.io.IOException: Could not locate executable null\bin\winutils.exe in the > Ha > doop binaries. > at org.apache.hadoop.util.Shell.getQualifiedBinPath(Shell.java:318) > [had > oop-common-2.4.1.jar:na] > at org.apache.hadoop.util.Shell.getWinUtilsPath(Shell.java:333) > [hadoop- > common-2.4.1.jar:na] > at org.apache.hadoop.util.Shell.<clinit>(Shell.java:326) > [hadoop-common- > 2.4.1.jar:na] > at org.apache.hadoop.util.StringUtils.<clinit>(StringUtils.java:76) > [had > oop-common-2.4.1.jar:na] > at > org.apache.hadoop.security.Groups.parseStaticMapping(Groups.java:93) > [hadoop-common-2.4.1.jar:na] > at org.apache.hadoop.security.Groups.<init>(Groups.java:77) > [hadoop-comm > on-2.4.1.jar:na] > at > org.apache.hadoop.security.Groups.getUserToGroupsMappingService(Group > s.java:240) [hadoop-common-2.4.1.jar:na] > at > org.apache.hadoop.security.UserGroupInformation.initialize(UserGroupI > nformation.java:255) [hadoop-common-2.4.1.jar:na] > at > org.apache.hadoop.security.UserGroupInformation.ensureInitialized(Use > rGroupInformation.java:232) [hadoop-common-2.4.1.jar:na] > at > org.apache.hadoop.security.UserGroupInformation.loginUserFromSubject( > UserGroupInformation.java:718) [hadoop-common-2.4.1.jar:na] > at > org.apache.hadoop.security.UserGroupInformation.getLoginUser(UserGrou > pInformation.java:703) [hadoop-common-2.4.1.jar:na] > at > org.apache.hadoop.security.UserGroupInformation.getCurrentUser(UserGr > oupInformation.java:605) [hadoop-common-2.4.1.jar:na] > at > org.apache.hadoop.fs.FileSystem$Cache$Key.<init>(FileSystem.java:2554 > ) [hadoop-common-2.4.1.jar:na] > at > org.apache.hadoop.fs.FileSystem$Cache$Key.<init>(FileSystem.java:2546 > ) [hadoop-common-2.4.1.jar:na] > at org.apache.hadoop.fs.FileSystem$Cache.get(FileSystem.java:2412) > [hado > op-common-2.4.1.jar:na] > at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:368) > [hadoop-comm > on-2.4.1.jar:na] > at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:167) > [hadoop-comm > on-2.4.1.jar:na] > at > org.apache.drill.exec.store.dfs.shim.FileSystemCreator.getFileSystem( > FileSystemCreator.java:31) [drill-java-exec-0.7.0-rebuffed.jar:0.7.0] > at > org.apache.drill.exec.store.sys.local.FilePStore.getFileSystem(FilePS > tore.java:87) [drill-java-exec-0.7.0-rebuffed.jar:0.7.0] > at > org.apache.drill.exec.store.sys.local.LocalPStoreProvider.<init>(Loca > lPStoreProvider.java:51) [drill-java-exec-0.7.0-rebuffed.jar:0.7.0] > at org.apache.drill.exec.server.Drillbit.<init>(Drillbit.java:109) > [dril > l-java-exec-0.7.0-rebuffed.jar:0.7.0] > at > org.apache.drill.jdbc.DrillConnectionImpl.<init>(DrillConnectionImpl. > java:78) [drill-jdbc-0.7.0.jar:0.7.0] > at > org.apache.drill.jdbc.DrillJdbc41Factory$DrillJdbc41Connection.<init> > (DrillJdbc41Factory.java:88) [drill-jdbc-0.7.0.jar:0.7.0] > at > org.apache.drill.jdbc.DrillJdbc41Factory.newDrillConnection(DrillJdbc > 41Factory.java:57) [drill-jdbc-0.7.0.jar:0.7.0] > at > org.apache.drill.jdbc.DrillJdbc41Factory.newDrillConnection(DrillJdbc > 41Factory.java:43) [drill-jdbc-0.7.0.jar:0.7.0] > at > org.apache.drill.jdbc.DrillFactory.newConnection(DrillFactory.java:51 > ) [drill-jdbc-0.7.0.jar:0.7.0] > at > net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver. > java:126) [optiq-avatica-0.9-drill-r12.jar:na] > at sqlline.SqlLine$DatabaseConnection.connect(SqlLine.java:4732) > [sqllin > e-1.1.6.jar:na] > at > sqlline.SqlLine$DatabaseConnection.getConnection(SqlLine.java:4786) [ > sqlline-1.1.6.jar:na] > at sqlline.SqlLine$Commands.connect(SqlLine.java:4026) > [sqlline-1.1.6.ja > r:na] > at sqlline.SqlLine$Commands.connect(SqlLine.java:3935) > [sqlline-1.1.6.ja > r:na] > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > ~[na:1.7. > 0_60] > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > ~[na:1.7. > 0_60] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > ~[na: > 1.7.0_60] > at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.7.0_60] > at > sqlline.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2884) [ > sqlline-1.1.6.jar:na] > at sqlline.SqlLine.dispatch(SqlLine.java:885) [sqlline-1.1.6.jar:na] > at sqlline.SqlLine.begin(SqlLine.java:763) [sqlline-1.1.6.jar:na] > at sqlline.SqlLine.start(SqlLine.java:498) [sqlline-1.1.6.jar:na] > at sqlline.SqlLine.main(SqlLine.java:460) [sqlline-1.1.6.jar:na] > Error: Failure while attempting to start Drillbit in embedded mode. > (state=,code > =0) > 0: jdbc:drill:zk=local> -- This message was sent by Atlassian JIRA (v6.3.4#6332)