MatrixOne v21.0.1.0 Release Notes
We are excited to announce the first release of MatrixOne v21.0.1.0 on 2021/10/24. Cheers!
Docker
docker pull matrixorigin/matrixone:0.1.0
Features
SQL
Following SQL statements are supported in this release.
DDL
- CREATE / DROP DATABASE
- CREATE / DROP TABLE
DML
- INSERT
- LOAD DATA
- SELECT
- WHERE
- GROUP BY
- ORDER BY
- LIMIT, OFFSET
- SHOW
- DATABASES
- TABLES
- USE
Data Types
- TINYINT / SMALLINT / INT / BIGINT, SIGNED / UNSIGNED
- FLOAT / DOUBLE
- CHAR / VARCHAR
Operators
- <, >=, <, <=, <>, !=, =
- BETWEEN … AND …, NOT BETWEEN … AND …
- AND, &&, OR, ||
- +, -, *, /, %, MOD, DIV, NEG
- CAST
Aggregation Functions
- COUNT
- SUM
- AVG
- MAX
- MIN
Database Engine
- MySQL dialect is supported.
- Build-in Append only columnar engine(AOE) has been supported as the first fusion database engine.
- Real-time analytical queries are supported.
- Vectorized query execution engine, based on MPP solution, is introduced.
- Part of the expression execution has been vectorized through SIMD instructions.
- Distributed AOE with strong consistency guaranteed by RAFT has been supported.
- The performance of replicated state machine has been greatly improved through the unique design of reusing RAFT log as well as Write-Ahead log without any redundancy.
Contributors
This release includes 453 commits by 16 authors. Special thanks to the first author:
Yan Wenze (@nnsgmsone)
Chen Mingsong(@m-schen)
Jin Hai (@JinHai-CN)
Jiang xinmeng (@jiangxinmeng1)
Li Yang (@lignay)
Lin Junhong (@iamlinjunhong)
lni (@lni)
Long Ran (@aunjgr)
Peng Zhen (@daviszhen)
Qin Shuqi (@sukki37)
Shen JiangWei(@LeftHandCold)
Wei Ziran (@w-zr)
Xiong Jingjuan (@anitajjx)
Xu Peng (@XuPeng-SH)
Yan Wenze(@nnsgmsone)
Zilong Zhou (@zzl200012)
Zhang Yingfeng (@yingfeng)