Thanks, I got the drill version apache-drill-0.6.0.rc0, I am able to move one
step forward.
However When I go on to connect jdbc drill local
I get the following Exception
10:40:30.389 [main] ERROR org.apache.hadoop.util.Shell - Failed to locate the
winutils binary in the hadoop binar
y path
java.io.IOException: Could not locate executable null\bin\winutils.exe in the
Hadoop binaries.
at org.apache.hadoop.util.Shell.getQualifiedBinPath(Shell.java:318)
[hadoop-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)
[hadoop-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-common-2.4.1.jar:na]
at
org.apache.hadoop.security.Groups.getUserToGroupsMappingService(Groups.java:240)
[hadoop-common-2.4.1.
jar:na]
at
org.apache.hadoop.security.UserGroupInformation.initialize(UserGroupInformation.java:255)
[hadoop-comm
on-2.4.1.jar:na]
at
org.apache.hadoop.security.UserGroupInformation.ensureInitialized(UserGroupInformation.java:232)
[hado
op-common-2.4.1.jar:na]
at
org.apache.hadoop.security.UserGroupInformation.loginUserFromSubject(UserGroupInformation.java:718)
[h
adoop-common-2.4.1.jar:na]
at
org.apache.hadoop.security.UserGroupInformation.getLoginUser(UserGroupInformation.java:703)
[hadoop-co
mmon-2.4.1.jar:na]
at
org.apache.hadoop.security.UserGroupInformation.getCurrentUser(UserGroupInformation.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)
[hadoop-common-2.4.1.jar:na]
at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:368)
[hadoop-common-2.4.1.jar:na]
at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:167)
[hadoop-common-2.4.1.jar:na]
at
org.apache.drill.exec.store.dfs.shim.FileSystemCreator.getFileSystem(FileSystemCreator.java:31)
[drill
-java-exec-0.6.0-incubating-rebuffed.jar:0.6.0-incubating]
at
org.apache.drill.exec.store.dfs.FileSystemPlugin.<init>(FileSystemPlugin.java:71)
[drill-java-exec-0.6
.0-incubating-rebuffed.jar:0.6.0-incubating]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method) [na:1.7.0_67]
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
[na:1.7.0
_67]
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[
na:1.7.0_67]
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
[na:1.7.0_67]
at
org.apache.drill.exec.store.StoragePluginRegistry.create(StoragePluginRegistry.java:267)
[drill-java-e
xec-0.6.0-incubating-rebuffed.jar:0.6.0-incubating]
at
org.apache.drill.exec.store.StoragePluginRegistry.createPlugins(StoragePluginRegistry.java:169)
[drill
-java-exec-0.6.0-incubating-rebuffed.jar:0.6.0-incubating]
at
org.apache.drill.exec.store.StoragePluginRegistry.init(StoragePluginRegistry.java:130)
[drill-java-exe
c-0.6.0-incubating-rebuffed.jar:0.6.0-incubating]
at org.apache.drill.exec.server.Drillbit.run(Drillbit.java:153)
[drill-java-exec-0.6.0-incubating-rebuffe
d.jar:0.6.0-incubating]
at
org.apache.drill.jdbc.DrillConnectionImpl.<init>(DrillConnectionImpl.java:76)
[drill-jdbc-0.6.0-incuba
ting.jar:0.6.0-incubating]
at
org.apache.drill.jdbc.DrillJdbc41Factory$DrillJdbc41Connection.<init>(DrillJdbc41Factory.java:88)
[dri
ll-jdbc-0.6.0-incubating.jar:0.6.0-incubating]
at
org.apache.drill.jdbc.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:57)
[drill-jdbc-0.
6.0-incubating.jar:0.6.0-incubating]
at
org.apache.drill.jdbc.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:43)
[drill-jdbc-0.
6.0-incubating.jar:0.6.0-incubating]
at
org.apache.drill.jdbc.DrillFactory.newConnection(DrillFactory.java:51)
[drill-jdbc-0.6.0-incubating.ja
r:0.6.0-incubating]
at
net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:126)
[optiq-avatica-0.9-dril
l-r4.jar:na]
at sqlline.SqlLine$DatabaseConnection.connect(SqlLine.java:4732)
[sqlline-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.jar:na]
at sqlline.SqlLine$Commands.connect(SqlLine.java:3935)
[sqlline-1.1.6.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.7.0_67]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
~[na:1.7.0_67]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.7.0_67]
at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_67]
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]
Oct 23, 2014 10:40:30 AM org.glassfish.jersey.server.ApplicationHandler
initialize
INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29 01:25:26...
Thanks
Vijay
-----Original Message-----
From: Aditya [mailto:[email protected]]
Sent: Thursday, October 23, 2014 12:10 AM
To: drill
Subject: Re: unable to finish drill setup
There was a bug[1] in Windows batch file in 0.5 release.
This is fixed in 0.6 and later which you can download from here[2].
[1] https://issues.apache.org/jira/browse/DRILL-1428
[2] http://people.apache.org/~smp/apache-drill-0.6.0.rc0/
On Wed, Oct 22, 2014 at 10:16 PM, arorav <[email protected]> wrote:
> Here is the java version
> java version "1.7.0_67"
> Java(TM) SE Runtime Environment (build 1.7.0_67-b01) Java HotSpot(TM)
> 64-Bit Server VM (build 24.65-b04, mixed mode)
>
>
> -----Original Message-----
> From: Jim Scott [mailto:[email protected]]
> Sent: Wednesday, October 22, 2014 3:11 PM
> To: [email protected]
> Subject: Re: unable to finish drill setup
>
> What output do you get if you run java -version
>
> On Wed, Oct 22, 2014 at 4:36 PM, arorav <[email protected]> wrote:
>
> > I am new to Drill, and following the instructions @
> > https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+in+10
> > +M
> > inutes
> >
> > To setup drill.
> > However I am getting the following error when I run sqlline.bat:
> > C:\drill\apache-drill-0.5.0-incubating\bin>sqlline.bat
> > DRILL_ARGS - ""
> > HADOOP_HOME not detected...
> > HBASE_HOME not detected...
> > Calculating Drill classpath...
> > Error: Could not find or load main class sqlline.SqlLine
> >
> > All help would be appreciated.
> >
> > Thanks
> > Vijay
> >
> >
>
>
> --
> *Jim Scott*
> Director, Enterprise Strategy & Architecture
> +1 (347) 746-9281
>
> <http://www.mapr.com/>
> [image: MapR Technologies] <http://www.mapr.com>
>