Applies to: Databricks SQL Databricks Runtime
This article presents links to and descriptions of built-in operators and functions for strings and binary types, numeric scalars, aggregations, windows, arrays, maps, dates and timestamps, casting, CSV data, JSON data, XPath manipulation, and other miscellaneous functions.
For use cases that are not supported by existing built-in functions, consider defining a custom function. See What are user-defined functions (UDFs)?.
Also see:
Operators and predicatesâFor information on how operators are parsed with respect to each other, see Operator precedence.
Operator precedenceâ String and binary functionsâ Numeric scalar functionsâ Aggregate functionsâ Ranking window functionsâ Analytic window functionsâ Array functionsâ Map functionsâ Date, timestamp, and interval functionsâFor information on date and timestamp formats, see Datetime patterns.
H3 geospatial functionsâFor information about H3 geospatial functions, see H3 geospatial functions.
ST geospatial functionsâFor information about ST geospatial functions, see ST geospatial functions.
Cast functions and constructorsâFor information on casting between types, see cast
function and try_cast
function.
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4