ReferenceSql functionsApproximate aggregate
Approximate Aggregate Overview
OpenObserve provides the following approximate aggregate functions designed for high-cardinality data analysis at scale.
Learn more:
Was this page helpful?
Last updated on
Aggregate Functions
Use the histogram() function to group time-based log data into fixed intervals for trend analysis. Syntax, aggregate use, and a worked 30-second example.
approx_topk
Use approx_topk() to find the most frequent values in high-cardinality fields. Syntax, example, result structure, and comparison with GROUP BY.