本篇文章为你整理了Having(GroupBy) · ApacheDruid中文技术文档(group having使用)的详细内容,包含有having group by where group having使用 having group by order by having group by用法 Having(GroupBy) · ApacheDruid中文技术文档,希望能帮助你了解 Having(GroupBy) · ApacheDruid中文技术文档。
[!WARNING]
Apache Druid Druid SQL Druid SQL SQL
having GroupBy SQL HAVING
Apache Druid having
(Query Filters)
Druid Having HavingSpec
{
queryType : groupBy ,
dataSource : sample_datasource ,
having :
type : filter ,
filter : any Druid query filter
(selector filter)
{
queryType : groupBy ,
dataSource : sample_datasource ,
having :
type : filter ,
filter : {
type : selector ,
dimension : dimension ,
value : dimension_value
Having __time
(Numeric Filters)
having
having
{
queryType : groupBy ,
dataSource : sample_datasource ,
having :
type : greaterThan ,
aggregation : aggregate_metric ,
value : numeric_value
(equalTo)
equalTo
{
queryType : groupBy ,
dataSource : sample_datasource ,
having :
type : equalTo ,
aggregation : aggregate_metric ,
value : numeric_value
HAVING aggregate value
(Greater Than)
greaterThan
{
queryType : groupBy ,
dataSource : sample_datasource ,
having :
type : greaterThan ,
aggregation : aggregate_metric ,
value : numeric_value
HAVING aggregate value
(Less Than)
lessThan
{
queryType : groupBy ,
dataSource : sample_datasource ,
having :
type : lessThan ,
aggregation : aggregate_metric ,
value : numeric_value
HAVING aggregate value
(Dimension Selector Filter)
dimSelector
dimSelector
{
queryType : groupBy ,
dataSource : sample_datasource ,
having :
type : dimSelector ,
dimension : dimension ,
value : dimension_value
(Logical Expression Filters)
AND
{
queryType : groupBy ,
dataSource : sample_datasource ,
having :
type : and ,
havingSpecs : [
type : greaterThan ,
aggregation : aggregate_metric ,
value : numeric_value
type : lessThan ,
aggregation : aggregate_metric ,
value : numeric_value
OR
{
queryType : groupBy ,
dataSource : sample_datasource ,
having :
type : or ,
havingSpecs : [
type : greaterThan ,
aggregation : aggregate_metric ,
value : numeric_value
type : equalTo ,
aggregation : aggregate_metric ,
value : numeric_value
NOT
{
queryType : groupBy ,
dataSource : sample_datasource ,
having :
type : not ,
havingSpec :
type : equalTo ,
aggregation : aggregate_metric ,
value : numeric_value
以上就是Having(GroupBy) · ApacheDruid中文技术文档(group having使用)的详细内容,想要了解更多 Having(GroupBy) · ApacheDruid中文技术文档的内容,请持续关注盛行IT软件开发工作室。
郑重声明:本文由网友发布,不代表盛行IT的观点,版权归原作者所有,仅为传播更多信息之目的,如有侵权请联系,我们将第一时间修改或删除,多谢。