SQL Function Reference
These topics provide reference information for the system-defined functions in Databend.
Data Type Functions
- Array Functions - Handle and manipulate array data.
- Map Functions - Handle and manipulate map data.
- String Functions - Manipulate strings and perform regular expression operations.
- Numeric Functions - Perform calculations and numeric operations.
- Date & Time Functions - Manipulate and format dates and times.
- Interval Functions - Work with time intervals and durations.
- Semi-structured and Structured Data Functions - Work with JSON and other structured data formats.
Analytical Functions
- Aggregate Functions - Calculate summaries like sum, average, count, etc.
- Window Functions - Provide aggregate calculations over a specified range of rows.
AI and Vector Functions
- AI Functions - Leverage AI and machine learning capabilities.
- Vector Distance Functions - Calculate distances between vectors for similarity search.
Geospatial Functions
- Geo Functions - Handle and manipulate geospatial data.
- Geometry Functions - Work with geometric shapes and calculations.
Data Processing Functions
- Conversion Functions - Convert data types and cast values.
- Conditional Functions - Implement conditional logic and case statements.
- Bitmap Functions - Perform bitwise operations and manipulations.
- Full-Text Search Functions - Leverage inverted indexes for efficient data retrieval.
System and Utility Functions
- System Functions - Access system-level information and perform control operations.
- Table Functions - Return results in a tabular format.
- Context Functions - Provide information about the current SQL execution context.
- Hash Functions - Generate hash values for data security and comparison.
- UUID Functions - Generate and manipulate UUIDs.
- IP Address Functions - Manipulate and analyze IP address data.
Other Specialized Functions
- Dictionary Functions - Work with dictionary data structures.
- Sequence Functions - Generate and manipulate sequences.
- Other Miscellaneous Functions - A collection of various other functions.