RE: Apache Drill in 10 Minutes - Problems

[Richardson, David]

I have tried the HADOOP_HOME solution, but I still get the same behaviour.

I suspect that this is a class path ordering issue.

The message in the logs states that Drill failed to load a JDBC driver because 
it could not instantiate com.google.common.base.Stopwatch

Using Intellij  I had a look at the 1.13.0 branch and looked up all the 
Stopwatch classes in the namespace com.google.common.base

There are two of them.  One in the guava-18.0 library and another in the 
hive-exec-2.3.2 library.

It would appear that the hive-exec-2.3.2 library does not implement the 
Stopwatch class as per guava-18.0, for example the constructor in guava-18.0 is 
both private and marked as Deprecated.

It is also worth noting that there are two other libraries that package 
com.google.common.base.Stopwatch, but in different namespaces.  Neither of 
these libs reflects the guiava-18.0 version of Stopwatch (the constructors are 
public and not private).  These libs are:

jersey-guava-2.8
avro-1.8.2

Given that you guys are experts in the Drill code base, what are your views on 
this?

Dave.

-Original Message-
From: Kunal Khatua [mailto:ku...@apache.org] 
Sent: 29 May 2018 21:59
To: user@drill.apache.org
Cc: Charles Givre; Divya Gehlot
Subject: Re: Apache Drill in 10 Minutes - Problems

This is very odd. Out of the box, using Drill in embedded mode (i.e. zk=local)  
works for me.
I'm testing with Apache Drill 1.13.0 on Windows 10. Nothing fancy in my env var 
PATH.
Everything points to JDK8.

You're seeing this with a clean setup as well? (for an existing machine, you 
should rename the c:\tmp\drill dir as well, just so that nothing has been 
corrupted)

You can try Shuporno's suggestions, though (in embedded mode), Drill will have 
no other dependencies. If it's worked for him, there might be something that 
I'm missing. On 5/29/2018 4:56:10 AM, Shuporno Choudhury 
 wrote:
Hi,

Probably this might help:
1. Download *winutils.exe* and *hadoop.dll* from 
https://github.com/steveloughran/winutils/tree/master/hadoop-2.7.1/bin
2. Put these 2 files in the */bin* folder of Drill 3. Set *HADOOP_HOME* (in 
environment variable) to the the directory which contains the Drill */bin 
*folder.
Eg: If your folder structure is
D:/folder1/folder2/apache-drill-some-version/bin, then set *HADOOP_HOME* to 
*D:/folder1/folder2/apache-drill-some-version*, so that HADOOP_HOME/bin 
contains winutils.exe and hadoop.dll

Please give this a try. It should solve your problem.

After following the above mentioned steps, try starting Drill again.
If this method works, HADOOP_HOME *won't* come out as "HADOOP_HOME not 
detected... ". Instead, you will get HADOOP_HOME as the path you set in the 
environment variable and Drill would start running fine.

On Tue, May 29, 2018 at 4:04 PM, Richardson, David <> 
david.richard...@uk.daiwacm.com> wrote:

> I’ve spent the whole morning going through some things.
>
> 1). The windows PATH variable only has the path to the Java JDK in it.
> 2). I’ve been through the class path output in the log file, and only 
> has references to files under C:\Program Files\Apache 
> Drill\apache-drill-1.13.0\jars 3). I tried the UDF fix described below 
> and this did not fix it (the drill\udf\registry folder is created 
> under my profile).
>
> Thinking about it logically (I have tried to run the Drill code base 
> using Intellij but got lots of dependency errors), the log throws an 
> exception when loading a jdbc driver (guava class issue), so I used 
> jdeps to try to find the clash in guava versions, and it looks like 
> everything is using
> guava-18.0
>
> Also while digging around I found this on stackoverflow, this person 
> gets the same behaviour (it was asked only 5 days ago):
>
> https://stackoverflow.com/questions/50487014/apache-
> drill-1-12-0-failure-in-starting-embedded-drillbit-and-no-current-conn
>
> and another developer that I work with followed the 10 minute tutorial 
> and got exactly the same behaviour, so that is 5 people(including 
> stackoverflow).
>
> What is interesting is that the guy on stackoverflow is also a Windows 
> user. Are there folk in the Drill community who use Windows desk tops, 
> or are most people using either Mac OS or Ubuntu?
>
> I really don’t know how to proceed.
>
> Dave.
>
> From: Charles Givre [mailto:cgi...@gmail.com]
> Sent: 24 May 2018 19:21
> To: Richardson, David
> Cc: user; Divya Gehlot
> Subject: Re: Apache Drill in 10 Minutes - Problems
>
> I love helpful error messages ;-) Can you check the classpath to see 
> if there any additional classes that are there? I’ve gotten connection 
> issues like this when I had a database driver in the CLASSPATH.
>
> Also take a look at this response: http://mail-archives.apache.
> org/mod_mbox/drill-user/201612.mbox/%3CDF1248D3D81CAF44B1FD58565206
> 18650c6698c...@sacvmsx

Re: Apache Drill in 10 Minutes - Problems

[Ted Dunning]

David,

Sad to hear that a random cheap shot from the bleachers didn't work out.


On Wed, May 30, 2018 at 10:21 AM Richardson, David <
david.richard...@uk.daiwacm.com> wrote:

> Thanks Ted.
>
> Just tried removing the spaces from my directory structure for the
> binaries (I had put it into Program Files).
>
> Unfortunately I still get the same problem.
>
> Dave.
>
>
>
> -Original Message-
> From: Ted Dunning [mailto:ted.dunn...@gmail.com]
> Sent: 30 May 2018 10:08
> To: user
> Subject: Re: Apache Drill in 10 Minutes - Problems
>
> I see no evidence that this is the problem other than people are saying
> "problem on windows", but is there a space in a directory name somewhere?
>
> This is a classic problem when moving programs from Linux/OSX and has been
> a problem with Drill in the past. It isn't a technical issue so much as
> directory names with spaces seem more common on Windows platforms.
>
> The problem can masquerade in all kinds of subtle ways.
>
>
>
>
>
> On Tue, May 29, 2018 at 10:00 PM Kunal Khatua  wrote:
>
> > This is very odd. Out of the box, using Drill in embedded mode (i.e.
> > zk=local)  works for me.
> > I'm testing with Apache Drill 1.13.0 on Windows 10. Nothing fancy in
> > my env var PATH.
> > Everything points to JDK8.
> >
> > You're seeing this with a clean setup as well? (for an existing
> > machine, you should rename the c:\tmp\drill dir as well, just so that
> > nothing has been corrupted)
> >
> > You can try Shuporno's suggestions, though (in embedded mode), Drill
> > will have no other dependencies. If it's worked for him, there might
> > be something that I'm missing.
> > On 5/29/2018 4:56:10 AM, Shuporno Choudhury <
> > shuporno.choudh...@manthan.com> wrote:
> > Hi,
> >
> > Probably this might help:
> > 1. Download *winutils.exe* and *hadoop.dll* from
> > https://github.com/steveloughran/winutils/tree/master/hadoop-2.7.1/bin
> > 2. Put these 2 files in the */bin* folder of Drill 3. Set
> > *HADOOP_HOME* (in environment variable) to the the directory which
> > contains the Drill */bin *folder.
> > Eg: If your folder structure is
> > D:/folder1/folder2/apache-drill-some-version/bin, then set
> > *HADOOP_HOME* to *D:/folder1/folder2/apache-drill-some-version*, so
> > that HADOOP_HOME/bin contains winutils.exe and hadoop.dll
> >
> > Please give this a try. It should solve your problem.
> >
> > After following the above mentioned steps, try starting Drill again.
> > If this method works, HADOOP_HOME *won't* come out as "HADOOP_HOME not
> > detected... ". Instead, you will get HADOOP_HOME as the path you set
> > in the environment variable and Drill would start running fine.
> >
> > On Tue, May 29, 2018 at 4:04 PM, Richardson, David <>
> > david.richard...@uk.daiwacm.com> wrote:
> >
> > > I’ve spent the whole morning going through some things.
> > >
> > > 1). The windows PATH variable only has the path to the Java JDK in it.
> > > 2). I’ve been through the class path output in the log file, and
> > > only has references to files under C:\Program Files\Apache
> > > Drill\apache-drill-1.13.0\jars 3). I tried the UDF fix described
> > > below and this did not fix it (the drill\udf\registry folder is
> > > created under my profile).
> > >
> > > Thinking about it logically (I have tried to run the Drill code base
> > using
> > > Intellij but got lots of dependency errors), the log throws an
> > > exception when loading a jdbc driver (guava class issue), so I used
> > > jdeps to try to find the clash in guava versions, and it looks like
> > > everything is using
> > > guava-18.0
> > >
> > > Also while digging around I found this on stackoverflow, this person
> > > gets the same behaviour (it was asked only 5 days ago):
> > >
> > > https://stackoverflow.com/questions/50487014/apache-
> > > drill-1-12-0-failure-in-starting-embedded-drillbit-and-no-current-co
> > > nn
> > >
> > > and another developer that I work with followed the 10 minute
> > > tutorial
> > and
> > > got exactly the same behaviour, so that is 5 people(including
> > > stackoverflow).
> > >
> > > What is interesting is that the guy on stackoverflow is also a
> > > Windows user. Are there folk in the Drill community who use Windows
> > > desk tops, or are most people using either Mac OS or Ubuntu?
> > >
> > > I really don’t know h

