Hi Jack,
You definitely need some form of Avatica to access the system as Calcite
depends on code in Avatica. However, you don't need to set up an Avatica
server to access Druid via Calcite -- you can use the Calcite JDBC
driver directly.
In the original example, you included a username/password of
"admin"/"admin". I don't know if the Druid integration has
authentication pushdown (nor what kind of authentication Druid itself
supports). I would venture a guess that the username and password are
ignored and you could provide anything :)
Unless you have configured Avatica in such a way to require certain
authentication (which is unlikely) the values you provide are of no
consequence. Sqlline is just asking you for them because it assumes they
are required.
On 6/25/17 7:13 AM, Jack Ingoldsby wrote:
Hi Slim,
Thanks for your response. Sorry for delay in responding, but I realized had
not actually subscribed to the group.
So to use Calcite or the experimental SQL remotely I think I need Avatica.
I've installed it (the Avatica installation test succeeded), but I'm not a
Java programmer, and I'm finding some difficulties figuring out how to
connect to Avatica, or what I need to configure (passwords etc).
If enter the following I can connect locally via SQLLine just using
Calcite, and can query
!connectjdbc:calcite:schemaFactory=org.apache.calcite.adapter.druid.DruidSchemaFactory;schema.url=http://localhost:8082;schema.coordinatorUrl
=http://localhost:8081 admin admin
If I enter the following locally.
!connect jdbc:avatica:remote:url=http://localhost:8082/druid/v2/sql
I get asked for a username and password, but I don't know what the default
ids are, or where to adjust them (I assume there is a config file or
something, but I don't have the Java background to understand where they
might be).
Actually for this test, if there is a default username/pwd that would be
fine. I just want to do a proof of connectivity/querying against dummy data.
Thanks and regards,
Jack
From Slim Bouguerra <[email protected]>
Subject Re: Setting up remote JDBC Calcite Against Druid
Date Wed, 21 Jun 2017 19:19:55 GMT
have you looked at this ?
https://hortonworks.com/blog/connect-tableau-druid-hive/ <
https://hortonworks.com/blog/connect-tableau-druid-hive/>
Also druid as a built in SQL layer starting from druid 0.10.0 thus you can
use it to connect
tableau as well
http://druid.io/docs/latest/querying/sql.html <
http://druid.io/docs/latest/querying/sql.html>
