You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by "Stanczak, Karolina (DE - Berlin)" <ka...@deloitte.de> on 2017/08/24 12:50:27 UTC
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
----------------------------------------------------------------------------
Re: Integrate Hue with Drill
Posted by Arjun Rajan <ar...@mapr.com>.
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) <ka...@deloitte.de>
Sent: Thursday, August 24, 2017 5:50 AM
To: user@drill.apache.org
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
----------------------------------------------------------------------------