In construction...!
fields=chromosome>>type
sum | sum(sales) | summation of numeric values |
avg | avg(popularity) | average of numeric values |
min | min(salary) | minimum value |
max | max(mul(price,popularity)) | maximum value |
unique | unique(author) | number of unique values |
hll | hll(author) | distributed cardinality estimate via hyper-log-log algorithm |
percentile | percentile(salary,50,75,99,99.9) | Percentile estimates via t-digest algorithm. When sorting by this metric, the first percentile listed is used as the sort value. |
sumsq | sumsq(rent) | sum of squares of field or function |
variance | variance(rent) | variance of numeric field or function |
List of facet fields separated by semicolons, e.g.: studies;type. For nested faceted fields use >>, e.g.: chromosome>>type;percentile(gerp) | query |
Ranges
When asking for ranges, the result contains multiple buckets over a numeric field.
Range specification | Example | Description |
---|---|---|
field_name[start..end]:gap | avg(gerp) | Average of numeric values |
Aggregation functions
Aggregation functions, also called facet functions, analytic functions, or metrics, calculate something interesting over a domain (each facet bucket).
Aggregation | Example | Description |
---|---|---|
avg | avg(gerp) | Average of numeric values |
min | min(sift) | Minimum value |
max | max(caddScaled) | Maximum value |
unique | unique(biotypes) | Number of unique values |
hll | hll(type) | Distributed cardinality estimate via hyper-log-log algorithm |
percentile | percentile(gerp) | Percentile estimates via t-digest algorithm. Calculate the percentiles: 1, 10, 25, 50, 75, 90 and 99th. |
sumsq | sumsq(rent) | Sum of squares of field or function |