SQL support in Druid


I am currently evaluating Druid and trying to use SQL interface. I get following error “405 method not allowed”

I am using druid “druid-0.10.0” version with quickstart configuration.

Sure I am missing some configuration.

Let me know.



curl -v -XPOST -H’Content-Type: application/json’ http://localhost:8082/druid/v2/sql/ -d ‘{“query”:"SELECT COUNT(*) from "}’

  • Trying…

  • Connected to localhost ( port 8082 (#0)

POST /druid/v2/sql/ HTTP/1.1

Host: localhost:8082

User-Agent: curl/7.47.0

Accept: /

Content-Type: application/json

Content-Length: 41

  • upload completely sent off: 41 out of 41 bytes

< HTTP/1.1 405 Method Not Allowed

< Date: Mon, 07 Aug 2017 10:40:48 GMT


< Content-Length: 0

< Server: Jetty(9.3.16.v20170120)


  • Connection #0 to host localhost left intact

Got it working by enabling sql in properties file.

The build-in sql is disable default.
see this for detail.


在 2017年8月7日星期一 UTC+8下午6:43:43,Santosh写道: