# Ocient Documentation

> Documentation for setup, integration, administration, querying, loading, and reference material for the OcientAIQ Unified Data Platform.

## Docs

- [Aggregate Functions](https://docs.ocient.com/aggregate-functions.md)
- [Air-Gapped Environment with an Ocient System](https://docs.ocient.com/air-gapped-environment-with-an-ocient-system.md)
- [Alphabetical SQL Functions List](https://docs.ocient.com/alphabetical-sql-functions-list.md)
- [Alter Default Data Pipeline Behavior](https://docs.ocient.com/alter-default-data-pipeline-behavior.md)
- [Amazon Web Services Ocient Installation](https://docs.ocient.com/amazon-web-services-ocient-installation.md)
- [callback](https://docs.ocient.com/api-playgrounds/ocient-http-query-api/get-callback.md): Provides the authentication token for the OpenID Connect authentication process. The authorization server redirects to callback path after successful authentication.
- [execute](https://docs.ocient.com/api-playgrounds/ocient-http-query-api/get-execute.md): Alternative GET method for executing SQL statements. This method passes parameters as URL query parameters. This method does not support the params body parameter.
- [info](https://docs.ocient.com/api-playgrounds/ocient-http-query-api/get-info.md): Returns basic system version information about the Ocient System and the HTTP Query API server.
- [execute](https://docs.ocient.com/api-playgrounds/ocient-http-query-api/post-execute.md): Executes a SQL statement and returns the results. Supports requests for both regular and streaming responses.
- [login](https://docs.ocient.com/api-playgrounds/ocient-http-query-api/post-login.md): Authenticates a user with a username and password and then returns a token for use in subsequent API calls. This request also sets a session cookie.
- [logout](https://docs.ocient.com/api-playgrounds/ocient-http-query-api/post-logout.md): Log out from a SQL session. This clears any associated cookies, but does not invalidate any access tokens.
- [sso_authentication](https://docs.ocient.com/api-playgrounds/ocient-http-query-api/post-sso-authentication.md): Initiates the OpenID Connect authentication process by redirecting to the authorization server.
- [sso_device_grant](https://docs.ocient.com/api-playgrounds/ocient-http-query-api/post-sso-device-grant.md): Retrieve an OpenID device grant code that the Ocient System can verify and use with the sso_device_grant_verify endpoint.
- [sso_device_grant_verify](https://docs.ocient.com/api-playgrounds/ocient-http-query-api/post-sso-device-grant-verify.md): Verify a previous device grant request and return an authorization token.
- [sso_token](https://docs.ocient.com/api-playgrounds/ocient-http-query-api/post-sso-token.md): Exchange an OpenID Connect identifier token or access token for an Ocient access token.
- [token_refresh](https://docs.ocient.com/api-playgrounds/ocient-http-query-api/post-token-refresh.md): Refreshes an existing access token, extending its validity period. Call this endpoint before the current token expires to maintain uninterrupted access.
- [Get Configuration](https://docs.ocient.com/api-playgrounds/system-information-rest-endpoints/get-configuration.md): Retrieve the configuration about this node in JSON format.
- [Get Configuration of Whole System](https://docs.ocient.com/api-playgrounds/system-information-rest-endpoints/get-configuration-of-whole-system.md): Retrieve the configuration of the system as a whole in JSON format.
- [Get Configuration Parameters](https://docs.ocient.com/api-playgrounds/system-information-rest-endpoints/get-configuration-parameters.md): Retrieve values of configuration parameters.
- [Get Statistics](https://docs.ocient.com/api-playgrounds/system-information-rest-endpoints/get-statistics.md): Retrieve the statistics on each node in the database.
- [Get Status](https://docs.ocient.com/api-playgrounds/system-information-rest-endpoints/get-status.md): Retrieve the status of the software running.
- [Get Version](https://docs.ocient.com/api-playgrounds/system-information-rest-endpoints/get-version.md): Retrieve the version of the software running.
- [Array Functions and Operators](https://docs.ocient.com/array-functions-and-operators.md)
- [Array, Tuple, and Matrix Overview](https://docs.ocient.com/array-tuple-and-matrix-overview.md)
- [Attribute Functions](https://docs.ocient.com/attribute-functions.md)
- [Authentication Methods](https://docs.ocient.com/authentication-methods.md)
- [Backup and Restore](https://docs.ocient.com/backup-and-restore.md)
- [Categorized SQL Functions List](https://docs.ocient.com/categorized-sql-functions-list.md)
- [Character and Binary Functions](https://docs.ocient.com/character-and-binary-functions.md)
- [Checking System After Configuration](https://docs.ocient.com/checking-system-after-configuration.md)
- [Checking System Configuration Before Bootstrapping](https://docs.ocient.com/checking-system-configuration-before-bootstrapping.md)
- [Classification Analysis](https://docs.ocient.com/classification-analysis.md)
- [Classification Models](https://docs.ocient.com/classification-models.md)
- [Cluster and Node Management](https://docs.ocient.com/cluster-and-node-management.md)
- [Clustering Analysis and Dimensionality Reduction](https://docs.ocient.com/clustering-analysis-and-dimensionality-reduction.md)
- [Clustering and Dimension Reduction Models](https://docs.ocient.com/clustering-and-dimension-reduction-models.md)
- [Commands Supported by the Ocient JDBC CLI Program](https://docs.ocient.com/commands-supported-by-the-ocient-jdbc-cli-program.md)
- [Compute-Adjacent Input and Output on Large Working Sets](https://docs.ocient.com/compute-adjacent-input-and-output-on-large-working-sets.md)
- [Configuration Settings for Data Pipelines](https://docs.ocient.com/configuration-settings-for-data-pipelines.md)
- [Configure Data Pipeline Logging](https://docs.ocient.com/configure-data-pipeline-logging.md)
- [Configure Storage Spaces](https://docs.ocient.com/configure-storage-spaces.md)
- [Connect to Ocient](https://docs.ocient.com/connect-to-ocient.md)
- [Connect Using JDBC](https://docs.ocient.com/connect-using-jdbc.md)
- [Connect Using pyocient](https://docs.ocient.com/connect-using-pyocient.md)
- [Connection Driver Reference](https://docs.ocient.com/connection-driver-reference.md)
- [Conversion Functions](https://docs.ocient.com/conversion-functions.md)
- [Core Elements of an Ocient System](https://docs.ocient.com/core-elements-of-an-ocient-system.md)
- [CREATE TABLE SQL Statement Examples](https://docs.ocient.com/create-table-sql-statement-examples.md)
- [Data Control Language (DCL) Statement Reference](https://docs.ocient.com/data-control-language-dcl-statement-reference.md)
- [Data Definition Language (DDL) Statement Reference](https://docs.ocient.com/data-definition-language-ddl-statement-reference.md)
- [Data Extract Tool](https://docs.ocient.com/data-extract-tool.md)
- [Data Formats for Data Pipelines](https://docs.ocient.com/data-formats-for-data-pipelines.md)
- [Data Integrity and Storage](https://docs.ocient.com/data-integrity-and-storage.md)
- [Data Pipeline Behavior Considerations](https://docs.ocient.com/data-pipeline-behavior-considerations.md)
- [Data Pipeline Load of CSV Data from S3](https://docs.ocient.com/data-pipeline-load-of-csv-data-from-s3.md)
- [Data Pipeline Load of JSON Data from HDFS](https://docs.ocient.com/data-pipeline-load-of-json-data-from-hdfs.md)
- [Data Pipeline Load of JSON Data from Kafka](https://docs.ocient.com/data-pipeline-load-of-json-data-from-kafka.md)
- [Data Pipeline Load of Parquet Data from S3](https://docs.ocient.com/data-pipeline-load-of-parquet-data-from-s3.md)
- [Data Pipeline Loading Errors](https://docs.ocient.com/data-pipeline-loading-errors.md)
- [Data Pipelines](https://docs.ocient.com/data-pipelines.md)
- [Data Preparation](https://docs.ocient.com/data-preparation.md)
- [Data Types](https://docs.ocient.com/data-types.md)
- [Data Types for Data Pipelines](https://docs.ocient.com/data-types-for-data-pipelines.md)
- [Data Types for User-Defined Data Pipeline Functions](https://docs.ocient.com/data-types-for-user-defined-data-pipeline-functions.md)
- [Database Administration](https://docs.ocient.com/database-administration.md)
- [Database Password Security Settings](https://docs.ocient.com/database-password-security-settings.md)
- [Databases](https://docs.ocient.com/databases.md)
- [Date and Time Functions](https://docs.ocient.com/date-and-time-functions.md)
- [DBeaver Integration](https://docs.ocient.com/dbeaver-integration.md)
- [Deduplication in Data Pipelines](https://docs.ocient.com/deduplication-in-data-pipelines.md)
- [Discover Insights From System Catalog Tables](https://docs.ocient.com/discover-insights-from-system-catalog-tables.md)
- [Distributed Tasks](https://docs.ocient.com/distributed-tasks.md)
- [Download](https://docs.ocient.com/download.md)
- [Ensemble Models](https://docs.ocient.com/ensemble-models.md)
- [Error Tolerance in Data Pipelines](https://docs.ocient.com/error-tolerance-in-data-pipelines.md)
- [Errors and Warnings](https://docs.ocient.com/errors-and-warnings.md)
- [Exabyte Scalability Design](https://docs.ocient.com/exabyte-scalability-design.md)
- [Expand and Rebalance System](https://docs.ocient.com/expand-and-rebalance-system.md)
- [Formatting Functions](https://docs.ocient.com/formatting-functions.md)
- [Frequently Asked Questions for Data Pipelines](https://docs.ocient.com/frequently-asked-questions-for-data-pipelines.md)
- [Functions Overview](https://docs.ocient.com/functions-overview.md)
- [General SQL Syntax](https://docs.ocient.com/general-sql-syntax.md)
- [Generate Tables Using sys.dummy](https://docs.ocient.com/generate-tables-using-sys-dummy.md)
- [Geospatial Functions](https://docs.ocient.com/geospatial-functions.md)
- [Global Dictionary Compression](https://docs.ocient.com/global-dictionary-compression.md)
- [Glossary](https://docs.ocient.com/glossary.md)
- [Guide to Rebuilding Segments](https://docs.ocient.com/guide-to-rebuilding-segments.md)
- [HyperLogLog Functions](https://docs.ocient.com/hyperloglog-functions.md)
- [Identifiers](https://docs.ocient.com/identifiers.md)
- [Get Started with the OcientAIQ Unified Data Platform](https://docs.ocient.com/index.md)
- [Indexes](https://docs.ocient.com/indexes.md)
- [Information Schema](https://docs.ocient.com/information-schema.md)
- [Ingest Data with Legacy LAT Reference](https://docs.ocient.com/ingest-data-with-legacy-lat-reference.md)
- [Inspect the Current Configuration](https://docs.ocient.com/inspect-the-current-configuration.md)
- [Install an Ocient System](https://docs.ocient.com/install-an-ocient-system.md)
- [Install LAT Client in a Disconnected Network](https://docs.ocient.com/install-lat-client-in-a-disconnected-network.md)
- [Installation Reference](https://docs.ocient.com/installation-reference.md)
- [JDBC Classes and Methods](https://docs.ocient.com/jdbc-classes-and-methods.md)
- [JDBC Manual](https://docs.ocient.com/jdbc-manual.md)
- [JDBC Release Notes](https://docs.ocient.com/jdbc-release-notes.md)
- [JDBC Spark Connector](https://docs.ocient.com/jdbc-spark-connector.md)
- [Join Operations](https://docs.ocient.com/join-operations.md)
- [JSON Selectors Examples in Data Pipelines](https://docs.ocient.com/json-selectors-examples-in-data-pipelines.md)
- [Key Concepts](https://docs.ocient.com/key-concepts.md)
- [LAT Advanced Loading and Transformations](https://docs.ocient.com/lat-advanced-loading-and-transformations.md)
- [LAT Advanced Topics](https://docs.ocient.com/lat-advanced-topics.md)
- [LAT Client Command Line Interface](https://docs.ocient.com/lat-client-command-line-interface.md)
- [LAT Data Transformation with JMESPath](https://docs.ocient.com/lat-data-transformation-with-jmespath.md)
- [LAT Data Types in Loading](https://docs.ocient.com/lat-data-types-in-loading.md)
- [LAT Extract Configuration](https://docs.ocient.com/lat-extract-configuration.md)
- [LAT Load CSV Data from S3](https://docs.ocient.com/lat-load-csv-data-from-s3.md)
- [LAT Load JSON Data from Kafka](https://docs.ocient.com/lat-load-json-data-from-kafka.md)
- [LAT Load JSON Data from S3](https://docs.ocient.com/lat-load-json-data-from-s3.md)
- [LAT Log4J Configuration](https://docs.ocient.com/lat-log4j-configuration.md)
- [LAT Metrics](https://docs.ocient.com/lat-metrics.md)
- [LAT Overview](https://docs.ocient.com/lat-overview.md)
- [LAT Packaging and Installation](https://docs.ocient.com/lat-packaging-and-installation.md)
- [LAT Pipeline Configuration](https://docs.ocient.com/lat-pipeline-configuration.md)
- [LAT Record Filtering](https://docs.ocient.com/lat-record-filtering.md)
- [LAT Service Configuration](https://docs.ocient.com/lat-service-configuration.md)
- [LAT Sink Configuration](https://docs.ocient.com/lat-sink-configuration.md)
- [LAT Source Configuration](https://docs.ocient.com/lat-source-configuration.md)
- [LAT Transform Configuration](https://docs.ocient.com/lat-transform-configuration.md)
- [LAT Transformation Functions](https://docs.ocient.com/lat-transformation-functions.md)
- [LAT User-Defined Transformations](https://docs.ocient.com/lat-user-defined-transformations.md)
- [Linestring Constructors](https://docs.ocient.com/linestring-constructors.md)
- [Linestring Functions](https://docs.ocient.com/linestring-functions.md)
- [Load and Analyze Data](https://docs.ocient.com/load-and-analyze-data.md)
- [Load Data](https://docs.ocient.com/load-data.md)
- [Load Data from External Sources in Data Pipelines](https://docs.ocient.com/load-data-from-external-sources-in-data-pipelines.md)
- [Load Data into Multiple Targets in Data Pipelines](https://docs.ocient.com/load-data-into-multiple-targets-in-data-pipelines.md)
- [Load Data with a User-Defined Data Pipeline Function](https://docs.ocient.com/load-data-with-a-user-defined-data-pipeline-function.md)
- [Load Geospatial Data in Data Pipelines](https://docs.ocient.com/load-geospatial-data-in-data-pipelines.md)
- [Load Metadata and File-Based Partitioned Data in Data Pipelines](https://docs.ocient.com/load-metadata-and-file-based-partitioned-data-in-data-pipelines.md)
- [Loading Characteristics and Concepts](https://docs.ocient.com/loading-characteristics-and-concepts.md)
- [Log Monitoring](https://docs.ocient.com/log-monitoring.md)
- [Looker Connector](https://docs.ocient.com/looker-connector.md)
- [Machine Learning in Ocient](https://docs.ocient.com/machine-learning-in-ocient.md)
- [Machine Learning Model Functions](https://docs.ocient.com/machine-learning-model-functions.md)
- [Machine Learning Model Options](https://docs.ocient.com/machine-learning-model-options.md)
- [Machine Learning Models](https://docs.ocient.com/machine-learning-models.md)
- [Maintenance Overview](https://docs.ocient.com/maintenance-overview.md)
- [Manage Distributed Tasks](https://docs.ocient.com/manage-distributed-tasks.md)
- [Manage Errors in Data Pipelines](https://docs.ocient.com/manage-errors-in-data-pipelines.md)
- [Manage the Network Configuration of an Ocient System](https://docs.ocient.com/manage-the-network-configuration-of-an-ocient-system.md)
- [Manage Users, Groups, and Roles](https://docs.ocient.com/manage-users-groups-and-roles.md)
- [Math Functions and Operators](https://docs.ocient.com/math-functions-and-operators.md)
- [Matrix Functions and Operators](https://docs.ocient.com/matrix-functions-and-operators.md)
- [Metabase Integration](https://docs.ocient.com/metabase-integration.md)
- [Monitor Data Pipelines](https://docs.ocient.com/monitor-data-pipelines.md)
- [Monitor Segment Group Transfers](https://docs.ocient.com/monitor-segment-group-transfers.md)
- [Multiple Storage Clusters for Loading Data](https://docs.ocient.com/multiple-storage-clusters-for-loading-data.md)
- [Network Type Functions](https://docs.ocient.com/network-type-functions.md)
- [Node Bootstrapping Reference](https://docs.ocient.com/node-bootstrapping-reference.md)
- [Node Configuration with the Administrator Role](https://docs.ocient.com/node-configuration-with-the-administrator-role.md)
- [NVMe Drive Firmware Upgrade Process](https://docs.ocient.com/nvme-drive-firmware-upgrade-process.md)
- [Object-Type Level Privileges Management](https://docs.ocient.com/object-type-level-privileges-management.md)
- [OCGraph Java Library](https://docs.ocient.com/ocgraph-java-library.md)
- [OCGraph Python Library](https://docs.ocient.com/ocgraph-python-library.md)
- [Ocient Application Configuration](https://docs.ocient.com/ocient-application-configuration.md)
- [Ocient Application Installation](https://docs.ocient.com/ocient-application-installation.md)
- [Ocient Architecture](https://docs.ocient.com/ocient-architecture.md)
- [OcientAIQ Unified Data Platform Release Notes](https://docs.ocient.com/ocient-data-intelligence-platform-release-notes.md)
- [Ocient HTTP Query API](https://docs.ocient.com/ocient-http-query-api.md)
- [Ocient Integrations](https://docs.ocient.com/ocient-integrations.md)
- [Ocient Python Module: pyocient](https://docs.ocient.com/ocient-python-module-pyocient.md)
- [Ocient Security Guide](https://docs.ocient.com/ocient-security-guide.md)
- [Ocient Simulator](https://docs.ocient.com/ocient-simulator.md)
- [Ocient Software Upgrade](https://docs.ocient.com/ocient-software-upgrade.md)
- [Ocient System Bootstrapping](https://docs.ocient.com/ocient-system-bootstrapping.md)
- [Ocient System Hardware Specifications](https://docs.ocient.com/ocient-system-hardware-specifications.md)
- [Ocient System Requirements](https://docs.ocient.com/ocient-system-requirements.md)
- [Ocient System Sizing](https://docs.ocient.com/ocient-system-sizing.md)
- [Open Source Acknowledgments](https://docs.ocient.com/open-source-acknowledgments.md)
- [Operating System Configuration](https://docs.ocient.com/operating-system-configuration.md)
- [Other Functions and Expressions](https://docs.ocient.com/other-functions-and-expressions.md)
- [Other Models](https://docs.ocient.com/other-models.md)
- [Parquet Selectors Examples in Data Pipelines](https://docs.ocient.com/parquet-selectors-examples-in-data-pipelines.md)
- [Plan Optimization](https://docs.ocient.com/plan-optimization.md)
- [Point Constructors](https://docs.ocient.com/point-constructors.md)
- [Polygon Constructors](https://docs.ocient.com/polygon-constructors.md)
- [Power Safety Recommendations](https://docs.ocient.com/power-safety-recommendations.md)
- [pyocient Release Notes](https://docs.ocient.com/pyocient-release-notes.md)
- [Query Analysis](https://docs.ocient.com/query-analysis.md)
- [Query Management](https://docs.ocient.com/query-management.md)
- [Query Ocient](https://docs.ocient.com/query-ocient.md)
- [Query Performance Optimizations](https://docs.ocient.com/query-performance-optimizations.md)
- [Query Performance Tuning](https://docs.ocient.com/query-performance-tuning.md)
- [Quick Start Querying](https://docs.ocient.com/quick-start-querying.md)
- [Regression Analysis](https://docs.ocient.com/regression-analysis.md)
- [Regression Models](https://docs.ocient.com/regression-models.md)
- [Release Notes](https://docs.ocient.com/release-notes.md)
- [Remove Records from an Ocient System](https://docs.ocient.com/remove-records-from-an-ocient-system.md)
- [Replace an NVMe Node Drive](https://docs.ocient.com/replace-an-nvme-node-drive.md)
- [Replace Nodes](https://docs.ocient.com/replace-nodes.md)
- [Reserved Words](https://docs.ocient.com/reserved-words.md)
- [Result Set Caching](https://docs.ocient.com/result-set-caching.md)
- [Scalar Data Conversion Functions](https://docs.ocient.com/scalar-data-conversion-functions.md)
- [Schemas](https://docs.ocient.com/schemas.md)
- [Secondary Indexes](https://docs.ocient.com/secondary-indexes.md)
- [Secure Connections Using TLS](https://docs.ocient.com/secure-connections-using-tls.md)
- [Set Up Data Encryption](https://docs.ocient.com/set-up-data-encryption.md)
- [Set Up System Monitoring with the TIG Stack and Kapacitor](https://docs.ocient.com/set-up-system-monitoring-with-the-tig-stack-and-kapacitor.md)
- [Spatial Measurement](https://docs.ocient.com/spatial-measurement.md)
- [Spatial Operators](https://docs.ocient.com/spatial-operators.md)
- [Spatial Relationships](https://docs.ocient.com/spatial-relationships.md)
- [Spatiotemporal Measurement](https://docs.ocient.com/spatiotemporal-measurement.md)
- [Spatiotemporal Operators](https://docs.ocient.com/spatiotemporal-operators.md)
- [Special Data Pipeline Transformation Functions](https://docs.ocient.com/special-data-pipeline-transformation-functions.md)
- [SQL Reference](https://docs.ocient.com/sql-reference.md)
- [SQL Syntax Conventions](https://docs.ocient.com/sql-syntax-conventions.md)
- [SQLAlchemy Integration](https://docs.ocient.com/sqlalchemy-integration.md)
- [Startup and Shutdown Procedure](https://docs.ocient.com/startup-and-shutdown-procedure.md)
- [Statistics Cache Management](https://docs.ocient.com/statistics-cache-management.md)
- [Statistics Monitoring](https://docs.ocient.com/statistics-monitoring.md)
- [Superset Integration](https://docs.ocient.com/superset-integration.md)
- [System Administration](https://docs.ocient.com/system-administration.md)
- [System Catalog](https://docs.ocient.com/system-catalog.md)
- [System Catalog Reference](https://docs.ocient.com/system-catalog-reference.md)
- [System Information REST Endpoints](https://docs.ocient.com/system-information-rest-endpoints.md)
- [Table Compression Options](https://docs.ocient.com/table-compression-options.md)
- [Table Retention Policies](https://docs.ocient.com/table-retention-policies.md)
- [Tableau Integration](https://docs.ocient.com/tableau-integration.md)
- [Tables](https://docs.ocient.com/tables.md)
- [Text Analysis in Database Queries](https://docs.ocient.com/text-analysis-in-database-queries.md)
- [Time Zone Functions](https://docs.ocient.com/time-zone-functions.md)
- [TimeKeys and Clustering Keys](https://docs.ocient.com/timekeys-and-clustering-keys.md)
- [Transform Data in Data Pipelines](https://docs.ocient.com/transform-data-in-data-pipelines.md)
- [Tuple Functions and Operators](https://docs.ocient.com/tuple-functions-and-operators.md)
- [Understanding Data Types](https://docs.ocient.com/understanding-data-types.md)
- [Users, Groups, and Service Classes](https://docs.ocient.com/users-groups-and-service-classes.md)
- [Version Compatibility](https://docs.ocient.com/version-compatibility.md)
- [Views](https://docs.ocient.com/views.md)
- [Window Aggregate Functions](https://docs.ocient.com/window-aggregate-functions.md)
- [Work with AI Prompts](https://docs.ocient.com/work-with-ai-prompts.md)
- [Workload Management and Service Classes](https://docs.ocient.com/workload-management-and-service-classes.md)
- [Workload Management Walkthrough](https://docs.ocient.com/workload-management-walkthrough.md)

## OpenAPI Specs

- [xzu2ulvos3yqf969gbwpo-j6ibltoc4gyo2uzzph3yt-20241018-144135-42445ccd](https://docs.ocient.com/openapi/xzu2ulvos3yqf969gbwpo-j6ibltoc4gyo2uzzph3yt-20241018-144135-42445ccd.json)
- [xzu2ulvos3yqf969gbwpo-6fbu-thlb6sassx992he-20241018-144135-f43eac92](https://docs.ocient.com/openapi/xzu2ulvos3yqf969gbwpo-6fbu-thlb6sassx992he-20241018-144135-f43eac92.json)
- [generated-api-methods](https://docs.ocient.com/openapi/generated-api-methods.json)
- [openapi](https://docs.ocient.com/api-reference/openapi.json)