Not able to query created datasource

845 views
Skip to first unread message

Mahesh Abnave

unread,
Jul 15, 2016, 7:31:04 AM7/15/16
to Druid User
I have run a non-hadoop index task which resulted in the creation of data source called "websites". I can see the data source listed in the coordinator console.

Now I am trying to query some data. I have created a query json and executing following query from putty to my Ubuntu machine running single node druid cluster:

user@machine:/opt/druid-0.9.1.1$ sudo curl -X 'POST' -H 'Content-Type:application/json' -d @quickstart/websites-ds-metadata-query.json localhost:8081/druid/v2/?pretty

However this gave me following output:

<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1"/>
<title>Error 404 </title>
</head>
<body>
<h2>HTTP ERROR: 404</h2>
<p>Problem accessing /druid/v2/. Reason:
<pre>    Not Found</pre></p>
<hr /><i><small>Powered by Jetty://</small></i>
</body>
</html>


So I tried running following query (as suggested here) to check if it returns the datasource:

user@machine:/opt/druid-0.9.1.1$ sudo curl -X 'GET' localhost:8081/druid/v2/datasources

that too gave me following output:

<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1"/>
<title>Error 404 </title>
</head>
<body>
<h2>HTTP ERROR: 404</h2>
<p>Problem accessing /druid/v2/datasources. Reason:
<pre>    Not Found</pre></p>
<hr /><i><small>Powered by Jetty://</small></i>
</body>
</html>

I must be missing something. What is that?

Slim Bouguerra

unread,
Jul 15, 2016, 10:52:08 AM7/15/16
to druid...@googlegroups.com
do you see any thing on the broker logs ?


--
You received this message because you are subscribed to the Google Groups "Druid User" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-user+...@googlegroups.com.
To post to this group, send email to druid...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-user/f0d25723-4ac1-4592-b423-84a910ce84a8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Fangjin Yang

unread,
Jul 17, 2016, 1:58:50 PM7/17/16
to Druid User
Hi Mahesh, are you sure you have the broker running on 8081? It seems like you are running a queries against the coordinator.

Gian Merlino

unread,
Jul 17, 2016, 2:17:27 PM7/17/16
to druid...@googlegroups.com
Hey Mahesh,

The default broker port is 8082, try that instead.

Gian

--
You received this message because you are subscribed to the Google Groups "Druid User" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-user+...@googlegroups.com.
To post to this group, send email to druid...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-user/bd68fa0d-3bda-4a69-9110-054ae59d653a%40googlegroups.com.

Mahesh Abnave

unread,
Jul 18, 2016, 4:20:34 AM7/18/16
to Druid User
Ohh thanks all. It seems that I was indeed querying to coordinator, not broker.
Also it will be a lot of help if there is a single page listing all default ports. I just googled and came across this page.

It lists following ports:
  • 1527 (Derby; not needed if you are using a separate metadata store like MySQL or PostgreSQL)
  • 2181 (ZooKeeper; not needed if you are using a separate zookeeper cluster)
  • 8081 (Druid Coordinator)
  • 8090 (Druid Overlord)
  • 8082 (Druid Broker)
  • 9095 (Pivot)
  • 8083 (Druid Historical)
  • 8091 (Druid Middle Manager)
  • 8100–8199 (Druid Peons)
  • 8200 (Tranquility Server)
Does default druid ports are the same as above?

Mahesh Abnave

unread,
Jul 18, 2016, 4:30:38 AM7/18/16
to Druid User
Ohhh found below tut which lists druid default ports: http://druid.io/docs/latest/tutorials/cluster.html
Reply all
Reply to author
Forward
0 new messages