OpenObserve Docs
ReferenceSql functionsApproximate aggregate

Approximate Aggregate Overview

Updated View MarkdownOpen in ChatGPTOpen in Claude

OpenObserve provides the following approximate aggregate functions designed for high-cardinality data analysis at scale.

Learn more:

Was this page helpful?

Aggregate Functions

OpenObserve aggregate SQL functions: histogram time buckets, weighted summary_percentile, and sequence functions for ordered funnels and step timing.

approx_topk

Use approx_topk() to find the most frequent values in high-cardinality fields. Syntax, example, result structure, and comparison with GROUP BY.