Incubator-superset: Unable to connect to Druid broker

[avinash8526]

Hi, I am running Druid and Superset both on localhost

• To run Druid I have followed this documentation
  http://druid.io/docs/latest/tutorials/index.html

  • To run superset I have followed this documentation
    https://superset.incubator.apache.org/installation.html

I am able to run them both but in superset when I am trying to connect to druid cluster I am getting following error:

can ny 1 help me please...

[issue-label-bot[bot]]

Issue-Label Bot is automatically applying the label #question to this issue, with a confidence of 0.84. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

[elukey]

@avinash8526 hi! If I got it correctly, from now on the best place to ask questions is on stack overflow or Slack (see Superset Resources in https://superset.incubator.apache.org/). Anyway, in your case it seems that the Druid broker is not answering to queries. Have you checked that port 8082 on localhost (where superset runs) is working? (namely, if you issue a druid HTTP query, does it answer?)

[avinash8526]

Hi @elukey yes on 8082 it is working, if I do a curl I am getting response from druid.

[elukey]

@avinash8526 what version are you running? Can you please check and add in here the superset logs and the druid broker logs that happens when the error occurs? Also, did you check a curl on localhost:8082? Anyway, if possible I'd close this github issue (since it should be only to report bugs) and follow up with the community support on slack (https://apache-superset.slack.com), you'll find more support in there :)

[elukey]

@avinash8526 ping :)

[avinash8526]

@elukey curl and GET from browser is working fine, I think it is related to docker. I think since superset is running inside docker it is unable to connect to druid broker.

[tiagob]

Yes, I had this same problem. If you run

ifconfig | grep -E "([0-9]{1,3}\.){3}[0-9]{1,3}" | grep -v 127.0.0.1 | awk '{ print $2 }' | cut -f2 -d: | head -n1

From your machine, you'll get the localhost IP for use inside the docker container. You can use that on "Edit Druid Cluster" "Broker Host" and it should connect.

To verify this is right you can ssh into the docker container

docker ps
docker exec -it <container name> /bin/bash

And curl the druid cluster

curl <host ip>:8082/druid/v2/datasources

Source:
https://stackoverflow.com/a/38753971/709040

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.