---
title: SQL Reference
slug: kkIgFxRWf0q_4BJ4UHIfk
description: Access Ocient SQL reference guide, covering syntax, commands, and examples for effective querying.
docTags: 
createdAt: Thu Jul 21 2022 17:05:13 GMT+0000 (Coordinated Universal Time)
updatedAt: Wed Apr 22 2026 20:50:55 GMT+0000 (Coordinated Universal Time)
---

This SQL Reference section includes details about the different data types, functions, and operators available when writing queries for Ocient®. For an introduction to the general query syntax and working with queries in Ocient, see [Query Ocient](<./Query Ocient.md>).

For information on the SQL syntax conventions used throughout the Ocient documentation, see the [SQL Syntax Conventions](<./Query Ocient/General SQL Syntax/SQL Syntax Conventions.md>) page.&#x20;

## **Data Types**

- [Data Types](<./SQL Reference/Data Types.md>)&#x20;

## **Functions & Operators**

- [Aggregate Functions](<./SQL Reference/Aggregate Functions.md>)&#x20;
- [Window Aggregate Functions](<./SQL Reference/Window Aggregate Functions.md>)&#x20;
- [Scalar Data Conversion Functions](<./SQL Reference/Scalar Data Conversion Functions.md>)&#x20;
- [Date and Time Functions](<./SQL Reference/Date and Time Functions.md>)
- [Time Zone Functions](<./SQL Reference/Time Zone Functions.md>) &#x20;
- [Formatting Functions](<./SQL Reference/Formatting Functions.md>)&#x20;
- [Math Functions and Operators](<./SQL Reference/Math Functions and Operators.md>) &#x20;
- [Character and Binary Functions](<./SQL Reference/Character and Binary Functions.md>)&#x20;
- [Matrix Functions and Operators](<./SQL Reference/Matrix Functions and Operators.md>)&#x20;
- [Tuple Functions and Operators](<./SQL Reference/Tuple Functions and Operators.md>)&#x20;
- [Other Functions and Expressions](<./SQL Reference/Other Functions and Expressions.md>)&#x20;
- [Array Functions and Operators](<./SQL Reference/Array Functions and Operators.md>)&#x20;
- [HyperLogLog Functions](<./SQL Reference/HyperLogLog Functions.md>)&#x20;
- [Network Type Functions](<./SQL Reference/Network Type Functions.md>)&#x20;

## **Geospatial Functions & Operators**

- [Attribute Functions](<./SQL Reference/Geospatial Functions/Attribute Functions.md>) &#x20;
- [Conversion Functions](<./SQL Reference/Geospatial Functions/Conversion Functions.md>)&#x20;
- [Linestring Functions](<./SQL Reference/Geospatial Functions/Linestring Functions.md>)&#x20;
- [Linestring Constructors](<./SQL Reference/Geospatial Functions/Linestring Constructors.md>)&#x20;
- [Point Constructors](<./SQL Reference/Geospatial Functions/Point Constructors.md>)&#x20;
- [Polygon Constructors](<./SQL Reference/Geospatial Functions/Polygon Constructors.md>)&#x20;
- [Spatial Measurement](<./SQL Reference/Geospatial Functions/Spatial Measurement.md>)&#x20;
- [Spatial Operators](<./SQL Reference/Geospatial Functions/Spatial Operators.md>)&#x20;
- [Spatial Relationships](<./SQL Reference/Geospatial Functions/Spatial Relationships.md>)&#x20;
- [Spatiotemporal Measurement](<./SQL Reference/Geospatial Functions/Spatiotemporal Measurement.md>)&#x20;
- [Spatiotemporal Operators](<./SQL Reference/Geospatial Functions/Spatiotemporal Operators.md>)&#x20;

## **DDL SQL Statements**

- [Cluster and Node Management](<./SQL Reference/Data Definition Language _DDL_ Statement Reference/Cluster and Node Management.md>) &#x20;
- [Databases](<./SQL Reference/Data Definition Language _DDL_ Statement Reference/Databases.md>)&#x20;
- [Schemas](<./SQL Reference/Data Definition Language _DDL_ Statement Reference/Schemas.md>)&#x20;
- [Tables](<./SQL Reference/Data Definition Language _DDL_ Statement Reference/Tables.md>)&#x20;
- [Indexes](<./SQL Reference/Data Definition Language _DDL_ Statement Reference/Indexes.md>)&#x20;
- [Data Pipelines](<./SQL Reference/Data Definition Language _DDL_ Statement Reference/Data Pipelines.md>)&#x20;
- [Distributed Tasks](<./SQL Reference/Data Definition Language _DDL_ Statement Reference/Distributed Tasks.md>)&#x20;
- [Machine Learning Models](<./SQL Reference/Data Definition Language _DDL_ Statement Reference/Machine Learning Models.md>)&#x20;
- [Users, Groups, and Service Classes](<./SQL Reference/Data Definition Language _DDL_ Statement Reference/Users_ Groups_ and Service Classes.md>)&#x20;
- [Data Integrity and Storage](<./SQL Reference/Data Definition Language _DDL_ Statement Reference/Data Integrity and Storage.md>)&#x20;
- [Query Analysis](<./SQL Reference/Data Definition Language _DDL_ Statement Reference/Query Analysis.md>)&#x20;
- [Query Management](<./SQL Reference/Data Definition Language _DDL_ Statement Reference/Query Management.md>)&#x20;
- [Statistics Cache Management](<./SQL Reference/Data Definition Language _DDL_ Statement Reference/Statistics Cache Management.md>)&#x20;

## **DCL SQL Statements**

- [Data Control Language (DCL) Statement Reference](<./SQL Reference/Data Control Language _DCL_ Statement Reference.md>)&#x20;

## **Machine Learning Execution**

- [Machine Learning Model Functions](<./SQL Reference/Machine Learning Model Functions.md>)&#x20;

## **Other SQL Reference**

- [Errors and Warnings](<./SQL Reference/Errors and Warnings.md>) &#x20;
- [Reserved Words]()&#x20;
- [System Catalog](<./SQL Reference/System Catalog Reference/System Catalog.md>)&#x20;

