gianm edited a comment 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 < TIMESTAMP '2000-01-02 00:00:00'`. This syntax adheres to the SQL standard. 2. If you group by a `TIME_FLOOR` function, that's like specifying granularity (this is mentioned in the docs under "Query execution" where it says we'll use timeseries if we can for this function). 3. Not sure what you mean by this? 4. Not sure what you mean by this? 5. They are undocumented, but they won't be for long. http://druid.io/docs/latest/misc/math-expr.html might help you understand what they're doing. I agree an examples section would be nice; @jon-wei was working on some new tutorials for querying, maybe he can chime in with whether he had planned on adding SQL examples.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
