You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Benjamin Etten <si...@gmail.com> on 2015/06/09 22:31:04 UTC

Issue getting Drill up and running on Windows

I just installed Drill last night on my Mac (after seeing a fantastic
presentation, I am SO blown away!).  No problems there... however, I am
having issues getting it to run on Windows.  I have checked the list of
pre-reqs, including Environment Variables.

When I execute the following, (see below in bold) at command line prompt, I
get a few outputs from Drill and then it dumps me right back to the command
line.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - -

C:\Program Files (x86)\apache-drill-1.0.0\bin>*sqlline sqlline.bat -u
"jdbc:drill:schema=dfs;zk=local"*

DRILL_ARGS - " sqlline.bat -u jdbc:drill:schema=dfs;zk=local"
\apache-drill-1.0.0\conf was unexpected at this time.

C:\Program Files (x86)\apache-drill-1.0.0\bin>

- - - - - - - - - - - - - - - - - - - - - - - - - - - - -

I am not seeing any error messages.  Earlier I was getting an error about
the JAVA_HOME variable pointing incorrectly, but I fixed that and now....
well, nothing.  Even a hint at what else I should check on would be helpful.

Thanks in advance... and seriously, keep up the good work.  This is AMAZING!

Ben

Re: Issue getting Drill up and running on Windows

Posted by Kristine Hahn <kh...@maprtech.com>.
Additional note: you can ignore the configuration error message  (
https://issues.apache.org/jira/browse/DRILL-3120), this is expected as
shown below:

C:\apache-drill-1.0.0\bin>sqlline.bat -u "jdbc:dri
l:schema=dfs;zk=local"
DRILL_ARGS - " -u jdbc:drill:schema=dfs;zk=local"
HADOOP_HOME not detected...
HBASE_HOME not detected...
Calculating Drill classpath...
Error setting configuration: isolation: java.lang.NullPointerException
Jun 09, 2015 2:08:58 PM org.glassfish.jersey.server.ApplicationHandler
initiali
e
INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29
01:25:26...
apache drill 1.0.0
"start your sql engine"

Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn


On Tue, Jun 9, 2015 at 1:43 PM, Andries Engelbrecht <
aengelbrecht@maprtech.com> wrote:

> The connection string is wrong.
>
> Use
> sqlline.bat -u "jdbc:drill:zk=local"
>
> On Jun 9, 2015, at 1:31 PM, Benjamin Etten <si...@gmail.com>
> wrote:
>
> > I just installed Drill last night on my Mac (after seeing a fantastic
> > presentation, I am SO blown away!).  No problems there... however, I am
> > having issues getting it to run on Windows.  I have checked the list of
> > pre-reqs, including Environment Variables.
> >
> > When I execute the following, (see below in bold) at command line
> prompt, I
> > get a few outputs from Drill and then it dumps me right back to the
> command
> > line.
> >
> > - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> >
> > C:\Program Files (x86)\apache-drill-1.0.0\bin>*sqlline sqlline.bat -u
> > "jdbc:drill:schema=dfs;zk=local"*
> >
> > DRILL_ARGS - " sqlline.bat -u jdbc:drill:schema=dfs;zk=local"
> > \apache-drill-1.0.0\conf was unexpected at this time.
> >
> > C:\Program Files (x86)\apache-drill-1.0.0\bin>
> >
> > - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> >
> > I am not seeing any error messages.  Earlier I was getting an error about
> > the JAVA_HOME variable pointing incorrectly, but I fixed that and now....
> > well, nothing.  Even a hint at what else I should check on would be
> helpful.
> >
> > Thanks in advance... and seriously, keep up the good work.  This is
> AMAZING!
> >
> > Ben
>
>

Re: Issue getting Drill up and running on Windows

Posted by Andries Engelbrecht <ae...@maprtech.com>.
The connection string is wrong.

Use
sqlline.bat -u "jdbc:drill:zk=local"

On Jun 9, 2015, at 1:31 PM, Benjamin Etten <si...@gmail.com> wrote:

> I just installed Drill last night on my Mac (after seeing a fantastic
> presentation, I am SO blown away!).  No problems there... however, I am
> having issues getting it to run on Windows.  I have checked the list of
> pre-reqs, including Environment Variables.
> 
> When I execute the following, (see below in bold) at command line prompt, I
> get a few outputs from Drill and then it dumps me right back to the command
> line.
> 
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> 
> C:\Program Files (x86)\apache-drill-1.0.0\bin>*sqlline sqlline.bat -u
> "jdbc:drill:schema=dfs;zk=local"*
> 
> DRILL_ARGS - " sqlline.bat -u jdbc:drill:schema=dfs;zk=local"
> \apache-drill-1.0.0\conf was unexpected at this time.
> 
> C:\Program Files (x86)\apache-drill-1.0.0\bin>
> 
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> 
> I am not seeing any error messages.  Earlier I was getting an error about
> the JAVA_HOME variable pointing incorrectly, but I fixed that and now....
> well, nothing.  Even a hint at what else I should check on would be helpful.
> 
> Thanks in advance... and seriously, keep up the good work.  This is AMAZING!
> 
> Ben