RE: Apache Drill in 10 Minutes - Problems

[Richardson, David]

Thanks Ted.

Just tried removing the spaces from my directory structure for the binaries (I 
had put it into Program Files).

Unfortunately I still get the same problem.

Dave.



-Original Message-
From: Ted Dunning [mailto:ted.dunn...@gmail.com] 
Sent: 30 May 2018 10:08
To: user
Subject: Re: Apache Drill in 10 Minutes - Problems

I see no evidence that this is the problem other than people are saying 
"problem on windows", but is there a space in a directory name somewhere?

This is a classic problem when moving programs from Linux/OSX and has been a 
problem with Drill in the past. It isn't a technical issue so much as directory 
names with spaces seem more common on Windows platforms.

The problem can masquerade in all kinds of subtle ways.





On Tue, May 29, 2018 at 10:00 PM Kunal Khatua  wrote:

> This is very odd. Out of the box, using Drill in embedded mode (i.e.
> zk=local)  works for me.
> I'm testing with Apache Drill 1.13.0 on Windows 10. Nothing fancy in 
> my env var PATH.
> Everything points to JDK8.
>
> You're seeing this with a clean setup as well? (for an existing 
> machine, you should rename the c:\tmp\drill dir as well, just so that 
> nothing has been corrupted)
>
> You can try Shuporno's suggestions, though (in embedded mode), Drill 
> will have no other dependencies. If it's worked for him, there might 
> be something that I'm missing.
> On 5/29/2018 4:56:10 AM, Shuporno Choudhury < 
> shuporno.choudh...@manthan.com> wrote:
> Hi,
>
> Probably this might help:
> 1. Download *winutils.exe* and *hadoop.dll* from 
> https://github.com/steveloughran/winutils/tree/master/hadoop-2.7.1/bin
> 2. Put these 2 files in the */bin* folder of Drill 3. Set 
> *HADOOP_HOME* (in environment variable) to the the directory which 
> contains the Drill */bin *folder.
> Eg: If your folder structure is
> D:/folder1/folder2/apache-drill-some-version/bin, then set 
> *HADOOP_HOME* to *D:/folder1/folder2/apache-drill-some-version*, so 
> that HADOOP_HOME/bin contains winutils.exe and hadoop.dll
>
> Please give this a try. It should solve your problem.
>
> After following the above mentioned steps, try starting Drill again.
> If this method works, HADOOP_HOME *won't* come out as "HADOOP_HOME not 
> detected... ". Instead, you will get HADOOP_HOME as the path you set 
> in the environment variable and Drill would start running fine.
>
> On Tue, May 29, 2018 at 4:04 PM, Richardson, David <> 
> david.richard...@uk.daiwacm.com> wrote:
>
> > I’ve spent the whole morning going through some things.
> >
> > 1). The windows PATH variable only has the path to the Java JDK in it.
> > 2). I’ve been through the class path output in the log file, and 
> > only has references to files under C:\Program Files\Apache 
> > Drill\apache-drill-1.13.0\jars 3). I tried the UDF fix described 
> > below and this did not fix it (the drill\udf\registry folder is 
> > created under my profile).
> >
> > Thinking about it logically (I have tried to run the Drill code base
> using
> > Intellij but got lots of dependency errors), the log throws an 
> > exception when loading a jdbc driver (guava class issue), so I used 
> > jdeps to try to find the clash in guava versions, and it looks like 
> > everything is using
> > guava-18.0
> >
> > Also while digging around I found this on stackoverflow, this person 
> > gets the same behaviour (it was asked only 5 days ago):
> >
> > https://stackoverflow.com/questions/50487014/apache-
> > drill-1-12-0-failure-in-starting-embedded-drillbit-and-no-current-co
> > nn
> >
> > and another developer that I work with followed the 10 minute 
> > tutorial
> and
> > got exactly the same behaviour, so that is 5 people(including 
> > stackoverflow).
> >
> > What is interesting is that the guy on stackoverflow is also a 
> > Windows user. Are there folk in the Drill community who use Windows 
> > desk tops, or are most people using either Mac OS or Ubuntu?
> >
> > I really don’t know how to proceed.
> >
> > Dave.
> >
> > From: Charles Givre [mailto:cgi...@gmail.com]
> > Sent: 24 May 2018 19:21
> > To: Richardson, David
> > Cc: user; Divya Gehlot
> > Subject: Re: Apache Drill in 10 Minutes - Problems
> >
> > I love helpful error messages ;-) Can you check the classpath to see 
> > if there any additional classes that are there? I’ve gotten 
> > connection
> issues
> > like this when I had a database driver in the CLASSPATH.
> >
> > Also take a look at this response: http://mail-archives.apache.
> > o

Re: Apache Drill in 10 Minutes - Problems

[Ted Dunning]

I see no evidence that this is the problem other than people are saying
"problem on windows", but is there a space in a directory name somewhere?

This is a classic problem when moving programs from Linux/OSX and has been
a problem with Drill in the past. It isn't a technical issue so much as
directory names with spaces seem more common on Windows platforms.

The problem can masquerade in all kinds of subtle ways.





On Tue, May 29, 2018 at 10:00 PM Kunal Khatua  wrote:

