Skip to content

Latest commit

 

History

History
100 lines (75 loc) · 5.25 KB

dingodb_0_3_0_rn.md

File metadata and controls

100 lines (75 loc) · 5.25 KB
Raw

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+