SQL Function Reference
Databend provides comprehensive SQL functions for all types of data processing. Functions are organized by importance and usage frequency.
Core Data Functions
| Category | Description |
|---|---|
| Numeric Functions | Mathematical operations and calculations |
| String Functions | Text manipulation and string processing |
| Date & Time Functions | Date, time, and temporal operations |
| Conversion Functions | Type casting and data format conversions |
| Conditional Functions | Logic and control flow operations |
Analytics Functions
| Category | Description |
|---|---|
| Aggregate Functions | Statistical calculations across multiple rows |
| Window Functions | Advanced analytics with window operations |
Structured & Semi-Structured Data
| Category | Description |
|---|---|
| Structured & Semi-Structured Functions | JSON, arrays, objects, and nested data processing |
Search Functions
| Category | Description |
|---|---|
| Full-Text Search Functions | Full-text search and relevance scoring |
Vector Functions
| Category | Description |
|---|---|
| Vector Functions | Vector similarity and distance calculations |
Geospatial Functions
| Category | Description |
|---|---|
| Geospatial Functions | Geometry, GeoHash, and H3 spatial operations |
Data Management
| Category | Description |
|---|---|
| Table Functions | File inspection, data generation, and system information |
| System Functions | System information and management operations |
| Context Functions | Current session, user, and database information |
Security & Integrity
| Category | Description |
|---|---|
| Hash Functions | Data hashing and integrity verification |
| Bitmap Functions | High-performance bitmap operations and analytics |
| UUID Functions | Universally unique identifier generation |
| IP Address Functions | Network address manipulation and validation |
Utility Functions
| Category | Description |
|---|---|
| Interval Functions | Time unit conversion and interval creation |
| Sequence Functions | Auto-incrementing sequence value generation |
| Dictionary Functions | Real-time external data source queries (MySQL, Redis) |
| Test Functions | Testing and debugging utilities |
| Other Functions | Miscellaneous helpers and utilities |