> This is very odd. Out of the box, using Drill in embedded mode (i.e.
> zk=local)  works for me.
> I'm testing with Apache Drill 1.13.0 on Windows 10. Nothing fancy in my
> env var PATH.
> Everything points to JDK8.
>
> You're seeing this with a clean setup as well? (for an existing machine,
> you should rename the c:\tmp\drill dir as well, just so that nothing has
> been corrupted)
>
> You can try Shuporno's suggestions, though (in embedded mode), Drill will
> have no other dependencies. If it's worked for him, there might be
> something that I'm missing.
> On 5/29/2018 4:56:10 AM, Shuporno Choudhury <
> shuporno.choudh...@manthan.com> wrote:
> Hi,
>
> Probably this might help:
> 1. Download *winutils.exe* and *hadoop.dll* from
> https://github.com/steveloughran/winutils/tree/master/hadoop-2.7.1/bin
> 2. Put these 2 files in the */bin* folder of Drill
> 3. Set *HADOOP_HOME* (in environment variable) to the the directory which
> contains the Drill */bin *folder.
> Eg: If your folder structure is
> D:/folder1/folder2/apache-drill-some-version/bin, then set *HADOOP_HOME* to
> *D:/folder1/folder2/apache-drill-some-version*, so that HADOOP_HOME/bin
> contains winutils.exe and hadoop.dll
>
> Please give this a try. It should solve your problem.
>
> After following the above mentioned steps, try starting Drill again.
> If this method works, HADOOP_HOME *won't* come out as "HADOOP_HOME not
> detected... ". Instead, you will get HADOOP_HOME as the path you set in the
> environment variable and Drill would start running fine.
>
> On Tue, May 29, 2018 at 4:04 PM, Richardson, David <>
> david.richard...@uk.daiwacm.com> wrote:
>
> > I’ve spent the whole morning going through some things.
> >
> > 1). The windows PATH variable only has the path to the Java JDK in it.
> > 2). I’ve been through the class path output in the log file, and only has
> > references to files under C:\Program Files\Apache
> > Drill\apache-drill-1.13.0\jars
> > 3). I tried the UDF fix described below and this did not fix it (the
> > drill\udf\registry folder is created under my profile).
> >
> > Thinking about it logically (I have tried to run the Drill code base
> using
> > Intellij but got lots of dependency errors), the log throws an exception
> > when loading a jdbc driver (guava class issue), so I used jdeps to try to
> > find the clash in guava versions, and it looks like everything is using
> > guava-18.0
> >
> > Also while digging around I found this on stackoverflow, this person gets
> > the same behaviour (it was asked only 5 days ago):
> >
> > https://stackoverflow.com/questions/50487014/apache-
> > drill-1-12-0-failure-in-starting-embedded-drillbit-and-no-current-conn
> >
> > and another developer that I work with followed the 10 minute tutorial
> and
> > got exactly the same behaviour, so that is 5 people(including
> > stackoverflow).
> >
> > What is interesting is that the guy on stackoverflow is also a Windows
> > user. Are there folk in the Drill community who use Windows desk tops, or
> > are most people using either Mac OS or Ubuntu?
> >
> > I really don’t know how to proceed.
> >
> > Dave.
> >
> > From: Charles Givre [mailto:cgi...@gmail.com]
> > Sent: 24 May 2018 19:21
> > To: Richardson, David
> > Cc: user; Divya Gehlot
> > Subject: Re: Apache Drill in 10 Minutes - Problems
> >
> > I love helpful error messages ;-) Can you check the classpath to see if
> > there any additional classes that are there? I’ve gotten connection
> issues
> > like this when I had a database driver in the CLASSPATH.
> >
> > Also take a look at this response: http://mail-archives.apache.
> > org/mod_mbox/drill-user/201612.mbox/%3CDF1248D3D81CAF44B1FD58565206
> > 18650c6698c...@sacvmsx15.phi.imsglobal.com%3E
> > archives.apache.org/mod_mbox/drill-user/201612.mbox/%
> > 3cdf1248d3d81caf44b1fd5856520618650c6698c...@sacvmsx15.phi.
> > imsglobal.com%3e>
> >
> >
> > — C
> >
> >
> >
> > On May 24, 2018, at 11:47, Richardson, David
> > com> wrote:
> >
> >
> > Thank 

Re: Apache Drill in 10 Minutes - Problems

[Kunal Khatua]

This is very odd. Out of the box, using Drill in embedded mode (i.e. zk=local)  
works for me.
I'm testing with Apache Drill 1.13.0 on Windows 10. Nothing fancy in my env var 
PATH.
Everything points to JDK8.

You're seeing this with a clean setup as well? (for an existing machine, you 
should rename the c:\tmp\drill dir as well, just so that nothing has been 
corrupted)

You can try Shuporno's suggestions, though (in embedded mode), Drill will have 
no other dependencies. If it's worked for him, there might be something that 
I'm missing. 
On 5/29/2018 4:56:10 AM, Shuporno Choudhury  
wrote:
Hi,

Probably this might help:
1. Download *winutils.exe* and *hadoop.dll* from
https://github.com/steveloughran/winutils/tree/master/hadoop-2.7.1/bin
2. Put these 2 files in the */bin* folder of Drill
3. Set *HADOOP_HOME* (in environment variable) to the the directory which
contains the Drill */bin *folder.
Eg: If your folder structure is
D:/folder1/folder2/apache-drill-some-version/bin, then set *HADOOP_HOME* to
*D:/folder1/folder2/apache-drill-some-version*, so that HADOOP_HOME/bin
contains winutils.exe and hadoop.dll

Please give this a try. It should solve your problem.

After following the above mentioned steps, try starting Drill again.
If this method works, HADOOP_HOME *won't* come out as "HADOOP_HOME not
detected... ". Instead, you will get HADOOP_HOME as the path you set in the
environment variable and Drill would start running fine.

On Tue, May 29, 2018 at 4:04 PM, Richardson, David <>
david.richard...@uk.daiwacm.com> wrote:

> I’ve spent the whole morning going through some things.
>
> 1). The windows PATH variable only has the path to the Java JDK in it.
> 2). I’ve been through the class path output in the log file, and only has
> references to files under C:\Program Files\Apache
> Drill\apache-drill-1.13.0\jars
> 3). I tried the UDF fix described below and this did not fix it (the
> drill\udf\registry folder is created under my profile).
>
> Thinking about it logically (I have tried to run the Drill code base using
> Intellij but got lots of dependency errors), the log throws an exception
> when loading a jdbc driver (guava class issue), so I used jdeps to try to
> find the clash in guava versions, and it looks like everything is using
> guava-18.0
>
> Also while digging around I found this on stackoverflow, this person gets
> the same behaviour (it was asked only 5 days ago):
>
> https://stackoverflow.com/questions/50487014/apache-
> drill-1-12-0-failure-in-starting-embedded-drillbit-and-no-current-conn
>
> and another developer that I work with followed the 10 minute tutorial and
> got exactly the same behaviour, so that is 5 people(including
> stackoverflow).
>
> What is interesting is that the guy on stackoverflow is also a Windows
> user. Are there folk in the Drill community who use Windows desk tops, or
> are most people using either Mac OS or Ubuntu?
>
> I really don’t know how to proceed.
>
> Dave.
>
> From: Charles Givre [mailto:cgi...@gmail.com]
> Sent: 24 May 2018 19:21
> To: Richardson, David
> Cc: user; Divya Gehlot
> Subject: Re: Apache Drill in 10 Minutes - Problems
>
> I love helpful error messages ;-) Can you check the classpath to see if
> there any additional classes that are there? I’ve gotten connection issues
> like this when I had a database driver in the CLASSPATH.
>
> Also take a look at this response: http://mail-archives.apache.
> org/mod_mbox/drill-user/201612.mbox/%3CDF1248D3D81CAF44B1FD58565206
> 18650c6698c...@sacvmsx15.phi.imsglobal.com%3E
> archives.apache.org/mod_mbox/drill-user/201612.mbox/%
> 3cdf1248d3d81caf44b1fd5856520618650c6698c...@sacvmsx15.phi.
> imsglobal.com%3e>
>
>
> — C
>
>
>
> On May 24, 2018, at 11:47, Richardson, David
> com> wrote:
>
>
> Thank you. This gives us a wonderful exception:
>
> java.lang.NullPointerException
> at org.apache.drill.exec.coord.local.LocalClusterCoordinator.
> update(LocalClusterCoordinator.java:98)
> at org.apache.drill.exec.server.Drillbit.close(Drillbit.java:228)
> at org.apache.drill.jdbc.impl.DrillConnectionImpl.cleanup(
> DrillConnectionImpl.java:827)
> at org.apache.drill.jdbc.impl.DrillConnectionImpl.(
> DrillConnectionImpl.java:186)
> at org.apache.drill.jdbc.impl.DrillJdbc41Factory.
> newDrillConnection(DrillJdbc41Factory.java:73)
> at org.apache.drill.jdbc.impl.DrillFactory.newConnection(
> DrillFactory.java:69)
> at org.apache.calcite.avatica.UnregisteredDriver.connect(
> UnregisteredDriver.java:138)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:168)
> at sqlline.DatabaseConnection.getConnection(
> DatabaseConnection.java:214)
> at sqll

