Connect druid to tableau 2018.3

Apache Druid Q&A Google Groups
#1

Hi all ,

I have a tableau 2018.3 version installed in my windows machine

and druid version of 0.13 in the imply 2.8.20 version

I have installed the apache Avatica calcite jar files from https://calcite.apache.org/avatica/downloads/

and following the instructions given in here - https://onlinehelp.tableau.com/current/pro/desktop/en-us/examples_otherdatabases_jdbc.htm

In tableau " other databases(JDBC)" connection I have given url as "jdbc:avatica:remote:url=http://host:8082/druid/v2/sql/avatica/"

and select dialect as SQL92

I have no clue on what are the values for username and password and properties file section .can anyone help me on this ??

When I try to connect without username and pwd I get below error :

Bad Connection: Tableau could not connect to the data source.

com.tableausoftware.jdbc.TableauJDBCException: Exception while connecting to server.

org.apache.calcite.avatica.org.apache.http.conn.HttpHostConnectException: Connect to 10.23.7.6:8082 [/10.23.7.6] failed: Connection timed out: connect

There was a Java error.

Generic JDBC connection error

com.tableausoftware.jdbc.TableauJDBCException: Exception while connecting to server.

org.apache.calcite.avatica.org.apache.http.conn.HttpHostConnectException: Connect to 10.23.7.6:8082 [/10.23.7.6] failed: Connection timed out: connect

There was a Java error.

P.S the attached screenshot of my other database (JDBC) window and the error I am getting .

Thanks,

Anoosha

Screenshot 2019-04-17 at 3.37.33 PM.png
Screenshot 2019-04-17 at 3.37.33 PM.png1674×996 121 KB

1 Like
#2

Hey Anoosha,

The “Connection timed out” message is probably nothing related to either Druid or Tableau, and might be a firewall in place between the Tableau machine & the Druid Broker at 10.23.7.6. Assuming that’s indeed a Broker, your setup looks ok to me. You could try connecting directly: if you fetch http://10.23.7.6:8082/status you should see some status output.

#3

Hi Anoosha,

First try to see if your machine where you launch the Tableau has access to port 8082 to the broker. Try telnet 8082 . see if you get any response.

#4

Hi,Anoosha,

I am also trying to connect druid to tableau，and I have encountered a problem after the connection is successful.

I am using the kafka index service feature, but there is no database available.

Are you using this feature too?

tebleau.png
tebleau.png1290×501 21.5 KB

在 2019年4月17日星期三 UTC+8下午6:34:01，anusha shetty写道：

#5

Hi zeng ,

Unfortunately , I am not Able to connect itself , I even have the Avatica downloaded in my system

I see you have successfully connected , can you please guide me what are the steps you followed ? so that I can follow the same and let you know if I am able to see my databases or not !

Thanks,

Anoosha

#6

I am seeing the same problem with you Anusha. Here is what I found from the broker log:

2019-04-29T18:39:07,835 ERROR [qtp1657920572-112] org.apache.calcite.runtime.CalciteException - org.apache.calcite.sql.validate.SqlValidatorException: Ordinal out of range

2019-04-29T18:39:07,836 ERROR [qtp1657920572-112] org.apache.calcite.runtime.CalciteException - org.apache.calcite.runtime.CalciteContextException: At line 5, column 10: Ordinal out of range

I think this is probably the issue why the database is not found. I will look for an answer.

#7

I found the problem was my druid was in 0.13.0 . not 0.14.0 . after i upgrade i could see the tables in Tableau.

#8

Hi guys ,

I tried installing avatica JDBC driver , and also did some telnet tests from the machine I was running tableau to the the machine I was hosting imply on , particular on the broker node to check if my broker nodes are available from the machine I am running tableau

It finally works for me !

I was able to connect and also see all the tables

Thanks,

Anoosha

#9

My broker port was not available , I had to change the port and then check through telnet that it is accessible …

Thanks ,

Anoosha