This SQL Reference section includes details about the different data types, functions, and operators available when writing queries for . For an introduction to the general query syntax and working with queries in Ocient, see Query Ocient. For information on the SQL syntax conventions used throughout the Ocient documentation, see the SQL Syntax Conventions page.Documentation Index
Fetch the complete documentation index at: https://docs.ocient.com/llms.txt
Use this file to discover all available pages before exploring further.
Data Types
Functions & Operators
- 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
- Databases
- Schemas
- Tables
- Indexes
- Data Pipelines
- Distributed Tasks
- Machine Learning Models
- Users, Groups, and Service Classes
- Data Integrity and Storage
- Query Analysis
- Query Management
- Statistics Cache Management