Re: Apache Drill in 10 Minutes - Problems

[Shuporno Choudhury]

Hi,

Probably this might help:
1. Download *winutils.exe* and *hadoop.dll* from
https://github.com/steveloughran/winutils/tree/master/hadoop-2.7.1/bin
2. Put these 2 files in the */bin* folder of Drill
3. Set *HADOOP_HOME* (in environment variable) to the the directory which
contains the Drill */bin *folder.
Eg: If your folder structure is
D:/folder1/folder2/apache-drill-some-version/bin, then set *HADOOP_HOME* to
*D:/folder1/folder2/apache-drill-some-version*, so that HADOOP_HOME/bin
contains winutils.exe and hadoop.dll

Please give this a try. It should solve your problem.

After following the above mentioned steps, try starting Drill again.
If this method works, HADOOP_HOME *won't* come out as "HADOOP_HOME not
detected... ". Instead, you will get HADOOP_HOME as the path you set in the
environment variable and Drill would start running fine.

On Tue, May 29, 2018 at 4:04 PM, Richardson, David <
david.richard...@uk.daiwacm.com> wrote:

> I’ve spent the whole morning going through some things.
>
> 1).  The windows PATH variable only has the path to the Java JDK in it.
> 2).  I’ve been through the class path output in the log file, and only has
> references to files under C:\Program Files\Apache
> Drill\apache-drill-1.13.0\jars
> 3).  I tried the UDF fix described below and this did not fix it (the
> drill\udf\registry folder is created under my profile).
>
> Thinking about it logically (I have tried to run the Drill code base using
> Intellij but got lots of dependency errors), the log throws an exception
> when loading a jdbc driver (guava class issue), so I used jdeps to try to
> find the clash in guava versions, and it looks like everything is using
> guava-18.0
>
> Also while digging around I found this on stackoverflow, this person gets
> the same behaviour (it was asked only 5 days ago):
>
> https://stackoverflow.com/questions/50487014/apache-
> drill-1-12-0-failure-in-starting-embedded-drillbit-and-no-current-conn
>
> and another developer that I work with followed the 10 minute tutorial and
> got exactly the same behaviour, so that is 5 people(including
> stackoverflow).
>
> What is interesting is that the guy on stackoverflow is also a Windows
> user.   Are there folk in the Drill community who use Windows desk tops, or
> are most people using either Mac OS or Ubuntu?
>
> I really don’t know how to proceed.
>
> Dave.
>
> From: Charles Givre [mailto:cgi...@gmail.com]
> Sent: 24 May 2018 19:21
> To: Richardson, David
> Cc: user; Divya Gehlot
> Subject: Re: Apache Drill in 10 Minutes - Problems
>
> I love helpful error messages ;-)  Can you check the classpath to see if
> there any additional classes that are there?  I’ve gotten connection issues
> like this when I had a database driver in the CLASSPATH.
>
> Also take a look at this response:  http://mail-archives.apache.
> org/mod_mbox/drill-user/201612.mbox/%3CDF1248D3D81CAF44B1FD58565206
> 18650c6698c...@sacvmsx15.phi.imsglobal.com%3E<http://mail-
> archives.apache.org/mod_mbox/drill-user/201612.mbox/%
> 3cdf1248d3d81caf44b1fd5856520618650c6698c...@sacvmsx15.phi.
> imsglobal.com%3e>
>
>
> — C
>
>
>
> On May 24, 2018, at 11:47, Richardson, David  com<mailto:david.richard...@uk.daiwacm.com>> wrote:
>
>
> Thank you.  This gives us a wonderful exception:
>
> java.lang.NullPointerException
> at org.apache.drill.exec.coord.local.LocalClusterCoordinator.
> update(LocalClusterCoordinator.java:98)
> at org.apache.drill.exec.server.Drillbit.close(Drillbit.java:228)
> at org.apache.drill.jdbc.impl.DrillConnectionImpl.cleanup(
> DrillConnectionImpl.java:827)
> at org.apache.drill.jdbc.impl.DrillConnectionImpl.(
> DrillConnectionImpl.java:186)
> at org.apache.drill.jdbc.impl.DrillJdbc41Factory.
> newDrillConnection(DrillJdbc41Factory.java:73)
> at org.apache.drill.jdbc.impl.DrillFactory.newConnection(
> DrillFactory.java:69)
> at org.apache.calcite.avatica.UnregisteredDriver.connect(
> UnregisteredDriver.java:138)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:168)
> at sqlline.DatabaseConnection.getConnection(
> DatabaseConnection.java:214)
> at sqlline.DatabaseConnection.reconnect(DatabaseConnection.
> java:221)
> at sqlline.Commands.reconnect(Commands.java:434)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
>   

RE: Apache Drill in 10 Minutes - Problems

[Richardson, David]

I’ve spent the whole morning going through some things.

1).  The windows PATH variable only has the path to the Java JDK in it.
2).  I’ve been through the class path output in the log file, and only has 
references to files under C:\Program Files\Apache Drill\apache-drill-1.13.0\jars
3).  I tried the UDF fix described below and this did not fix it (the 
drill\udf\registry folder is created under my profile).

Thinking about it logically (I have tried to run the Drill code base using 
Intellij but got lots of dependency errors), the log throws an exception when 
loading a jdbc driver (guava class issue), so I used jdeps to try to find the 
clash in guava versions, and it looks like everything is using guava-18.0

Also while digging around I found this on stackoverflow, this person gets the 
same behaviour (it was asked only 5 days ago):

https://stackoverflow.com/questions/50487014/apache-drill-1-12-0-failure-in-starting-embedded-drillbit-and-no-current-conn

and another developer that I work with followed the 10 minute tutorial and got 
exactly the same behaviour, so that is 5 people(including stackoverflow).

What is interesting is that the guy on stackoverflow is also a Windows user.   
Are there folk in the Drill community who use Windows desk tops, or are most 
people using either Mac OS or Ubuntu?

I really don’t know how to proceed.

Dave.

From: Charles Givre [mailto:cgi...@gmail.com]
Sent: 24 May 2018 19:21
To: Richardson, David
Cc: user; Divya Gehlot
Subject: Re: Apache Drill in 10 Minutes - Problems

I love helpful error messages ;-)  Can you check the classpath to see if there 
any additional classes that are there?  I’ve gotten connection issues like this 
when I had a database driver in the CLASSPATH.

Also take a look at this response:  
http://mail-archives.apache.org/mod_mbox/drill-user/201612.mbox/%3cdf1248d3d81caf44b1fd5856520618650c6698c...@sacvmsx15.phi.imsglobal.com%3E<http://mail-archives.apache.org/mod_mbox/drill-user/201612.mbox/%3cdf1248d3d81caf44b1fd5856520618650c6698c...@sacvmsx15.phi.imsglobal.com%3e>


— C



On May 24, 2018, at 11:47, Richardson, David 
mailto:david.richard...@uk.daiwacm.com>> wrote:


Thank you.  This gives us a wonderful exception:

