SQL Reference¶
MatrixOne Intelligence is a platform for data and AI applications that combines AI Studio, MatrixOne, and Genesis. MatrixOne is the database foundation of MatrixOne Intelligence, providing data storage, SQL queries, and related computation.
This reference covers MatrixOne SQL structure and syntax, data types, statements, functions, operators, system variables, system tables, privileges, and limitations. Each topic overview links to detailed pages with syntax, parameters, examples, and limitations.
Scope¶
Use this reference when executing SQL against a MatrixOne database instance. SQL executed through AI Studio also follows the capabilities of the underlying engine, subject to the operations and permissions available through that platform entry point. Support in the database engine does not mean that every AI Studio entry point exposes the same operations.
MatrixOne SQL privileges and AI Studio workspace and feature permissions are configured separately. Creating a table through the AI Studio SQL editor does not automatically register it in Catalog. To manage a table in Catalog, follow the creation or import instructions in the SQL editor guide.
Documentation version 5.0 refers to the MatrixOne Intelligence manual version. SQL capabilities depend on the MatrixOne engine version and configuration of the instance. MatrixOne uses a MySQL-compatible protocol; consult MatrixOne documentation for its syntax, functions, and limitations.
Pages in This Section¶
Page |
Content |
|---|---|
Comments, identifiers, reserved keywords |
|
Numeric, string, time, JSON, VECTOR, and other types |
|
Categories and detailed references for DDL, DML, DQL, DCL, transactions, and administrative statements |
|
Function tables and detailed parameters, return values, and examples |
|
Arithmetic, comparison, logical, bitwise, conversion, control flow, and precedence |
|
Global / session variables and commonly used variables |
|
System databases such as |
|
List of SQL privileges within a tenant |
|
Detailed support information for LOAD DATA, partitions, and JDBC |
How to Use This Section with the Guides¶
What you want to do |
Where to go |
|---|---|
Create, connect to, monitor, and understand billing for an instance |
|
Configure users and roles in an instance |
|
AI Studio workspace roles and privilege points |
|
Execute SQL in AI Studio |