Sending JSON queries to Plywood Server

Hi all,

We’re trying put a query server on top of our Druid cluster and we’re thinking of using Plywood. In the Plywood documentation here http://plywood.imply.io/ it’s stated that we can run the server like this:

Inline image 1

And the server will be able to take SQL strings or Plywood JSON.

Is the proxy server the same as the PlyQL server described here? http://imply.io/post/2016/05/04/programmatic-plyql.html Or is it something else?

If it’s the PlyQL server, I understand that we can supply a SQL string through the curl -d option, but how can we supply a JSON payload as the query? And what does the schema for Plywood JSON look like? Are they just the same fields that we can use to query Druid directly?

Thanks in advance!

Best,

Augustus

This is the image that was broken in the previous post:

Hi,

The component depicted in that image is https://github.com/implydata/plywood-proxy but it is deprecated (the image should be updated).
The plywood proxy functionality has been rolled into plyql which is the tool mentioned in http://imply.io/post/2016/05/04/programmatic-plyql.html

While plyql is mostly intended to be used with the PlyQL SQL-like language you can also post plywood to it by making a POST to /plywood when running in --json-server mode.

Here is the unit test for that functionality: https://github.com/implydata/plyql/blob/master/test/json-server.mocha.js#L138

For any more questions of feedback regarding the Ply* tools head over to: https://groups.google.com/forum/#!forum/imply-user-group

Best regards,
Vadim