java.lang.NullPointerException
at 
org.apache.drill.exec.coord.local.LocalClusterCoordinator.update(LocalClusterCoordinator.java:98)
at org.apache.drill.exec.server.Drillbit.close(Drillbit.java:228)
at 
org.apache.drill.jdbc.impl.DrillConnectionImpl.cleanup(DrillConnectionImpl.java:827)
at 
org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:186)
at 
org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:73)
at 
org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
at 
org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138)
at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
at sqlline.DatabaseConnection.connect(DatabaseConnection.java:168)
at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:214)
at sqlline.DatabaseConnection.reconnect(DatabaseConnection.java:221)
at sqlline.Commands.reconnect(Commands.java:434)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at 
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
at sqlline.SqlLine.dispatch(SqlLine.java:742)
at sqlline.SqlLine.begin(SqlLine.java:621)
at sqlline.SqlLine.start(SqlLine.java:375)
at sqlline.SqlLine.main(SqlLine.java:268)


Which is interesting, in that in the sqlline.log file, when the service starts 
we get :

javassist.CannotCompileException: by java.lang.LinkageError: loader (instance 
of  sun/misc/Launcher$AppClassLoader): attempted  duplicate class definition 
for name: "com/google/common/base/Stopwatch"
 at javassist.ClassPool.toClass(ClassPool.java:1099) 
~[javassist-3.16.1-GA.jar:na]
 at javassist.ClassPool.toClass(ClassPool.java:1042) 
~[javassist-3.16.1-GA.jar:na]
 at javassist.ClassPool.toClass(ClassPool.java:1000) 
~[javassist-3.16.1-GA.jar:na]
 at javassist.CtClass.toClass(CtClass.java:1140) 
~[javassist-3.16.1-GA.jar:na]
 at 
org.apache.drill.exec.util.GuavaPatcher.patchStopwatch(GuavaPatcher.java:66) 
~[drill-java-exec-1.13.0.jar:1.13.0]
 at org.apache.drill.exec.util.GuavaPatcher.patch(GuavaPatcher.java:36) 
~[drill-java-exec-1.13.0.jar:1.13.0]
 at org.apache.drill.exec.server.Drillbit.(Drillbit.java:69) 
[drill-java-exec-1.13.0.jar:1.13.0]
 at 
org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:134)
 [drill-

Re: Apache Drill in 10 Minutes - Problems

[Charles Givre]

ct.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>  ~[na:1.8.0_171]
>  at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_171]
>  at 
> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36) 
> [sqlline-1.1.9-drill-r7.jar:na]
>  at sqlline.SqlLine.dispatch(SqlLine.java:742) 
> [sqlline-1.1.9-drill-r7.jar:na]
>  at sqlline.SqlLine.initArgs(SqlLine.java:528) 
> [sqlline-1.1.9-drill-r7.jar:na]
>  at sqlline.SqlLine.begin(SqlLine.java:596) 
> [sqlline-1.1.9-drill-r7.jar:na]
>  at sqlline.SqlLine.start(SqlLine.java:375) 
> [sqlline-1.1.9-drill-r7.jar:na]
>  at sqlline.SqlLine.main(SqlLine.java:268) [sqlline-1.1.9-drill-r7.jar:na]
> Caused by: java.lang.LinkageError: loader (instance of  
> sun/misc/Launcher$AppClassLoader): attempted  duplicate class definition for 
> name: "com/google/common/base/Stopwatch"
>  at java.lang.ClassLoader.defineClass1(Native Method) ~[na:1.8.0_171]
>  at java.lang.ClassLoader.defineClass(ClassLoader.java:763) 
> ~[na:1.8.0_171]
>  at java.lang.ClassLoader.defineClass(ClassLoader.java:642) 
> ~[na:1.8.0_171]
>  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
> ~[na:1.8.0_171]
>  at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
> ~[na:1.8.0_171]
>  at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>  ~[na:1.8.0_171]
>  at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_171]
>  at javassist.ClassPool.toClass2(ClassPool.java:1112) 
> ~[javassist-3.16.1-GA.jar:na]
>  at javassist.ClassPool.toClass(ClassPool.java:1093) 
> ~[javassist-3.16.1-GA.jar:na]
>  
> and the following line is common to both :
>  
> at 
> org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138)
>  
> What do you think?
>  
> Dave.
>  
>  
>  
> From: Charles Givre [mailto:cgi...@gmail.com] 
> Sent: 24 May 2018 16:31
> To: user
> Cc: Divya Gehlot; Richardson, David
> Subject: Re: Apache Drill in 10 Minutes - Problems
>  
> Hi Dave, 
> Can you do the following:
> 1.  Start Drill and execute the following query:
> !set verbose true
>  
> 2. Then: 
> !reconnect
>  
> And send the complete output?
>  
>  
> 
> 
> On May 24, 2018, at 11:05, Richardson, David <david.richard...@uk.daiwacm.com 
> <mailto:david.richard...@uk.daiwacm.com>> wrote:
>  
> Hi Divya.
> 
> I’ve tried both 1.10 and 1.11, they exhibit the same behaviour.
> 
> To try to get to the root cause of the issue I removed everything from my 
> PATH variable except for the path to the Java 8 JDK.
> 
> Another colleague of mine (that is 3 of us now) has also tried the 10 minute 
> tutorial and is getting the same behaviour.
> 
> Charles commented that it could be a problem with a storage plugin.  I’ve 
> noticed that config for the default plugins gets written to 
> C:\tmp\drill\sys.storage_plugins, but from the documentation I cannot figure 
> out how to turn the default plugins off.
> 
> Any thoughts?
> 
> Dave.
> 
> From: Divya Gehlot [mailto:divya.htco...@gmail.com 
> <mailto:divya.htco...@gmail.com>]
> Sent: 24 May 2018 11:04
> To: user@drill.apache.org <mailto:user@drill.apache.org>; Richardson, David
> Subject: Re: Apache Drill in 10 Minutes - Problems
> 
> CAUTION EXTERNAL EMAIL
> DO NOT open attachments or click on links from unknown senders or within 
> unexpected emails.
> 
> hi David ,
> Can you try with Drill 1.10 or Drill 1.11 version?
> Both works fine and I have tested it .
> 
> 
> Thanks,
> Divya
> 
> On 23 May 2018 at 16:11, Richardson, David <david.richard...@uk.daiwacm.com 
> <mailto:david.richard...@uk.daiwacm.com><mailto:david.richard...@uk.daiwacm.com
>  <mailto:david.richard...@uk.daiwacm.com>>> wrote:
> Hi folk.
> 
> My self and a colleague have both (independently) been trying the Apache 
> Drill in 10 Minutes tutorial, and have both failed to get Apache Drill to 
> work.
> 
> We both experience the same symptoms.  These are:
> 
> 
> 1.   when running a test query the “No current connection” message is 
> returned
> 
> 2.   unable to connect to the Web Console (using any one of : localhost; 
> fully qualified machine name; ip address)
> 
> 3.   when issuing the !quit command an exception is thrown
> 
> We are using Windows 7 work stations with JDK/JRE 1.8.0_171
> 
> Our JAVA_HOME points to the correct version of the JDK, and the path to the 
> Java\jdk1.8.0_171\bin is in the PATH environment variable.  To make sure th

RE: Apache Drill in 10 Minutes - Problems

[Richardson, David]

:642) ~[na:1.8.0_171]
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
~[na:1.8.0_171]
 at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
~[na:1.8.0_171]
 at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 ~[na:1.8.0_171]
 at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_171]
 at javassist.ClassPool.toClass2(ClassPool.java:1112) 
~[javassist-3.16.1-GA.jar:na]
 at javassist.ClassPool.toClass(ClassPool.java:1093) 
~[javassist-3.16.1-GA.jar:na]

and the following line is common to both :

at 
org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138)

What do you think?

Dave.



