Connect druid to tableau 2018.3

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

1 Like

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.

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.

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?

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

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

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.

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.

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

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

Thanks ,

Anoosha