SQL Function Reference
This page provides a reference for all SQL functions available in Databend, organized by category.
Core SQL Functions
| Category | Description |
|---|---|
| Numeric Functions | Mathematical operations for numerical data processing and analysis |
| String Functions | Text manipulation and pattern matching operations for data processing |
| Date & Time Functions | Date and time manipulation for temporal data analysis |
| Aggregate Functions | Functions that perform calculations across multiple rows |
| Window Functions | Functions that operate on a set of rows related to the current row |
Data Type Functions
| Category | Description |
|---|---|
| Conversion Functions | Type conversion and casting operations between different data types |
| Array Functions | Functions for creating and manipulating array collections |
| Map Functions | Functions for working with key-value pair collections |
| Semi-structured Functions | Functions for processing JSON and other semi-structured data |
Logical and Control Functions
| Category | Description |
|---|---|
| Conditional Functions | Logic-based data transformation and flow control functions |
| Interval Functions | Creation and manipulation of time intervals for date calculations |
System and Metadata Functions
| Category | Description |
|---|---|
| Table Functions | Functions that return result sets as tables |
| System Functions | Functions for accessing system information and management |
| Context Functions | Functions for accessing session and environment information |
Specialized Analytics Functions
| Category | Description |
|---|---|
| Geo Functions | Geographic coordinate and H3 geospatial operations |
| Geometry Functions | Geometric shape operations and spatial calculations |
| Search Functions | Full-text search capabilities and text relevance |
AI and Vector Functions
| Category | Description |
|---|---|
| AI Functions | Natural language processing and AI capabilities |
| Vector Distance Functions | Vector similarity and distance calculations |
Data Integrity Functions
| Category | Description |
|---|---|
| Hash Functions | Data hashing and fingerprinting algorithms |
| UUID Functions | Universally unique identifier generation and handling |
| IP Address Functions | IP address manipulation and conversion |
| Bitmap Functions | Bit-level operations and manipulations |
Utility Functions
| Category | Description |
|---|---|
| Sequence Functions | Sequence generation and manipulation |
| Dictionary Functions | External data source integration |
| Test Functions | Functions for testing and development purposes |