From: Charles Givre [mailto:cgi...@gmail.com]
Sent: 24 May 2018 16:31
To: user
Cc: Divya Gehlot; Richardson, David
Subject: Re: Apache Drill in 10 Minutes - Problems

Hi Dave,
Can you do the following:
1.  Start Drill and execute the following query:
!set verbose true

2. Then:
!reconnect

And send the complete output?




On May 24, 2018, at 11:05, Richardson, David 
<david.richard...@uk.daiwacm.com<mailto:david.richard...@uk.daiwacm.com>> wrote:

Hi Divya.

I’ve tried both 1.10 and 1.11, they exhibit the same behaviour.

To try to get to the root cause of the issue I removed everything from my PATH 
variable except for the path to the Java 8 JDK.

Another colleague of mine (that is 3 of us now) has also tried the 10 minute 
tutorial and is getting the same behaviour.

Charles commented that it could be a problem with a storage plugin.  I’ve 
noticed that config for the default plugins gets written to 
C:\tmp\drill\sys.storage_plugins, but from the documentation I cannot figure 
out how to turn the default plugins off.

Any thoughts?

Dave.

From: Divya Gehlot [mailto:divya.htco...@gmail.com]
Sent: 24 May 2018 11:04
To: user@drill.apache.org<mailto:user@drill.apache.org>; Richardson, David
Subject: Re: Apache Drill in 10 Minutes - Problems

CAUTION EXTERNAL EMAIL
DO NOT open attachments or click on links from unknown senders or within 
unexpected emails.

hi David ,
Can you try with Drill 1.10 or Drill 1.11 version?
Both works fine and I have tested it .


Thanks,
Divya

On 23 May 2018 at 16:11, Richardson, David 
<david.richard...@uk.daiwacm.com<mailto:david.richard...@uk.daiwacm.com><mailto:david.richard...@uk.daiwacm.com>>
 wrote:
Hi folk.

My self and a colleague have both (independently) been trying the Apache Drill 
in 10 Minutes tutorial, and have both failed to get Apache Drill to work.

We both experience the same symptoms.  These are:


1.   when running a test query the “No current connection” message is 
returned

2.   unable to connect to the Web Console (using any one of : localhost; 
fully qualified machine name; ip address)

3.   when issuing the !quit command an exception is thrown

We are using Windows 7 work stations with JDK/JRE 1.8.0_171

Our JAVA_HOME points to the correct version of the JDK, and the path to the 
Java\jdk1.8.0_171\bin is in the PATH environment variable.  To make sure that 
Windows picked up the environment variable changes we rebooted.

I’ve attached the sqlline.log (sensitive data masked by ), and the 
console output is below.

Your help would be much appreciated.

Many thanks.

Dave.

Command line output

C:\Program Files\Apache Drill\apache-drill-1.13.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...
java.lang.NullPointerException
apache drill 1.13.0
"a little sql for your nosql"
0: jdbc:drill:zk=local> select version from sys.version;
No current connection
0: jdbc:drill:zk=local> !quit
java.lang.NullPointerException
   at 
org.apache.drill.exec.coord.local.LocalClusterCoordinator.update(LocalClusterCoordinator.java:98)
   at org.apache.drill.exec.server.Drillbit.close(Drillbit.java:228)
   at 
org.apache.drill.jdbc.impl.DrillConnectionImpl.cleanup(DrillConnectionImpl.java:827)
   at 
org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:186)
   at 
org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:73)
   at 
org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
   at 
org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138)
   at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
   at sqlline.DatabaseConnection.connect(DatabaseConnection.java:168)
   at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:214)
   at sqlline.Commands.close(Commands.java:925)
   at sqlline.Commands.quit(Commands.java:889)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

Re: Apache Drill in 10 Minutes - Problems

[Charles Givre]

Hi Dave, 
Can you do the following:
1.  Start Drill and execute the following query:
!set verbose true

2. Then: 
!reconnect

And send the complete output?



> On May 24, 2018, at 11:05, Richardson, David 
> <david.richard...@uk.daiwacm.com> wrote:
> 
> Hi Divya.
> 
> I’ve tried both 1.10 and 1.11, they exhibit the same behaviour.
> 
> To try to get to the root cause of the issue I removed everything from my 
> PATH variable except for the path to the Java 8 JDK.
> 
> Another colleague of mine (that is 3 of us now) has also tried the 10 minute 
> tutorial and is getting the same behaviour.
> 
> Charles commented that it could be a problem with a storage plugin.  I’ve 
> noticed that config for the default plugins gets written to 
> C:\tmp\drill\sys.storage_plugins, but from the documentation I cannot figure 
> out how to turn the default plugins off.
> 
> Any thoughts?
> 
> Dave.
> 
> From: Divya Gehlot [mailto:divya.htco...@gmail.com 
> <mailto:divya.htco...@gmail.com>]
> Sent: 24 May 2018 11:04
> To: user@drill.apache.org <mailto:user@drill.apache.org>; Richardson, David
> Subject: Re: Apache Drill in 10 Minutes - Problems
> 
> CAUTION EXTERNAL EMAIL
> DO NOT open attachments or click on links from unknown senders or within 
> unexpected emails.
> 
> hi David ,
> Can you try with Drill 1.10 or Drill 1.11 version?
> Both works fine and I have tested it .
> 
> 
> Thanks,
> Divya
> 
> On 23 May 2018 at 16:11, Richardson, David <david.richard...@uk.daiwacm.com 
> <mailto:david.richard...@uk.daiwacm.com><mailto:david.richard...@uk.daiwacm.com
>  <mailto:david.richard...@uk.daiwacm.com>>> wrote:
> Hi folk.
> 
> My self and a colleague have both (independently) been trying the Apache 
> Drill in 10 Minutes tutorial, and have both failed to get Apache Drill to 
> work.
> 
> We both experience the same symptoms.  These are:
> 
> 
> 1.   when running a test query the “No current connection” message is 
> returned
> 
> 2.   unable to connect to the Web Console (using any one of : localhost; 
> fully qualified machine name; ip address)
> 
> 3.   when issuing the !quit command an exception is thrown
> 
> We are using Windows 7 work stations with JDK/JRE 1.8.0_171
> 
> Our JAVA_HOME points to the correct version of the JDK, and the path to the 
> Java\jdk1.8.0_171\bin is in the PATH environment variable.  To make sure that 
> Windows picked up the environment variable changes we rebooted.
> 
> I’ve attached the sqlline.log (sensitive data masked by ), and the 
> console output is below.
> 
> Your help would be much appreciated.
> 
> Many thanks.
> 
> Dave.
> 
> Command line output
> 
> C:\Program Files\Apache Drill\apache-drill-1.13.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...
> java.lang.NullPointerException
> apache drill 1.13.0
> "a little sql for your nosql"
> 0: jdbc:drill:zk=local> select version from sys.version;
> No current connection
> 0: jdbc:drill:zk=local> !quit
> java.lang.NullPointerException
>at 
> org.apache.drill.exec.coord.local.LocalClusterCoordinator.update(LocalClusterCoordinator.java:98)
>at org.apache.drill.exec.server.Drillbit.close(Drillbit.java:228)
>at 
> org.apache.drill.jdbc.impl.DrillConnectionImpl.cleanup(DrillConnectionImpl.java:827)
>at 
> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:186)
>at 
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:73)
>at 
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
>at 
> org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138)
>at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
>at sqlline.DatabaseConnection.connect(DatabaseConnection.java:168)
>at 
> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:214)
>at sqlline.Commands.close(Commands.java:925)
>at sqlline.Commands.quit(Commands.java:889)
>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>at java.lang.reflect.Method.invoke(Method.java:498)
>at 
> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:3

RE: Apache Drill in 10 Minutes - Problems

[Richardson, David]

Hi Divya.

I’ve tried both 1.10 and 1.11, they exhibit the same behaviour.

