SQL Reference

​

Data Types

• Data Types

​

Functions & Operators

• Aggregate Functions
• Sorted Aggregate Functions
• Window Aggregate Functions
• Scalar Data Conversion Functions
• Date and Time Functions
• Time Zone Functions
• Formatting Functions
• Math Functions and Operators
• Character and Binary Functions
• Matrix Functions and Operators
• Tuple Functions and Operators
• Other Functions and Expressions
• Array Functions and Operators
• HyperLogLog Functions
• Network Type Functions

​

Geospatial Functions & Operators

• Attribute Functions
• Conversion Functions
• Linestring Functions
• Linestring Constructors
• Point Constructors
• Polygon Constructors
• Spatial Measurement
• Spatial Operators
• Spatial Relationships
• Spatiotemporal Measurement
• Spatiotemporal Operators

​

DDL SQL Statements

• Cluster and Node Management
• Database, Tables, Views, and Indexes
• Data Pipelines
• Distributed Tasks
• Machine Learning Models
• Users, Groups, and Service Classes
• Data Integrity and Storage
• Query Analysis
• Statistics Cache Management

​

DCL SQL Statements

• Data Control Language (DCL) Statement Reference

​

Machine Learning Execution

• Machine Learning Model Functions

​

Other SQL Reference

• Errors and Warnings
• Reserved Words
• System Catalog Reference