matrixone-v0.1.0

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)