ColumnStore SQL Structure and Commands
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... |
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
© 2021 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/