abhishekrb19 commented on code in PR #16277:
URL: https://github.com/apache/druid/pull/16277#discussion_r1563322067
##########
docs/development/extensions-core/stats.md:
##########
@@ -120,13 +132,19 @@ To acquire standard deviation from variance, user can use
"stddev" post aggregat
}
],
"intervals": [
- "2016-03-01T00:00:00.000/2013-03-20T00:00:00.000"
+ "2016-03-01/2013-03-20"
]
}
```
### TopN query
+#### Druid SQL
+
+There is no equivalent SQL for this query.
Review Comment:
Looking at this, it's possible to have a topN query -- the groupBy query
below with an `ORDER BY` on one dimension and a `LIMIT` clause should plan the
query as a `topN`. You could verify this by running `EXPLAIN PLAN FOR`
##########
docs/development/extensions-core/stats.md:
##########
@@ -107,6 +107,18 @@ To acquire standard deviation from variance, user can use
"stddev" post aggregat
### Timeseries query
+#### Druid SQL
+
+```SQL
Review Comment:
It will also be nice to include a mention of the SQL functions `VARIANCE`
and `STDDEV` in the above section where it provides the native JSON syntaxes
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
