MatrixOne v0.1.0 Release Notes

We are excited to announce the first release of MatrixOne 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)