Release Notes v0.4.0
1. Feature and Optimization about SQL
1.1 Features about SQL
1.1.1 Extended SQL Syntax
Support TTL when create table using options
Support to assign partitions when create table
1.1.2 Features about Complex Data Type
Support Operations about MAP
Support Operations about MultiSet
Support Operations about Array
1.1.3 Support to use variables in SQL statement, such as insert, select, delete.
1.1.4 Support stratagy to control messages transmitted between operators in execution plan
1.1.5 Support new SQL function
No |
Function Name |
Description about Function |
---|---|---|
1 |
pow(x,y) |
The POW() function returns the value of a number raised to the power of another number |
2 |
round(x,y) |
The ROUND() function rounds a number to a specified number of decimal places |
3 |
ceiling(x) |
The CEILING() function returns the smallest integer value that is bigger than or equal to a number |
4 |
floor(x) |
The FLOOR() function returns the largest integer value that is smaller than or equal to a number |
5 |
mod(x,y) |
The MOD() function returns the remainder of a number divided by another number |
6 |
abs(x) |
The ABS() function returns the absolute (positive) value of a number. |
1.2 Optimization about SQL
Optimizate query using range filter
Optimizate query about range scan
Optimizate type system about dingo internally
Optimization about SQL date/time/timestamp function
2. Operation of Key-Value
2.1 Equivalent operation of Key-Value and SQL
Support to do table operation using Key-Value API, such as create table, drop table
Support to insert, update, delete record in table using Key-Value API
Support to do table operation using Annotation API
Operations about table and record are equivalent between Key-Value API and SQL
2.2 Operation lists about Key-Value SQL
2.2.1 Basic Key-Value Operation
No |
Function Name |
Description about Function |
---|---|---|
1 |
put |
insert or update records in table |
2 |
get |
query records by user key |
3 |
delete |
delete records by user key |
2.2.2 Numerical operations
No |
Funcation Name |
Description about Function |
---|---|---|
1 |
add |
add values on same data type |
2 |
sum |
calculate the summary of columns filtered by keys |
3 |
max |
calculate the max of columns filtered by keys |
4 |
min |
calculate the min of columns filtered by keys |
2.2.3 Compound operation
No |
Function Name |
Description about Function |
---|---|---|
1 |
Operate |
do multiple operations on a single record, the operation list can be numerical operation or basic operation |
2 |
OperateList |
do multiple operations on a single record |
3 |
UDF |
defined using LUA script to implement user define function |
2.2.4 Collection operations
No |
Type |
Function Name |
Description about Function |
---|---|---|---|
1 |
read |
size |
get size of the elements |
2 |
read |
get_all |
get all the elements of collection |
3 |
read |
get_by_key |
get all the elements of collection by input key |
4 |
read |
get_by_value |
get all the elements of collection by input value |
5 |
read |
get_by_index_range |
get all the elements of collection by range index |
6 |
write |
put |
append a element to the end |
7 |
write |
clear |
clear all the elements of collection |
8 |
write |
remove_by_key |
remove the key from collection |
9 |
write |
remove_all_by_value |
remove all records match the value |
10 |
write |
remove_by_index |
remove record by index |
2.2.5 Filter operations
DateFilter
Query records using range filter with Date
type.
NumberRange
Query records using range filter with Numberic type.
StringRange
Query records using range filter with String type
ValueEquals
Query records with specifiy record value.
3. Optimization about Storage
3.1 Distributed Consistency Protocol
Refactor the implements of raft protocol to replace
sofa-jraft
Refactor the implements about log replication and leader selection
Support new serialization about key and value
3.2 Improvement about Rocksdb
Rocksdb can load configuration by files
Support TTL features using user timestamp
Update Rocksdb version and release package about
io.dingodb.
on maven central
4. Other features
Support parameters using JDBC connection such as
timeout
Support
explain
to view plan about Dingo SQLSupport to release related package to maven-central
No |
Module |
Description about module |
---|---|---|
1 |
dingo-driver-client |
the jdbc driver client used by sql |
2 |
dingo-sdk |
the key-value sdk client to do operation about key-value |
3 |
dingo-rocksdb |
Extended features on rocksdb |