SQL syntax supported by MariaDB ColumnStore
| Title | Description |
|---|---|
| ColumnStore Naming Conventions | Maximum lengths and naming conventions |
| ColumnStore Data Types | Data types supported by ColumnStore |
| ColumnStore Distributed Aggregate Functions | MariaDB ColumnStore supports the following aggregate functions, these can b... |
| ColumnStore Distributed Functions | Functions supported by ColumnStore |
| ColumnStore Non-Distributed Post-Processed Functions | Functions where data is returned by ColumnStore first, then executed by MariaDB |
| ColumnStore Information Functions | Functions MariaDB ColumnStore Information Functions are selectable pseudo ... |
| ColumnStore Conditions | Conditions are combinations of expressions and operators that return TRUE, FALSE or NULL |
| ColumnStore Data Definition Statements | SQL statements for defining data, such as ALTER, CREATE, DROP, RENAME etc |
| ColumnStore Data Manipulation Statements | Statements for querying and manipulating data, such as SELECT, UPDATE, DELETE etc |
| ColumnStore Window Functions | Introduction MariaDB ColumnStore provides support for window functions bro... |
| ColumnStore Operating Mode | ColumnStore can support full MariaDB query syntax through an operating mode |
| ColumnStore Decimal Math and Scale | ColumnStore can support varied internal precision on decimal calculations |
| ColumnStore Compression Mode | ColumnStore has the ability to compress data |
| ColumnStore Partition Management | Partition Management SQL Commands to view, drop, disable, and enable partitions |
| ColumnStore Information Schema Tables | ColumnStore-related Information Schema tables |
| ColumnStore User Defined Functions | ColumnStore User Defined Functions (UDF) overview and how-to. |
| ColumnStore User Defined Aggregate and Window Functions | Introduction Starting with MariaDB ColumnStore 1.1, the ability to create ... |
| ColumnStore Commit | Make changes to a table permanent |
| ColumnStore Drop Procedure | Deletes a stored procedure from ColumnStore |
| ColumnStore Rename Table | Renames one or more ColumnStore tables |
| ColumnStore Rollback | Undoes transactions that have not been permanently saved with the COMMIT statement |
| ColumnStore Utility Functions | MariaDB ColumnStore Utility Functions are a set of simple functions that re... |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/columnstore-sql-structure-and-commands/