Documentation on how to build queries

[dene14]

Hello there!

It's rather not an issue but a question...

I've failed to find out any comprehensive documentation, so I would like to ask here to clarify if functionality hasn't been implemented yet or it's me doing something wrong...

1. For me it seems that nothing except "select" query type is working, any other like "TopN" or "Timeseries" show nothing, in query inspector I have nothing but a rotating wheel.
2. With "Select" query type I was able to get some aggregated values (seems to be more or less valid), but this happens only if I set "mode" for X-Axis to "Series" or "Histogram", no luck with "Time".
3. A bit unclear "Threshold" setting in query builder, if I understand it correct it defaults to 5 which causes 5 instances of the same value for every object recieved from druid, setting it equal to 1 gives more reasonable result, but still want to understand what's under the hood of it.

Please elaborate. Many thanks!

[christoph-buente]

We also successfully ran exploratory queries for data dimensions and column names. But when it comes to actually query timeseries data, nothing is returned. And it's really hard to track, if it is just not supported, or the query builder dies, or the resulting query is not compatible with druid.

[pkarmaka]

@dene14

1. Users in my company have been using TopN or Group by druid queries. For confirmation, I even tried out a Top N query and it looked fine. Probably the best way for you to confirm whether you are giving the right parameters is to post to your datasource api using Postman. Also , please check docs http://druid.io/docs/latest/querying/aggregations.html (among the ones that we support) for the right aggregations that you require.

2. I need to check "select" query type from druid docs. All other query types are working ok on the plugin.

3. Are you saying you are getting repetitive results because you don't have 5 results?

[dene14]

for #3 yes, I'm getting repetetive value for the same object, count of repetitions controlled by the switcher from above. I'm sure that our aggregate doesn't have such repetitions, so was wondering why it's working like that. Maybe Druid version is a problem? we're still on 0.9.2 however I haven't noticed any significant change in interfacing endpoints in the changelog... 2018-02-07 12:07 GMT+03:00 pkarmaka <[email protected]>:

…

@dene14 <https://github.com/dene14> 1. Users in my company have been using TopN or Group by druid queries. For confirmation, I even tried out a Top N query and it looked fine. Probably the best way for you to confirm whether you are giving the right parameters is to post to your datasource api using Postman. Also , please check docs http://druid.io/docs/latest/querying/aggregations.html (among the ones that we support) for the right aggregations that you require. 2. I need to check "select" query type from druid docs. All other query types are working ok on the plugin. 3. Are you saying you are getting repetitive results because you don't have 5 results? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#53 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AG85dZua9E7JMUN048Gnzwc7dVOUACg6ks5tSWfqgaJpZM4R0O1S> .

-- Best regards, Denis Boulas