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

Y

DROP TABLE

Y

CREATE INDEX

Y

DROP INDEX

Y

MODIFY COLUMN

Y

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 TABLES

Y

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

Data Version Management

Data Version Management

Supported(Y)/Not supported (N) /Experimental (E)

Snapshot and restore

Y

Point-in-time recovery (PITR)

Y

Create and delete data branches

Y

Compare, pick, and merge branch changes

Y

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

Y

Spatial Type

GEOMETRY/GEOMETRY32

Y

Array Type

ARRAY

Y, with element-type restrictions

Bitmap Type

BITMAP

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

Full-Text Index

Y

Vector Indexes (IVF)

Y

Vector Indexes (HNSW)

E, requires experimental_hnsw_index

Vector Indexes (CAGRA)

E, requires a GPU environment and experimental_cagra_index

Vector Indexes (IVFPQ)

E, requires a GPU environment and experimental_ivfpq_index

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, default mode

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

Vector Functions

Y

Geospatial 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)

E

RANGE COLUMNS

E

LIST

E

LIST COLUMNS

E

Import and Export

Import and Export

Supported(Y)/Not supported (N) /Experimental (E)

INSERT INTO

Y

SQL Import SOURCE

Y

File Import LOAD DATA INFILE

Y

Stream Import LOAD DATA INLINE

Y

Load data from S3

Y

mo-dump tool export SQL/CSV

Y

SELECT INTO export CSV/JSON

Y

mysqldump native tool

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

Primary and backup disaster recovery

Y, only supports cold backup

Management Tool

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 Intelligence, supports AWS and Alibaba Cloud |

Application Connectors and Common ORMs

Application Connector

Supported(Y)/Not supported (N)

JDBC

Y

ODBC

N

pymysql

Y

go-sql-driver

Y

MyBatis

Y

MyBatis-plus

Y

Spring-JPA

Y

Hibernate

Y

GORM

Y

SQL Alchemy

Y

Note: Application connectors or ORM tools not listed above are not necessarily unsupported. MatrixOne itself is highly compatible with MySQL 8.0. Established tools that work with MySQL can generally adapt to MatrixOne. Try connecting with MySQL-compatible configurations first.

Ecosystem Tool Adapters

Tool Category

Tool Name

Supported(Y)/Not supported (N)

Database Management IDE

Navicat

Y

MySQL Workbench

Y

DBeaver

Y

HeidiSQL

Y

SQLyog

Y

ETL Tools

DataX

Y

Canal

Y

Kettle

Y

Seatunnel

Y

FlinkCDC

Y

Message Queue

Kafka

Y

Compute Engine

Spark

Y

Flink

Y

BI Tools

Superset

Y

Tableau

Y

FineBI

Y

Yonghong BI

Y

Datafor

Y

Data Scheduling

DolphinScheduler

Y

Visual Monitoring

Grafana

Y

Note: Ecosystem tools not listed above are not necessarily unsupported. MatrixOne is highly compatible with MySQL 8.0. Tools that work with MySQL generally work with MatrixOne.