Changelog

Unreleased

Feature

Support insert multiple rows into a table using a single SQL insert statement. #398
Support aggregation function, e.g. COUNT, SUM, MIN, MAX, AVG, over the whole table #219
Enhance plan optimization on GROUP and FILTER op #350
Refactor status code and status macro. Save first message (root message) in status.msg. #430

Bug Fix

Fix plan error triggered by optimize the same plan node repeatedly. #437

0.2.3 - 2021-08-31

Feature

Data importer support bulk load #250
Support parameterized query under BatchMode #262, #168
Support Hive metastore and Iceberg tables for offline #245, #146
Integrated with Trino #254
Support global SortBy node for offline #296

Bug Fix

Fix end2end offline tests for the same SQL #300
desc do not display the value of ttl after adding index#156

SQL Syntax

nvl & nvl2: #238
bitwise operators: &, |, ^, ~ #244
between predicate: #277

0.2.2 - 2021-08-08

Feature

Add VARCHAR Type #237

Bug Fix

Fix invalid back qoute identifier name #263 can't write as multiple path style (e.g a.b) now
InsertPreparedStatement set month by mistake when use Date type #200

Note:

OPTIONS can't write as multiple path style (e.g a.b) now

0.2.0 - 2021-07-22

Features

Refactor front-end using zetasql. Thus OpenMLDB can support more SQL syntaxs and provide friendly syntax error message.
Better code style and comment
Add APIServer module. User can use Rest API access OpenMLDB.#48

SQL Syntax

Changed

table options syntax: #103
lead method: #136

Removed

|| and && as logical operator: #264
at function: #265

Note

openmldb-0.2.0-linux.tar.gz targets on x86_64
aarch64 artifacts consider experimental