Could you please try by specifying drill ZK node details in connection URL.
options='{"url": "jdbc:drill:zk=maprdemo:5181/drill/demo_mapr_com-drillbits ",
"driver": "org.apache.drill.jdbc.Driver", "user": "mapr", "password": "mapr"}'
You could check using sqlline (it uses jdbc as well) with same connection
string to confirm if issue is related to any settings with HUE or not.
Thanks,
Arjun
________________________________
From: Stanczak, Karolina (DE - Berlin) <[email protected]>
Sent: Thursday, August 24, 2017 5:50 AM
To: [email protected]
Subject: Integrate Hue with Drill
Dear all,
I am trying to integrate Hue with Drill (on MapR Sandbox with Drill) and I
encountered the following problem.
An error occurred while calling z:java.sql.DriverManager.getConnection. :
java.lang.IllegalStateException: No active Drillbit endpoint found from
ZooKeeper. Check connection parameters? at
oadd.com.google.common.base.Preconditions.checkState(Preconditions.java:173) at
oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:334) at
org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:157)
at
org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72)
at org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
at
oadd.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143)
at org.apache.drill.jdbc.Driver.connect(Driver.java:72) at
java.sql.DriverManager.getConnection(DriverManager.java:664) at
java.sql.DriverManager.getConnection(DriverManager.java:247) at
sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498) at
py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:231) at
py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:381) at
py4j.Gateway.invoke(Gateway.java:259) at
py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:133) at
py4j.commands.CallCommand.execute(CallCommand.java:79) at
py4j.GatewayConnection.run(GatewayConnection.java:209) at
java.lang.Thread.run(Thread.java:748)
I have checked the drill-override.conf, which looks as following:
drill.exec: {
cluster-id: "demo_mapr_com-drillbits",
zk.connect: "maprdemo:5181"
hbase.scan.sizecalculator.enabled: "false"
}
And I added drill as interpreter:
[[[drill]]]
name=Drill JDBC
interface=jdbc
## Specific options for connecting to the server.
## The JDBC connectors, e.g. mysql.jar, need to be in the CLASSPATH
environment variable.
## If 'user' and 'password' are omitted, they will be prompted in the UI.
options='{"url": "jdbc:drill:zk=maprdemo:5181", "driver":
"org.apache.drill.jdbc.Driver", "user": "mapr", "password": "mapr"}'
and also defined the dbproxy_extra_classpath.
Do you have any ideas what the problem is?
Thank you in advance!
Best
Karolina
----------------------------------------------------------------------------
Vertraulichkeitshinweis
Diese Nachricht und jeder uebermittelte Anhang beinhaltet vertrauliche
Informationen und ist nur fuer die Personen oder das Unternehmen bestimmt, an
welche sie tatsaechlich gerichtet ist. Sollten Sie nicht der
Bestimmungsempfaenger sein, weisen wir Sie darauf hin, dass die Verbreitung,
das (auch teilweise) Kopieren sowie der Gebrauch der empfangenen E-Mail und der
darin enthaltenen Informationen gesetzlich verboten ist und gegebenenfalls
Schadensersatzpflichten ausloesen kann. Sollten Sie diese Nachricht aufgrund
eines Uebermittlungsfehlers erhalten haben, bitten wir Sie den Sender
unverzueglich hiervon in Kenntnis zu setzen.
Sicherheitswarnung: Bitte beachten Sie, dass das Internet kein sicheres
Kommunikationsmedium ist. Obwohl wir im Rahmen unseres Qualitaetsmanagements
und der gebotenen Sorgfalt Schritte eingeleitet haben, um einen
Computervirenbefall weitestgehend zu verhindern, koennen wir wegen der Natur
des Internets das Risiko eines Computervirenbefalls dieser E-Mail nicht
ausschliessen.
Confidentiality note
This message (including any attachments) contains confidential information
intended for a specific individual or entity as the intended recipient. If you
are not the intended recipient, you are hereby notified that any distribution,
any copying of this message in part or in whole, or any taking of action based
on it, is strictly prohibited by law and may cause liability. In case you have
received this message due to an error in transmission, we ask you to notify the
sender immediately.
Safety warning: Please note that the Internet is not a safe means of
communication or form of media. Although we are continuously increasing our due
care of preventing virus attacks as a part of our Quality Management, we are
not able to fully prevent virus attacks as a result of the nature of the
Internet.
Die Angaben nach ยง 37a HGB finden sich unter dem folgenden Link:
http://www.deloitte.com/de/Angaben37aHGB
----------------------------------------------------------------------------
