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
Y
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
Y
Materialized VIEW
N
Stream Calculation
Stream Computing Capabilities
Supported (Y) / Not Supported (N) / Experimental Features (E)
Dynamic Tables
E
Kafka Connectors
E
Materialized View
N
(incremental) Materialized View
N
Timing
Timing
Supported (Y) / Not Supported (N) / Experimental Features (E)
Timing Table
Y
Sliding window
Y
Downsampling
Y
Interpolation
Y
TTL(Time To Live)
N
ROLLUP
Y
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 Recovery
Supported (Y)/Not Supported (N)/Experimental (E)
Logical backup recovery
Y, only supports mo-dump tool
Physical backup recovery
Y, only supports mobackup tool
Snapshot backup and recovery
Y, supports mobackup tool and SQL
PITR
Y, supports mobackup tool and SQL
CDC synchronization
Y, only supports matrixone to mysql, supports mo_cdc tool