Some SciDB operators aggregate, or reduce, multiple values in an array into a single value, and produce an array with different dimensions. Such operators are called aggregating operators. Each aggregating operator and its parameters control the pattern between the input array and the output values, but make reference to one of a separate set of aggregate functions to describe the calculation desired to produce each aggregated, or reduced, output value.

The aggregating operators are:

The aggregates in the Community Edition are:

To list all aggregate functions currently available from the libraries loaded into your SciDB, issue the following query:

AFL% list('aggregates');

Syntax

AFL Syntax

SciDB aggregate operators have the general syntax:

aggregate_operator(array, aggregate1(), [aggregate2(),[ ...]], dimension1, [dimension2,[ ...]]);

where

aggregate_operator is from the list above
aggregate is from the list above
dimension is a dimension along which the corresponding aggregate is computed and each aggregate may be optionally followed by the phrase 'as alias' where alias specifies an overriding attribute name for the computed value (vs the default generated by the aggregate)

AQL Syntaxes

SELECT aggregate1 [, aggregate2[,...]]

[INTO dst-array]
FROM src-array | array-expression
[WHERE where-expression]
[REGRID AS ( PARTITION BY dimension1 dimension1-size [, dimension2 dimension2-size,[...]]) ;

SELECT aggregate1 [, aggregate2[,...]]

[INTO dst-array]
FROM src-array | array-expression ]
[WHERE where-expression]
[FIXED | VARIABLE WINDOW AS ( PARTITION BY dimension1 dim1-low PRECEDING AND dim1-high FOLLOWING

[, dimension2 dim2-low PRECEDING AND dim2-high FOLLOWING [,...]] );

Browser not supported