OpenMLDB v0.3.0
Highlight
We introduce a new standalone mode that can be deployed on a single node, which is suitable for small businesses and the demonstration purpose. Please read more details from here. The standalone mode is particularly enhanced for ease of use based on the following features that are supported by standalone mode only.
- The standalone deployment mode #440
- Connection establishment by specifying the host name and port in CLI #441
- LOAD DATA command for bulk loading #443
- SQL syntax support for exporting data: SELECT INTO FILE #455
- Deployment commands: DEPLOY, SHOW DEPLOYMENT, and DROP DEPLOYMENT #460 #447
Other Features
- A new CLI command to support different levels of performance sensitivity:
SET performance_sensitive=true|false
. When it is set to false, SQL queries can be executed without indexes. Please read here for more details about the performance sensitivity configuration #555 - Supporting SQL queries over multiple databases #476
- Supporting inserting multiple tuples into a table using a single SQL #398
- Improvements for Java SDK:
The new API getTableSchema #483
The new API genDDL, which is used to generate DDLs according to a given SQL script #588
Bugfix
- Exceptions caused by certain physical plans with special structures when performing column resolve for logical plans. #437
- Under specific circumstances, unexpected outcomes produced by SQL queries with the WHERE when certain WHERE conditions do not fit into indexes #599
- The bug when enabling WindowParallelOpt and WindowSkewOptimization at the same times #444
- The bug of LCA (Lowest Common Ancestor) algorithm to support WindowParallelOpt for particular SQLs #485
- Workaround for the Spark bug (SPARK-36932) when the columns with the same names in LastJoin #484
Acknowledgement
We appreciate the contribution to this release from external contributors who are not from 4Paradigm's core OpenMLDB team, including Kanekanekane, shawn-happy, lotabout, Shouren, zoyopei, huqianshan