RE: what am I missing?

[Geercken, Uwe]

Hi Ted,

The host and port is the Zookeeper host and port. If you run drill in 
distributed mode, you will have to have zookeeper running. Drill uses zookeeper 
to store configuration data.

Go on and download and install zookeeper. Then run it: "bin/zkServer start". It 
will run on default on port 2181. Next run: "bin/drillbit.sh start". Once you 
drillbit runs, go to your webbrowser and go to "http://localhost:8047/; 8047 is 
the default port for drill.

Once there go to "storage" and configure the plugins, which allow you to define 
hosts, ports and formats. The drill documentation helps you a lot with 
definitions and examples.

Rgds,

Uwe


-Original Message-
From: Ted Schwartz [mailto:tschwa...@loomissayles.com] 
Sent: Montag, 22. Februar 2016 17:41
To: drill-u...@incubator.apache.org
Subject: what am I missing?

I'm new to drill and trying to get up and running. My goal is to access drill 
from a JDBC client. I'm a bit confused when starting drill. If I use 
drill-embedded, it appears it only allows one connection and that connection is 
started along with drill.  So if instead I try to run in distributed mode, I 
have modified drill-override.conf like this:

drill.exec: {
  cluster-id: "drillbits1",
  zk.connect: "myhost:2181"
}

and start drillbit(?)  with this:

drillbit.sh start

I get a "starting drillbit..." message, but cannot connect in any way to it.

If I try to connect using sqlline, it fails with "Connection timed out":

sqlline -u jdbc:drill:zk=myhost:2181

Same problems if I try to connect using the drill-conf utility (which appears 
to be nothing other than an invocation of sqlline)

No matter how I start drill, it doesn't appear any ports are opened for the 
process. For example, `netstat -a | grep 2181` doesn't yield any results, and 
the http port 8047 that works when I start in embedded mode doesn't work in 
distributed mode.

I feel like I am missing something fundamental to all of this, although I'm 
trying to follow the Getting Started documentation.  I've seen references to 
"making sure you start Zookeeper". How do I do that? I find lots of details 
about starting drillbit, but nothing about starting Zookeeper.

Thanks in advance for any clue that can help me move forward.

Re: what am I missing?

[Andries Engelbrecht]

When running in clustered mode you ZK running and point to it appropriately.

It seems you don't have ZK running in your environment.

You can however connect multiple session to Drill in embedded mode.
Simply point directly to the drillbit as apposed to using ZK.

I.e. Start Drill with drill-embedded this will open a sqlline session. From 
anther terminal window you can then run ./sqlline -u 
jdbc:drill:drillbit=localhost if its is on the same machine, or just point to 
the hostname from another machine. If you use ODBC or JDBC the drillbit is on 
port 31010 for client connections by default.

--Andries


> On Feb 22, 2016, at 8:33 AM, Ted Schwartz  wrote:
> 
> I'm new to drill and trying to get up and running. My goal is to access 
> drill from a JDBC client. I'm a bit confused when starting drill. If I use 
> drill-embedded, it appears it only allows one connection and that 
> connection is started along with drill.  So if instead I try to run in 
> distributed mode, I have modified drill-override.conf like this:
> 
> drill.exec: {
>  cluster-id: "drillbits1",
>  zk.connect: "myhost:2181"
> }
> 
> and start drillbit(?)  with this:
> 
> drillbit.sh start
> 
> I get a "starting drillbit..." message, but cannot connect in any way to 
> it.
> 
> If I try to connect using sqlline, it fails with "Connection timed out":
> 
> sqlline -u jdbc:drill:zk=myhost:2181
> 
> Same problems if I try to connect using the drill-conf utility (which 
> appears to be nothing other than an invocation of sqlline)
> 
> No matter how I start drill, it doesn't appear any ports are opened for 
> the process. For example, `netstat -a | grep 2181` doesn't yield any 
> results, and the http port 8047 that works when I start in embedded mode 
> doesn't work in distributed mode.
> 
> I feel like I am missing something fundamental to all of this, although 
> I'm trying to follow the Getting Started documentation.  I've seen 
> references to "making sure you start Zookeeper". How do I do that? I find 
> lots of details about starting drillbit, but nothing about starting 
> Zookeeper.
> 
> Thanks in advance for any clue that can help me move forward.

what am I missing?

[Ted Schwartz]

I'm new to drill and trying to get up and running. My goal is to access 
drill from a JDBC client. I'm a bit confused when starting drill. If I use 
drill-embedded, it appears it only allows one connection and that 
connection is started along with drill.  So if instead I try to run in 
distributed mode, I have modified drill-override.conf like this:

drill.exec: {
  cluster-id: "drillbits1",
  zk.connect: "myhost:2181"
}

and start drillbit(?)  with this:

drillbit.sh start

I get a "starting drillbit..." message, but cannot connect in any way to 
it.

If I try to connect using sqlline, it fails with "Connection timed out":

sqlline -u jdbc:drill:zk=myhost:2181

Same problems if I try to connect using the drill-conf utility (which 
appears to be nothing other than an invocation of sqlline)

No matter how I start drill, it doesn't appear any ports are opened for 
the process. For example, `netstat -a | grep 2181` doesn't yield any 
results, and the http port 8047 that works when I start in embedded mode 
doesn't work in distributed mode.

I feel like I am missing something fundamental to all of this, although 
I'm trying to follow the Getting Started documentation.  I've seen 
references to "making sure you start Zookeeper". How do I do that? I find 
lots of details about starting drillbit, but nothing about starting 
Zookeeper.

Thanks in advance for any clue that can help me move forward.

Re: what am I missing?

[Abdel Hakim Deneche]

To run Drill in distributed mode you need to have Zookeeper up and running.
This shouldn't be too complicated, you can find more details here:

https://zookeeper.apache.org/doc/r3.1.2/zookeeperStarted.html#sc_InstallingSingleMode

On my Mac I used brew and it took care of everything.

On Mon, Feb 22, 2016 at 8:40 AM, Ted Schwartz 
wrote:

> I'm new to drill and trying to get up and running. My goal is to access
> drill from a JDBC client. I'm a bit confused when starting drill. If I use
> drill-embedded, it appears it only allows one connection and that
> connection is started along with drill.  So if instead I try to run in
> distributed mode, I have modified drill-override.conf like this:
>
> drill.exec: {
>   cluster-id: "drillbits1",
>   zk.connect: "myhost:2181"
> }
>
> and start drillbit(?)  with this:
>
> drillbit.sh start
>
> I get a "starting drillbit..." message, but cannot connect in any way to
> it.
>
> If I try to connect using sqlline, it fails with "Connection timed out":
>
> sqlline -u jdbc:drill:zk=myhost:2181
>
> Same problems if I try to connect using the drill-conf utility (which
> appears to be nothing other than an invocation of sqlline)
>
> No matter how I start drill, it doesn't appear any ports are opened for
> the process. For example, `netstat -a | grep 2181` doesn't yield any
> results, and the http port 8047 that works when I start in embedded mode
> doesn't work in distributed mode.
>
> I feel like I am missing something fundamental to all of this, although
> I'm trying to follow the Getting Started documentation.  I've seen
> references to "making sure you start Zookeeper". How do I do that? I find
> lots of details about starting drillbit, but nothing about starting
> Zookeeper.
>
> Thanks in advance for any clue that can help me move forward.




-- 

Abdelhakim Deneche

Software Engineer

  


Now Available - Free Hadoop On-Demand Training

what am I missing?

[Ted Schwartz]

I'm new to drill and trying to get up and running. My goal is to access 
drill from a JDBC client. I'm a bit confused when starting drill. If I use 
drill-embedded, it appears it only allows one connection and that 
connection is started along with drill.  So if instead I try to run in 
distributed mode, I have modified drill-override.conf like this:

drill.exec: {
  cluster-id: "drillbits1",
  zk.connect: "myhost:2181"
}

and start drillbit(?)  with this:

drillbit.sh start

I get a "starting drillbit..." message, but cannot connect in any way to 
it.

If I try to connect using sqlline, it fails with "Connection timed out":

sqlline -u jdbc:drill:zk=myhost:2181

Same problems if I try to connect using the drill-conf utility (which 
appears to be nothing other than an invocation of sqlline)

No matter how I start drill, it doesn't appear any ports are opened for 
the process. For example, `netstat -a | grep 2181` doesn't yield any 
results, and the http port 8047 that works when I start in embedded mode 
doesn't work in distributed mode.

I feel like I am missing something fundamental to all of this, although 
I'm trying to follow the Getting Started documentation.  I've seen 
references to "making sure you start Zookeeper". How do I do that? I find 
lots of details about starting drillbit, but nothing about starting 
Zookeeper.

Thanks in advance for any clue that can help me move forward.

What am I missing in apache-drill-0.7.0 windows installation

[Maisnam Ns]

Hi,

I have downloaded apache-drill-0.7.0.tar.gz , followed the installation
section on windows from the link given below:

https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+in+10+Minutes#ApacheDrillin10Minutes-QuerySampleData

sqlline !connect jdbc:drill:zk=local
scan complete in 12ms
scan complete in 631ms
Enter username for jdbc:drill:zk=local: admin
Enter password for jdbc:drill:zk=local: *
23:31:19.095 [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.


I have pasted only the first few lines in the stack trace , now I queried
for parquet

0: jdbc:drill:zk=local SELECT * FROM
dfs.'C:\drill\apache-drill-0.7.0\sample-da
ta\region.parquet';
No current connection
0: jdbc:drill:zk=local

Error analysis
1. I could not find winutils.exe in the given 0.7.0 version
2. According to the windows install guide I got the required prompt, but
when I queried,
I am getting 'No current connection'

I followed all the instructions in the given section after going to the link

Please let me know what I am I missing.

Regards
Niranjan