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. You must specify the field name, the lower and upper bounds and the gap or bucket size.
Code Block | ||||||
---|---|---|---|---|---|---|
|
...
field_name[start..end]: |
...
avg(gerp)
...
step |
Range parameters:
Parameter | Description |
---|---|
field_name | The numeric field name to produce range buckets from. |
start | Lower bound of the ranges. |
end | Upper bound of the ranges. |
step | Size of each range bucket produced. |
Aggregation functions
Aggregation functions, also called facet functions, analytic functions, or metrics, calculate something interesting over a domain (each facet bucket).
Aggregation |
---|
Description |
---|
Example |
---|
avg |
Average of numeric values | avg(gerp) | |
min | Minimum value | min(sift) |
max | Maximum value |
max(caddScaled) |
unique | Number of unique values | unique(biotypes) |
Number of unique values
hll |
hll(type)
Distributed cardinality estimate via hyper-log-log algorithm |
hll(type) |
percentile |
Percentile estimates via t-digest algorithm. Calculate the percentiles: 1, 10, 25, 50, 75, 90 and 99th. |
percentile(gerp) |
sumsq |
Sum of squares of field or function | sumsq(caddRaw) |