Even I used in embedded mode and able to set up successfully  Keeping that
in mind  try to set up in distributed in windows.
I am able to set up Zookeeper and it is running fine .
I started Drill thorugh drillbit.sh start command in git bash
it started successfully.

*Web Console Error :*
but when I try to open web console using http://<one of the ip or host name
of my 3 nodes>:8047
Its giving page cannot be displayed

*SqlLine Errors :*

1.Direct drill command sqlline.bat -u

> Error :
> C:\apache-drill-1.11.0\bin>sqlline.bat -u
> "jdbc:drill:drillbit=NameNode:2181,Da
> taNode1:2181,DataNode2:2181"
> DRILL_ARGS - " -u
> jdbc:drill:drillbit=NameNode:2181,DataNode1:2181,DataNode2:218
> 1"
> HADOOP_HOME not detected...
> HBASE_HOME not detected...
> Calculating Drill classpath...
> Error: Failure in connecting to Drill:
> org.apache.drill.exec.rpc.RpcException: H ANDSHAKE_COMMUNICATION : Channel
> closed /<ip3>:64513 <--> DataNode1/10.20.
> 6.158:2181. (state=,code=0)
> java.sql.SQLException: Failure in connecting to Drill:
> org.apache.drill.exec.rpc
> .RpcException: HANDSHAKE_COMMUNICATION : Channel closed /<ip3>:64513 <-->
> DataNode1/<ip2>2181.
>         at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnection
> Impl.java:167)
>         at
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(Dril
> lJdbc41Factory.java:72)
>         at
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.ja
> va:69)
>         at
> org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDri
> ver.java:143)
>         at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
>         at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
>         at
> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)

2. Sql line command using Zookeeper by specifying the IPs of the machines :

C:\apache-drill-1.11.0\bin>sqlline -u "jdbc:drill:zk=<ip1>:2181,<ip2>:


DRILL_ARGS - " -u jdbc:drill:zk=<ip1>:2181,<ip2>:


Calculating HADOOP_CLASSPATH ...

HBASE_HOME not detected...

Calculating Drill classpath...

ûu (The system cannot find the file specified)

jdbc:drill:zk=<ip1>:2181,<ip2>:2181<ip3>:2181 (The filename,

directory name, or volume label syntax is incorrect)

apache drill 1.11.0

"what ever the mind of man can conceive and believe, drill can query"


3.Strating sqlline by specifying the hostname :

C:\apache-drill-1.11.0\bin>sqlline.bat -u


DRILL_ARGS - " -u jdbc:drill:zk=NameNode,DataNode1,DataNode2"

HADOOP_HOME not detected...

HBASE_HOME not detected...

Calculating Drill classpath...

ûu (The system cannot find the file specified)

jdbc:drill:zk=NameNode,DataNode1,DataNode2 (The filename, directory name,
or vol

ume label syntax is incorrect)

apache drill 1.11.0

"got drill?"


Note : Removed the actual IP for security purpose.

Appreciate the help .



On 11 August 2017 at 08:20, Kunal Khatua <kkha...@mapr.com> wrote:

> Most people have used Apache Drill on Windows primarily in Embedded mode
> because no one appears to have tried for more than 1 Drillbit.
> That said, you should be able to run Apache Drill in a distributed mode as
> well, since it is Java-based and would not need to rely on anything more
> than a Zookeeper.
> -----Original Message-----
> From: Divya Gehlot [mailto:divya.htco...@gmail.com]
> Sent: Thursday, August 10, 2017 1:45 AM
> To: user@drill.apache.org
> Subject: set up Apache Drill on Windows server in distributed mode
> Hi,
> Has anybody set up Apache Drill cluster in Windows machines/servers?
> Thanks,
> Divya

Reply via email to