本篇文章为你整理了聚合 · ApacheDruid中文技术文档(聚合wan)的详细内容,包含有聚合trunk 聚合wan 聚合ndi 聚合是啥意思 聚合 · ApacheDruid中文技术文档,希望能帮助你了解 聚合 · ApacheDruid中文技术文档。
[!WARNING]
Apache Druid Druid SQL Druid SQL SQL
Apache Druid
Count
count
{ type : count , name : output_name }
Druid Druid count longSum
longSum
64
{ type : longSum , name : output_name , fieldName : metric_name }
name
fieldName
doubleSum
64 longSum
{ type : doubleSum , name : output_name , fieldName : metric_name }
floatSum
32 longSum doubleSum
{ type : floatSum , name : output_name , fieldName : metric_name }
Min/Max
doubleMin
doubleMin Double.POSITIVE_INFINITY
{ type : doubleMin , name : output_name , fieldName : metric_name }
doubleMax
doubleMax Double.NEGATIVE_INFINITY
{ type : doubleMax , name : output_name , fieldName : metric_name }
floatMin
floatMin Float.POSITIVE_INFINITY
{ type : floatMin , name : output_name , fieldName : metric_name }
floatMax
floatMax Float.NEGATIVE_INFINITY
{ type : floatMax , name : output_name , fieldName : metric_name }
longMin
longMin Long.MAX_VALUE
{ type : longMin , name : output_name , fieldName : metric_name }
longMax
longMax Long.MIN_VALUE
{ type : longMax , name : output_name , fieldName : metric_name }
doubleMean
64
{ type : doubleMean , name : output_name , fieldName : metric_name }
First/Last
Double/Float/Long First/Last
rollup first/last
doubleFirst
doubleFirst 0 SQL null
{
type : doubleFirst ,
name : output_name ,
fieldName : metric_name
doubleLast
doubleLast 0 SQL null
{
type : doubleLast ,
name : output_name ,
fieldName : metric_name
floatFirst
floatFirst 0 SQL null
{
type : floatFirst ,
name : output_name ,
fieldName : metric_name
floatLast
floatLast 0 SQL null
{
type : floatLast ,
name : output_name ,
fieldName : metric_name
longFirst
longFirst 0 SQL null
{
type : longFirst ,
name : output_name ,
fieldName : metric_name
longLast
longLast 0 SQL null
{
type : longLast ,
name : output_name ,
fieldName : metric_name ,
stringFirst
stringFirst null
{
type : stringFirst ,
name : output_name ,
fieldName : metric_name ,
maxStringBytes : integer # (optional, defaults to 1024)
stringLast
stringLast null
{
type : stringLast ,
name : output_name ,
fieldName : metric_name ,
maxStringBytes : integer # (optional, defaults to 1024)
Double/Float/Long/String ANY
null null
doubleAny
doubleAny double
{
type : doubleAny ,
name : output_name ,
fieldName : metric_name
floatAny
floatAny float
{
type : floatAny ,
name : output_name ,
fieldName : metric_name
longAny
longAny long
{
type : longAny ,
name : output_name ,
fieldName : metric_name ,
stringAny
stringAny string
{
type : stringAny ,
name : output_name ,
fieldName : metric_name ,
maxStringBytes : integer # (optional, defaults to 1024),
JavaScript
JavaScript JavaScript
{ type : javascript ,
name : output_name ,
fieldNames : [ column1 , column2 , ... ],
fnAggregate : function(current, column1, column2, ...) {
updates partial aggregate (current) based on the current row values
return updated partial aggregate
fnCombine : function(partialA, partialB) { return combined partial results } ,
fnReset : function() { return initial value }
{
type : javascript ,
name : sum(log(x)*y) + 10 ,
fieldNames : [ x , y ],
fnAggregate : function(current, a, b) { return current + (Math.log(a) * b); } ,
fnCombine : function(partialA, partialB) { return partialA + partialB; } ,
fnReset : function() { return 10; }
[!WARNING]
JavaScript Druid JavaScript JavaScript
(Approximate Aggregations)
(Count distinct)
Apache DataSketches Theta Sketch
DataSketches Theta Sketch Apache Datasketches Theta Sketch
Apache DataSketches HLL Sketch
DataSketches HLL Sketch HyperLogLog
Theta HLL set
Cardinality, hyperUnique
[!WARNING]
DataSketches Theta Sketch DataSketches HLL Sketch DataSketch Druid cardinality hyperUnique
Cardinality HyperUnique Druid HyperLogLog Theta HLL
DataSketches Druid HLL DataSketches HLL Druid HLL
hyperUnique Detasketches HLL Theta sketches
(multi-column handling)
DataSketches Theta HLL Cardinality Theta HLL
byValue Cardinality Theta Sketches
byRow Cardinality Theta HLL Sketch
以上就是聚合 · ApacheDruid中文技术文档(聚合wan)的详细内容,想要了解更多 聚合 · ApacheDruid中文技术文档的内容,请持续关注盛行IT软件开发工作室。
郑重声明:本文由网友发布,不代表盛行IT的观点,版权归原作者所有,仅为传播更多信息之目的,如有侵权请联系,我们将第一时间修改或删除,多谢。