Having(GroupBy) · ApacheDruid中文技术文档(group having使用)

  本篇文章为你整理了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的观点,版权归原作者所有,仅为传播更多信息之目的,如有侵权请联系,我们将第一时间修改或删除,多谢。

留言与评论(共有 条评论)
   
验证码: