W3cubDocs

/MariaDB

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.

© 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/