SQL Functions

This section provides documentation for all SQL functions supported in OpenObserve. Functions are grouped by category to help you quickly find the one that fits your use case.

Function categories

• Full-Text Search Functions
• Secondary Index Functions
• Array Functions
• String and Regex Functions
• Date and Time Functions
• Aggregate Functions
• Approximate Aggregate Functions
  • Approximate Aggregate Overview
  • approx_topk
  • approx_topk_distinct
• Other Functions: VRL functions in SQL and fold_native_frames

Standard SQL and DataFusion functions, such as COUNT, date_trunc, regexp_replace, and approx_percentile_cont, also work. See the DataFusion SQL reference.

Need some help?

• Join our Community Slack
• Or Contact support