Lakehouse v2 Expressions

Lakehouse v2 is built on StarRocks 4.1. For each function below, this site provides PlaidCloud-flavored syntax and examples; for the canonical upstream reference (with all edge cases and argument variants), see the StarRocks SQL function reference.

Aggregate Functions

• Aggregate Functions — Calculate summaries like sum, average, count, etc.
• Percentile Functions — Calculate percentile values and manage percentile states

Scalar Functions

• Array Functions — Perform array operations
• Binary Functions — Convert between binary and string formats
• Bit Functions — Perform bitwise operations
• Bitmap Functions — Perform bitmap operations and manipulations
• Condition Functions — Implement conditional logic and case statements
• Cryptographic Functions — Encrypt, decrypt, and hash data
• Date and Time Functions — Manipulate and format dates and times
• Dictionary Functions — Look up values in dictionary tables
• Hash Functions — Generate hash values using MurmurHash and xxHash
• JSON Functions — Create, query, and manipulate JSON data
• Map Functions — Create and manipulate map data structures
• Math Functions — Perform calculations and numeric operations
• Pattern Matching Functions — Match strings with LIKE and regular expressions
• Scalar Functions (HLL) — HyperLogLog cardinality estimation functions
• Spatial Functions — Handle and manipulate geospatial data
• String Functions — Manipulate strings and perform text operations
• Struct Functions — Create and work with struct data types
• Variant Functions — Query and inspect VARIANT data types

Table Functions

• Table Functions — Return results in a tabular format

Utility and Meta Functions

• Utility Functions — Access system information and session utilities
• Meta Functions — Inspect materialized views, memory, and diagnostics