Functions (by Category)

Provides links to the system-defined scalar functions:

Category Description
Bitwise Expression Functions Perform bitwise operations on expressions.
Conditional Expression Functions Manipulate conditional expressions.
Context Functions Provide contextual information about the current environment, session, and object.
Numeric Functions Perform rounding, truncation, exponent, root, logarithmic, and trigonometric operations on numeric values.
String & Binary Functions Manipulate and transform string input.
Regular Expression (String) Functions Subset of strings functions for performing operations on items that match a regular expression.
Date & Time Functions Manipulate dates, times, and timestamps.
Semi-structured Data Functions Work with semi-structured data (JSON, Avro, etc.).
Conversion Functions Convert expressions from one data type to another data type.
Aggregate Functions Operate on values across rows to perform operations including counts, distincts, mathematical operations, approximate cardinality estimation, etc.
Analytic / Window Functions Compute aggregates over a group (i.e. window) of rows.
Miscellaneous Functions Utility functions, data generation functions, and random distribution functions.