# Reference

- [ColumnStore Commit](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/5568.md)
- [ColumnStore Drop Procedure](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/5571.md)
- [ColumnStore Rename Table](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/5573.md)
- [ColumnStore Rollback](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/5574.md)
- [ColumnStore Compression Mode](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/columnstore-compression-mode.md)
- [ColumnStore Conditions](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/columnstore-conditions.md)
- [ColumnStore Data Types](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/columnstore-data-types.md)
- [ColumnStore Decimal Math and Scale](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/columnstore-decimal-math-and-scale.md)
- [ColumnStore Distributed Aggregate Functions](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/columnstore-distributed-aggregate-functions.md)
- [ColumnStore Distributed Functions](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/columnstore-distributed-functions.md)
- [ColumnStore Information Functions](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/columnstore-information-functions.md)
- [ColumnStore Information Schema Tables](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/columnstore-information-schema-tables.md)
- [ColumnStore Naming Conventions](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/columnstore-naming-conventions.md)
- [ColumnStore Non-Distributed Post-Processed Functions](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/columnstore-non-distributed-post-processed-functions.md)
- [ColumnStore Operating Mode](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/columnstore-operating-mode.md)
- [ColumnStore User Defined Aggregate and Window Functions](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/columnstore-user-defined-aggregate-and-window-functions.md)
- [ColumnStore User Defined Functions](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/columnstore-user-defined-functions.md)
- [ColumnStore Utility Functions](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/columnstore-utility-functions.md)
- [ColumnStore Window Functions](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/columnstore-window-functions.md)
- [ColumnStore Data Definition Statements](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-definition-statements.md): You can use most normal statements from the MariaDB data definition language (DDL) with ColumnStore tables. This section lists DDL that differs for ColumnStore compared to normal MariaDB usage.
- [ColumnStore ALTER TABLE](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-definition-statements/columnstore-alter-table.md)
- [ColumnStore ALTER VIEW](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-definition-statements/columnstore-alter-view.md)
- [ColumnStore CREATE PROCEDURE](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-definition-statements/columnstore-create-procedure.md)
- [ColumnStore CREATE TABLE](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-definition-statements/columnstore-create-table.md)
- [ColumnStore CREATE VIEW](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-definition-statements/columnstore-create-view.md)
- [ColumnStore DROP TABLE](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-definition-statements/columnstore-drop-table.md)
- [DDL Statements Different in ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-definition-statements/ddl-statements-that-differ-for-columnstore.md)
- [ColumnStore Data Manipulation Statements](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-manipulation-statements.md): Learn data manipulation statements for MariaDB ColumnStore. This section covers INSERT, UPDATE, DELETE, and LOAD DATA operations, optimized for efficient handling of large analytical datasets.
- [ColumnStore DELETE](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-manipulation-statements/columnstore-delete.md)
- [ColumnStore Disk-Based Joins](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-manipulation-statements/columnstore-disk-based-joins.md)
- [ColumnStore INSERT](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-manipulation-statements/columnstore-insert.md)
- [ColumnStore LOAD DATA INFILE](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-manipulation-statements/columnstore-load-data-infile.md)
- [ColumnStore SELECT](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-manipulation-statements/columnstore-select.md)
- [ColumnStore UPDATE](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-manipulation-statements/columnstore-update.md)
- [CMAPI](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/cmapi.md)
- [mode-set](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/cmapi/mode-set.md)
- [node DELETE](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/cmapi/node-delete.md)
- [node PUT](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/cmapi/node-put.md)
- [shutdown](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/cmapi/shutdown.md)
- [start](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/cmapi/start.md)
- [status](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/cmapi/status.md)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/analytics/mariadb-columnstore/reference.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.