Cloud

SQL Functions

Redpanda SQL supports the following function types for querying and transforming data:

Function Name Description

Function Name	Description
Boolean functions	Evaluate logical conditions and return `TRUE`, `FALSE`, or `NULL`.
Math, trigonometric, and hyperbolic functions	Perform mathematical operations on numeric data, including rounding, exponentiation, and trigonometric calculations.
String functions	Manipulate string data for text processing, including concatenation, substring extraction, and case conversion.
Timestamp functions	Handle date and time values, including extracting components, adding intervals, and comparing timestamps.
JSON functions	Manipulate and query JSON data stored in the database, including extracting values and creating JSON objects.
Aggregate functions	Summarize a set of values and return a single result, such as calculating sums, averages, and counts.
Window functions	Operate over a subset of rows defined by a windowing clause, enabling ranking, aggregation, and row numbering within result sets.
Other functions	Includes a variety of specialized functions not categorized elsewhere.

Evaluate logical conditions and return TRUE, FALSE, or NULL.

Perform mathematical operations on numeric data, including rounding, exponentiation, and trigonometric calculations.

Manipulate string data for text processing, including concatenation, substring extraction, and case conversion.

Handle date and time values, including extracting components, adding intervals, and comparing timestamps.

Manipulate and query JSON data stored in the database, including extracting values and creating JSON objects.

Summarize a set of values and return a single result, such as calculating sums, averages, and counts.

Operate over a subset of rows defined by a windowing clause, enabling ranking, aggregation, and row numbering within result sets.

Includes a variety of specialized functions not categorized elsewhere.

Was this helpful?