To try to get to the root cause of the issue I removed everything from my PATH 
variable except for the path to the Java 8 JDK.

Another colleague of mine (that is 3 of us now) has also tried the 10 minute 
tutorial and is getting the same behaviour.

Charles commented that it could be a problem with a storage plugin.  I’ve 
noticed that config for the default plugins gets written to 
C:\tmp\drill\sys.storage_plugins, but from the documentation I cannot figure 
out how to turn the default plugins off.

Any thoughts?

Dave.

From: Divya Gehlot [mailto:divya.htco...@gmail.com]
Sent: 24 May 2018 11:04
To: user@drill.apache.org; Richardson, David
Subject: Re: Apache Drill in 10 Minutes - Problems

CAUTION EXTERNAL EMAIL
DO NOT open attachments or click on links from unknown senders or within 
unexpected emails.

hi David ,
Can you try with Drill 1.10 or Drill 1.11 version?
Both works fine and I have tested it .


Thanks,
Divya

On 23 May 2018 at 16:11, Richardson, David 
<david.richard...@uk.daiwacm.com<mailto:david.richard...@uk.daiwacm.com>> wrote:
Hi folk.

My self and a colleague have both (independently) been trying the Apache Drill 
in 10 Minutes tutorial, and have both failed to get Apache Drill to work.

We both experience the same symptoms.  These are:


1.   when running a test query the “No current connection” message is 
returned

2.   unable to connect to the Web Console (using any one of : localhost; 
fully qualified machine name; ip address)

3.   when issuing the !quit command an exception is thrown

We are using Windows 7 work stations with JDK/JRE 1.8.0_171

Our JAVA_HOME points to the correct version of the JDK, and the path to the 
Java\jdk1.8.0_171\bin is in the PATH environment variable.  To make sure that 
Windows picked up the environment variable changes we rebooted.

I’ve attached the sqlline.log (sensitive data masked by ), and the 
console output is below.

Your help would be much appreciated.

Many thanks.

Dave.

Command line output

C:\Program Files\Apache Drill\apache-drill-1.13.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...
java.lang.NullPointerException
apache drill 1.13.0
"a little sql for your nosql"
0: jdbc:drill:zk=local> select version from sys.version;
No current connection
0: jdbc:drill:zk=local> !quit
java.lang.NullPointerException
at 
org.apache.drill.exec.coord.local.LocalClusterCoordinator.update(LocalClusterCoordinator.java:98)
at org.apache.drill.exec.server.Drillbit.close(Drillbit.java:228)
at 
org.apache.drill.jdbc.impl.DrillConnectionImpl.cleanup(DrillConnectionImpl.java:827)
at 
org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:186)
at 
org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:73)
at 
org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
at 
org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138)
at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
at sqlline.DatabaseConnection.connect(DatabaseConnection.java:168)
at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:214)
at sqlline.Commands.close(Commands.java:925)
at sqlline.Commands.quit(Commands.java:889)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at 
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
at sqlline.SqlLine.dispatch(SqlLine.java:742)
at sqlline.SqlLine.begin(SqlLine.java:621)
at sqlline.SqlLine.start(SqlLine.java:375)
at sqlline.SqlLine.main(SqlLine.java:268)
java.lang.NullPointerException
at 
org.apache.drill.exec.coord.local.LocalClusterCoordinator.update(LocalClusterCoordinator.java:98)
at org.apache.drill.exec.server.Drillbit.close(Drillbit.java:228)
at 
org.apache.drill.jdbc.impl.DrillConnectionImpl.cleanup(DrillConnectionImpl.java:827)
at 
org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:186)
at 
org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:73)
at 
org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
at 
org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138)
at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
at sqlline.Dat

Re: Apache Drill in 10 Minutes - Problems

[Divya Gehlot]

hi David ,
Can you try with Drill 1.10 or Drill 1.11 version?
Both works fine and I have tested it .


Thanks,
Divya

On 23 May 2018 at 16:11, Richardson, David 
wrote:

> Hi folk.
>
>
>
> My self and a colleague have both (independently) been trying the Apache
> Drill in 10 Minutes tutorial, and have both failed to get Apache Drill to
> work.
>
>
>
> We both experience the same symptoms.  These are:
>
>
>
> 1.   when running a test query the “No current connection” message is
> returned
>
> 2.   unable to connect to the Web Console (using any one of :
> localhost; fully qualified machine name; ip address)
>
> 3.   when issuing the !quit command an exception is thrown
>
>
>
> We are using Windows 7 work stations with JDK/JRE 1.8.0_171
>
>
>
> Our JAVA_HOME points to the correct version of the JDK, and the path to
> the *Java\jdk1.8.0_171\bin* is in the PATH environment variable.  To make
> sure that Windows picked up the environment variable changes we rebooted.
>
>
>
> I’ve attached the sqlline.log (sensitive data masked by ), and the
> console output is below.
>
>
>
> Your help would be much appreciated.
>
>
>
> Many thanks.
>
>
> Dave.
>
>
>
> *Command line output*
>
>
>
> C:\Program Files\Apache Drill\apache-drill-1.13.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...
>
> java.lang.NullPointerException
>
> apache drill 1.13.0
>
> "a little sql for your nosql"
>
> 0: jdbc:drill:zk=local> select version from sys.version;
>
> No current connection
>
> 0: jdbc:drill:zk=local> !quit
>
> java.lang.NullPointerException
>
> at org.apache.drill.exec.coord.local.LocalClusterCoordinator.
> update(LocalClusterCoordinator.java:98)
>
> at org.apache.drill.exec.server.Drillbit.close(Drillbit.java:228)
>
> at org.apache.drill.jdbc.impl.DrillConnectionImpl.cleanup(
> DrillConnectionImpl.java:827)
>
> at org.apache.drill.jdbc.impl.DrillConnectionImpl.(
> DrillConnectionImpl.java:186)
>
> at org.apache.drill.jdbc.impl.DrillJdbc41Factory.
> newDrillConnection(DrillJdbc41Factory.java:73)
>
> at org.apache.drill.jdbc.impl.DrillFactory.newConnection(
> DrillFactory.java:69)
>
> at org.apache.calcite.avatica.UnregisteredDriver.connect(
> UnregisteredDriver.java:138)
>
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
>
> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:168)
>
> at sqlline.DatabaseConnection.getConnection(
> DatabaseConnection.java:214)
>
> at sqlline.Commands.close(Commands.java:925)
>
> at sqlline.Commands.quit(Commands.java:889)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:62)
>
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
>
> at java.lang.reflect.Method.invoke(Method.java:498)
>
> at sqlline.ReflectiveCommandHandler.execute(
> ReflectiveCommandHandler.java:36)
>
> at sqlline.SqlLine.dispatch(SqlLine.java:742)
>
> at sqlline.SqlLine.begin(SqlLine.java:621)
>
> at sqlline.SqlLine.start(SqlLine.java:375)
>
> at sqlline.SqlLine.main(SqlLine.java:268)
>
> java.lang.NullPointerException
>
> at org.apache.drill.exec.coord.local.LocalClusterCoordinator.
> update(LocalClusterCoordinator.java:98)
>
> at org.apache.drill.exec.server.Drillbit.close(Drillbit.java:228)
>
> at org.apache.drill.jdbc.impl.DrillConnectionImpl.cleanup(
> DrillConnectionImpl.java:827)
>
> at org.apache.drill.jdbc.impl.DrillConnectionImpl.(
> DrillConnectionImpl.java:186)
>
> at org.apache.drill.jdbc.impl.DrillJdbc41Factory.
> newDrillConnection(DrillJdbc41Factory.java:73)
>
> at org.apache.drill.jdbc.impl.DrillFactory.newConnection(
> DrillFactory.java:69)
>
> at org.apache.calcite.avatica.UnregisteredDriver.connect(
> UnregisteredDriver.java:138)
>
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
>
> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:168)
>
> at sqlline.DatabaseConnection.getConnection(
> DatabaseConnection.java:214)
>
> at sqlline.Commands.close(Commands.java:925)
>
> at sqlline.Commands.closeall(Commands.java:899)
>
> at sqlline.SqlLine.begin(SqlLine.java:649)
>
> at sqlline.SqlLine.start(SqlLine.java:375)
>
> at sqlline.SqlLine.main(SqlLine.java:268)
>
>
>
> 
> Daiwa Capital Markets Europe Limited is registered in England (registered
> number 01487359). The registered office is at 5 King William Street,
> London EC4N
> 
> 7AX. 

