List of functions by topic#
Aggregate#
For more details, see Aggregate functions
approx_set()
merge()
qdigest_agg()
tdigest_agg()
Array#
For more details, see Array functions and operators
concat()
reverse()
Binary#
For more details, see Binary functions and operators
concat()
length()
lpad()
reverse()
rpad()
substr()
Bitwise#
For more details, see Bitwise functions
Color#
For more details, see Color functions
Comparison#
For more details, see Comparison functions and operators
Conditional#
For more details, see Conditional expressions
Conversion#
For more details, see Conversion functions
Date and time#
For more details, see Date and time functions and operators
date_parse()
Geospatial#
For more details, see Geospatial functions
geometry_nearest_points()
ST_Contains()
ST_Crosses()
ST_Difference()
ST_Disjoint()
ST_Distance()
ST_Equals()
ST_Intersects()
ST_Intersection()
ST_Overlaps()
ST_Point()
ST_Relate()
ST_SymDifference()
ST_Touches()
ST_Union()
ST_Within()
HyperLogLog#
For more details, see HyperLogLog functions
cardinality()
JSON#
For more details, see JSON functions and operators
Lambda#
For more details, see Lambda expressions
Machine learning#
For more details, see Machine learning functions
Map#
For more details, see Map functions and operators
Math#
For more details, see Mathematical functions and operators
Quantile digest#
For more details, see Quantile digest functions
Regular expression#
For more details, see Regular expression functions
Row pattern recognition expressions#
Session#
For more details, see Session information
Set Digest#
For more details, see Set Digest functions
String#
For more details, see String functions and operators
System#
For more details, see System information
T-Digest#
For more details, see T-Digest functions
merge()
value_at_quantile()
Teradata#
For more details, see Teradata functions
URL#
For more details, see URL functions
UUID#
For more details, see UUID functions
Window#
For more details, see Window functions