[GitHub] gianm commented on issue #6108: more examples needed for druid sql

2018-08-06 Thread GitBox
gianm commented on issue #6108: more examples needed for druid sql URL: https://github.com/apache/incubator-druid/issues/6108#issuecomment-410796733 > @gianm regarding 4. is the behavior of native queries (topn, timeseries, groupby) the same as sql for this case? in that will they omit

[GitHub] gianm commented on issue #6108: more examples needed for druid sql

2018-08-05 Thread GitBox
gianm commented on issue #6108: more examples needed for druid sql URL: https://github.com/apache/incubator-druid/issues/6108#issuecomment-410550232 > I have one example query for "wikipedia top pages" in the new tutorials (the idea was more to show the tools/workflow vs being a tutorial

[GitHub] gianm commented on issue #6108: more examples needed for druid sql

2018-08-05 Thread GitBox
gianm commented on issue #6108: more examples needed for druid sql URL: https://github.com/apache/incubator-druid/issues/6108#issuecomment-410550178 (3) sounds like it's really the same question as (2), and TIME_FLOOR is the answer. (4) adheres to standard SQL: result rows are only

[GitHub] gianm commented on issue #6108: more examples needed for druid sql

2018-08-05 Thread GitBox
gianm commented on issue #6108: more examples needed for druid sql URL: https://github.com/apache/incubator-druid/issues/6108#issuecomment-410543659 Hi @pdeva, the answers to your questions are, 1. A time filter looks like `__time >= TIMESTAMP '2000-01-01 00:00:00' AND __time <