RE: Apache Drill in 10 Minutes - Problems

[Richardson, David]

Hi Charles.

Many thanks for your reply.

The Drill service starts and only exits when I issue an !Quit command.

How can I check the storage plugins?

Dave.


-Original Message-
From: Charles Givre [mailto:cgi...@gmail.com] 
Sent: 23 May 2018 15:35
To: user
Subject: Re: Apache Drill in 10 Minutes - Problems

CAUTION EXTERNAL EMAIL
DO NOT open attachments or click on links from unknown senders or within 
unexpected emails.


HI David,
Were you ever able to get Drill to run?  It looks as if Drill is trying to 
connect to storage plugins that are not properly configured.
— C


> On May 23, 2018, at 04:11, Richardson, David 
> <david.richard...@uk.daiwacm.com> wrote:
>
> Hi folk.
>
> My self and a colleague have both (independently) been trying the Apache 
> Drill in 10 Minutes tutorial, and have both failed to get Apache Drill to 
> work.
>
> We both experience the same symptoms.  These are:
>
> 1.   when running a test query the “No current connection” message is 
> returned
> 2.   unable to connect to the Web Console (using any one of : localhost; 
> fully qualified machine name; ip address)
> 3.   when issuing the !quit command an exception is thrown
>
> We are using Windows 7 work stations with JDK/JRE 1.8.0_171
>
> Our JAVA_HOME points to the correct version of the JDK, and the path to the 
> Java\jdk1.8.0_171\bin is in the PATH environment variable.  To make sure that 
> Windows picked up the environment variable changes we rebooted.
>
> I’ve attached the sqlline.log (sensitive data masked by ), and the 
> console output is below.
>
> Your help would be much appreciated.
>
> Many thanks.
>
> Dave.
>
> Command line output
>
> C:\Program Files\Apache Drill\apache-drill-1.13.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...
> java.lang.NullPointerException
> apache drill 1.13.0
> "a little sql for your nosql"
> 0: jdbc:drill:zk=local> select version from sys.version; No current 
> connection
> 0: jdbc:drill:zk=local> !quit
> java.lang.NullPointerException
> at 
> org.apache.drill.exec.coord.local.LocalClusterCoordinator.update(LocalClusterCoordinator.java:98)
> at org.apache.drill.exec.server.Drillbit.close(Drillbit.java:228)
> at 
> org.apache.drill.jdbc.impl.DrillConnectionImpl.cleanup(DrillConnectionImpl.java:827)
> at 
> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:186)
> at 
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:73)
> at 
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> at 
> org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:168)
> at 
> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:214)
> at sqlline.Commands.close(Commands.java:925)
> at sqlline.Commands.quit(Commands.java:889)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at 
> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
> at sqlline.SqlLine.dispatch(SqlLine.java:742)
> at sqlline.SqlLine.begin(SqlLine.java:621)
> at sqlline.SqlLine.start(SqlLine.java:375)
> at sqlline.SqlLine.main(SqlLine.java:268)
> java.lang.NullPointerException
> at 
> org.apache.drill.exec.coord.local.LocalClusterCoordinator.update(LocalClusterCoordinator.java:98)
> at org.apache.drill.exec.server.Drillbit.close(Drillbit.java:228)
> at 
> org.apache.drill.jdbc.impl.DrillConnectionImpl.cleanup(DrillConnectionImpl.java:827)
> at 
> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:186)
> at 
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:73)
> at 
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> at 
> org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at sqlline.DatabaseConnection.connect(Datab

Re: Apache Drill in 10 Minutes - Problems

[Charles Givre]

HI David, 
Were you ever able to get Drill to run?  It looks as if Drill is trying to 
connect to storage plugins that are not properly configured.  
— C


> On May 23, 2018, at 04:11, Richardson, David 
>  wrote:
> 
> Hi folk.
>  
> My self and a colleague have both (independently) been trying the Apache 
> Drill in 10 Minutes tutorial, and have both failed to get Apache Drill to 
> work. 
>  
> We both experience the same symptoms.  These are: 
>  
> 1.   when running a test query the “No current connection” message is 
> returned
> 2.   unable to connect to the Web Console (using any one of : localhost; 
> fully qualified machine name; ip address)
> 3.   when issuing the !quit command an exception is thrown
>  
> We are using Windows 7 work stations with JDK/JRE 1.8.0_171
>  
> Our JAVA_HOME points to the correct version of the JDK, and the path to the 
> Java\jdk1.8.0_171\bin is in the PATH environment variable.  To make sure that 
> Windows picked up the environment variable changes we rebooted.
>  
> I’ve attached the sqlline.log (sensitive data masked by ), and the 
> console output is below.
>  
> Your help would be much appreciated.
>  
> Many thanks.
> 
> Dave.
>  
> Command line output
>  
> C:\Program Files\Apache Drill\apache-drill-1.13.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...
> java.lang.NullPointerException
> apache drill 1.13.0
> "a little sql for your nosql"
> 0: jdbc:drill:zk=local> select version from sys.version;
> No current connection
> 0: jdbc:drill:zk=local> !quit
> java.lang.NullPointerException
> at 
> org.apache.drill.exec.coord.local.LocalClusterCoordinator.update(LocalClusterCoordinator.java:98)
> at org.apache.drill.exec.server.Drillbit.close(Drillbit.java:228)
> at 
> org.apache.drill.jdbc.impl.DrillConnectionImpl.cleanup(DrillConnectionImpl.java:827)
> at 
> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:186)
> at 
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:73)
> at 
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> at 
> org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:168)
> at 
> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:214)
> at sqlline.Commands.close(Commands.java:925)
> at sqlline.Commands.quit(Commands.java:889)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at 
> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
> at sqlline.SqlLine.dispatch(SqlLine.java:742)
> at sqlline.SqlLine.begin(SqlLine.java:621)
> at sqlline.SqlLine.start(SqlLine.java:375)
> at sqlline.SqlLine.main(SqlLine.java:268)
> java.lang.NullPointerException
> at 
> org.apache.drill.exec.coord.local.LocalClusterCoordinator.update(LocalClusterCoordinator.java:98)
> at org.apache.drill.exec.server.Drillbit.close(Drillbit.java:228)
> at 
> org.apache.drill.jdbc.impl.DrillConnectionImpl.cleanup(DrillConnectionImpl.java:827)
> at 
> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:186)
> at 
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:73)
> at 
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
> at 
> org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138)
> at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:168)
> at 
> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:214)
> at sqlline.Commands.close(Commands.java:925)
> at sqlline.Commands.closeall(Commands.java:899)
> at sqlline.SqlLine.begin(SqlLine.java:649)
> at sqlline.SqlLine.start(SqlLine.java:375)
> at sqlline.SqlLine.main(SqlLine.java:268)
>  
> 
> 
> Daiwa Capital Markets Europe Limited is registered in England (registered 
> number 01487359). The registered office is at 5 King William Street, London 
> EC4N 7AX. The company is authorised and regulated by The Financial Conduct 
> Authority and is a member of the London Stock Exchange.
> 
> The