Release Notes v0.3.0

1.Semantics and Function of SQL

1.1 New data type

  • Boolean

  • Date: default format yyyy-MM-dd

  • Time: default format HH:mm:ss

  • Timestamp: default format yyyy-MM-dd HH:mm:ss.SSS

1.2 Allow assigning a default value to column, either constant or internal functions

1.3 Support Join operation

  • Inner Join

  • Left Join

  • Right Join

  • Full Join

  • Cross Join

1.4 Function list about String

No

Function Names

Notes about Function

1

Concat

Adds two or more expressions together

2

Format

Formats a number to a format like “#,###,###.##”, rounded to a specified number of decimal places

3

Locate

The LOCATE() function returns the position of the first occurrence of a substring in a string

4

Lower

Converts a string to lower-case

5

Lcase

Converts a string to lower-case

6

Upper

Converts a string to upper-case

7

Ucase

Converts a string to upper-case

8

Left

Extracts a number of characters from a string (starting from left)

9

Right

Extracts a number of characters from a string (starting from right)

10

Repeat

Repeats a string as many times as specified

11

Replace

Replaces all occurrences of a substring within a string, with a new substring

12

Trim

Removes leading and trailing spaces from a string

13

Ltrim

Removes leading spaces from a string

14

Rtrim

Removes trailing spaces from a string

15

Mid

Extracts a substring from a string (starting at any position)

16

Substring

Extracts a substring from a string (starting at any position)

17

Reverse

Reverses a string and returns the result

1.5 Function list about Date and Time

No

Function Names

Notes about Function

1

Now

Return current date and time

2

CurrentDate

Return the current date

3

Current_date

Return the current date

4

CurTime

Return the current time

5

Current_time

Return the current time

6

Current_timestamp

Return the current date and time

7

From_UnixTime

Convert unix time to timestamp

8

Unix_Timestamp

Format the time to unix timestamp

9

Date_Format

Formats a date

10

DateDiff

Returns the number of days between two date values

11

Time_Format

Formats a time by a specified format

2. Management of Replicator

2.1 Management of metadata

  • Physical table can be split into N partitions based on data size

  • Management of physical tables such as table creation time, table status, partition strategy, split conditions, etc

2.2 Scheduler of partition replicator

  • Support multiple partition modes, such as One table with one partition, One table with multiple partitions

  • Support multiple split strategies, such as auto-split or manually split by API

  • Support resource isolation between physical tables

2.3 Tools of partition management

  • Support to view status about partition, such as leader, follower, etc

  • Support to migrate, split partition by internal API

  • Support to view metrics about partition, such as write, read latency, size, record count

3. The data access method for DingoDB

3.1 JDBC mode

  • Support to connect to dingo by JDBC

3.2 SDK client mode

  • Support to put, get, and delete records to tables in dingo

  • Support to batch write records to tables in dingo

3.3 Import data from external

  • Support to import data from local files in CSV, JSON format

  • Support to import data from Kafka in JSON and Avro format

4. Tools and Monitor

  • Support to monitor dingo cluster by grafana and prometheus

  • Support to management partitions of the cluster by API

  • Support to adjust log level dynamically by tools

  • Support to deploy cluster by ansible or docker-compose

  • Newly add autotests more than 1300+