Hi,

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
"jdbc:drill:zk=NameNode:2181,DataNode1:2181,DataNode2:2181"

> 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>:

:2181<ip3>::2181"

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

:2181<ip3>::2181"

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"

sqlline>


3.Strating sqlline by specifying the hostname :

C:\apache-drill-1.11.0\bin>sqlline.bat -u
"jdbc:drill:zk=NameNode,DataNode1,Data

Node2"

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?"

sqlline>


Note : Removed the actual IP for security purpose.

Appreciate the help .


Thanks,

Divya



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