MatrixOne Features
This document lists the features supported by the latest version of MatrixOne and features that are common and in MatrixOne’s roadmap but not currently supported.
Data definition language (DDL)
| Data definition Language(DDL) | Supported(Y)/Not supported (N) /Experimental (E) |
|---|
| CREATE DATABASE | Y |
| DROP DATABASE | Y |
| ALTER DATABASE | N |
| CREATE TABLE | Y |
| ALTER TABLE | E, The clauses: CHANGE [COLUMN], MODIFY [COLUMN], RENAME COLUMN, ADD [CONSTRAINT [symbol]] PRIMARY KEY, DROP PRIMARY KEY, and ALTER COLUMN ORDER BY can be used in ALTER It can be freely combined in the TABLE statement. Still, it is not supported to be used with other clauses for the time being. |
| RENAME TABLE | N, Can be replaced by ALTER TABLE tbl RENAME TO new_tbl |
| DROP TABLE | Y |
| CREATE INDEX | Y, Secondary indexes have no speedup |
| DROP INDEX | Y |
| MODIFY COLUMN | N |
| PRIMARY KEY | Y |
| CREATE VIEW | Y |
| ALTER VIEW | Y |
| DROP VIEW | Y |
| TRUNCATE TABLE | Y |
| AUTO_INCREMENT | Y |
| SEQUENCE | Y |
| TEMPORARY TABLE | Y |
| CREATE STREAM | E, Only some types are supported |
| PARTITION BY | E, Only some types are supported |
| CHARSET, COLLATION | N, Only UTF8 is supported by default |
Data manipulation/query language (DML/DQL)
| SQL Statement | Supported(Y)/Not supported (N) /Experimental (E) |
|---|
| SELECT | Y |
| INSERT | Y |
| UPDATE | Y |
| DELETE | Y |
| REPLACE | Y |
| INSERT ON DUPLICATE KEY UPDATE | Y |
| LOAD DATA | Y |
| SELECT INTO | Y |
| INNER/LEFT/RIGHT/OUTER JOIN | Y |
| UNION, UNION ALL | Y |
| EXCEPT, INTERSECT | Y |
| GROUP BY, ORDER BY | Y |
| CLUSTER BY | Y |
| SUBQUERY | Y |
| (Common Table Expressions, CTE) | Y |
| BEGIN/START TRANSACTION, COMMIT, ROLLBACK | Y |
| EXPLAIN | Y |
| EXPLAIN ANALYZE | Y |
| LOCK/UNLOCK TABLE | N |
| User-defined Variables | Y |
Advanced SQL Features
| Advanced SQL Features | Supported(Y)/Not supported (N) /Experimental (E) |
|---|
| PREPARE | Y |
| STORED PROCEDURE | N |
| TRIGGER | N |
| EVENT SCHEDULER | N |
| UDF | N |
| Materialized VIEW | N |
Data types
| Data type categories | Data types | Supported(Y)/Not supported (N) /Experimental (E) |
|---|
| Integer Numbers | TINYINT/SMALLINT/INT/BIGINT (UNSIGNED) | Y |
| BIT | N |
| Real Numbers | FLOAT | Y |
| DOUBLE | Y |
| String Types | CHAR | Y |
| VARCHAR | Y |
| BINARY | Y |
| VARBINARY | Y |
| TINYTEXT/TEXT/MEDIUMTEXT/LONGTEXT | Y |
| ENUM | Y, Not support Filtering ENUM values and Sorting ENUM values |
| SET | N |
| Binary Types | TINYBLOB/BLOB/MEDIUMBLOB/LONGBLOB | Y |
| Time and Date Types | DATE | Y |
| TIME | Y |
| DATETIME | Y |
| TIMESTAMP | Y |
| YEAR | Y |
| Boolean | BOOL | Y |
| Decimal Types | DECIMAL | Y, up to 38 digits |
| JSON Types | JSON | Y |
| vector type | VECTOR | N |
| Spatial Type | SPATIAL | N |
Indexing and constraints
| Indexing and constraints | Supported(Y)/Not supported (N) /Experimental (E) |
|---|
| PRIMARY KEY | Y |
| Composite PRIMARY KEY | Y |
| UNIQUE KEY | Y |
| Secondary KEY | Y, Syntax only implementation |
| FOREIGN KEY | Y |
| Enforced Constraints on Invalid Data | Y |
| ENUM and SET Constraints | N |
| NOT NULL Constraint | Y |
| AUTO INCREMENT Constraint | Y |
Transactions
| Transactions | Supported(Y)/Not supported (N) /Experimental (E) |
|---|
| Pessimistic transactions | Y |
| Optimistic transactions | Y |
| Distributed Transaction | Y |
| Snapshot Isolation | Y |
| READ COMMITTED | Y |
Functions and Operators
| Functions and Operators Categories | Supported(Y)/Not supported (N) /Experimental (E) |
|---|
| Aggregate Functions | Y |
| Mathematical | Y |
| Datetime | Y |
| String | Y |
| CAST | Y |
| Flow Control Functions | E |
| Window Functions | Y |
| JSON Functions | Y |
| System Functions | Y |
| Other Functions | Y |
| Operators | Y |
PARTITION
| PARTITION | Supported(Y)/Not supported (N) /Experimental (E) |
|---|
| KEY(column_list) | E |
| HASH(expr) | E |
| RANGE(expr) | N |
| RANGE COLUMNS | N |
| LIST | N |
| LIST COLUMNS | N |
Import and Export
| Import and Export | Supported(Y)/Not supported (N) /Experimental (E) |
|---|
| LOAD DATA | Y |
| SOURCE | Y |
| Load data from S3 | Y |
| modump | Y |
| mysqldump | N |
Security and Access Control
| Security | Supported(Y)/Not supported (N) /Experimental (E) |
|---|
| Transport Layer Encryption TLS | Y |
| Encryption at rest | Y |
| Import from Object Storage | Y |
| Role-Based Access Control (RBAC) | Y |
| Multi-Account | Y |
Backup and Restore
| Backup and Restore | Supported(Y)/Not supported (N) /Experimental (E) |
|---|
| Logical Backup and Restore | Y, Only the modump tool is supported |
| Physical Backup and Restore | Y |
| Management Tool | Supported(Y)/Not supported (N) /Experimental (E) |
|---|
| Stand-alone mo_ctl deployment management | Y |
| Distributed mo_ctl deployment management | E, Enterprise Edition only |
| Visual management platform | E, Public cloud version only |
| System Logging | Y |
| System indicator monitoring | Y |
| Slow query log | Y |
| SQL record | Y |
| Kubernetes operator | Y |
Deployment Method
| Deployment Method | Supported(Y)/Not supported (N) /Experimental (E) |
|---|
| Stand-alone environment privatization deployment | Y |
| Distributed environment privatization deployment | Y, self-built Kubernetes and minIO object storage |
| Alibaba Cloud distributed self-built deployment | Y, ACK+OSS |
| Tencent Cloud Distributed Self-built Deployment | Y, TKE+COS |
| AWS distributed self-built deployment | Y, EKS+S3 |
| Public Cloud Serverless | Y, MatrixOne Cloud, Support AWS, Alibaba Cloud |
我的书签
添加书签
移除书签
