Hey Jack, Based on the URL http://localhost:8082/druid/v2/sql it looks like you're using the built in Druid SQL. It doesn't support authentication yet so you could put anything in for user/password (it will be ignored). This will change in the future, when there will be a server-side option to enable authentication.
Gian On Sun, Jun 25, 2017 at 4:13 AM, Jack Ingoldsby <[email protected]> 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> > > > -- > > B-Slim > _______/\/\/\_______/\/\/\_______/\/\/\_______/\/\/\_______/\/\/\_______ > > > On Jun 21, 2017, at 11:49 AM, Jack Ingoldsby <[email protected]> > wrote: > > > > Hi, > > I was asked by one of our sales guys to have a look at seeing if our BI > > tool can query Druid. > > I spun up an AWS Linux instance, installed Druid, have populated with 43 > > records from wikiticker. > > > > I can query on the instance using Calcite Sqlline with the jdbc > connection > > string > > > > > !connectjdbc:calcite:schemaFactory=org.apache.calcite.adapter.druid. > DruidSchemaFactory;schema.url=http://localhost:8082;schema.coordinatorUrl > > =http://localhost:8081 admin admin > > > > > > I've installed Avatica/Calcite on my local windows machine, but am not > > really sure how to connect to the remote instance... I've made a genuine > > effort searching including the archives, but no avail . > > > > Are there any steps or examples of setting up remote connections? I need > > to demonstrate it is possible for a customer demo tomorrow (in > principle, > > performance not yet a concern), so any help would be greatly appreciated. > > > > Thanks, > > Jack > > On Wed, Jun 21, 2017 at 2:49 PM, Jack Ingoldsby <[email protected]> > wrote: > > > Hi, > > I was asked by one of our sales guys to have a look at seeing if our BI > > tool can query Druid. > > I spun up an AWS Linux instance, installed Druid, have populated with 43 > > records from wikiticker. > > > > I can query on the instance using Calcite Sqlline with the jdbc > > connection string > > > > > > !connectjdbc:calcite:schemaFactory=org.apache.calcite.adapter.druid. > DruidSchemaFactory;schema.url=http://localhost:8082;schema.coordinatorUrl > > =http://localhost:8081 admin admin > > > > > > I've installed Avatica/Calcite on my local windows machine, but am not > > really sure how to connect to the remote instance... I've made a genuine > > effort searching including the archives, but no avail . > > > > Are there any steps or examples of setting up remote connections? I need > > to demonstrate it is possible for a customer demo tomorrow (in > principle, > > performance not yet a concern), so any help would be greatly appreciated. > > > > Thanks, > > Jack > > >
