[
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:11 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:
"""
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.
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)
