SQL support in Druid

Hi,

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.

Regards,

Santosh

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

  • Trying 127.0.0.1…

  • Connected to localhost (127.0.0.1) 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

< Allow: DELETE,OPTIONS

< 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.

http://druid.io/docs/0.10.0/querying/sql.html

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