Please enable JavaScript.

Coggle requires JavaScript to display documents.

OpenMLDB SQL (2019~2021), 2019.09 (Kick off) - Coggle Diagram

- - - - Create Table with column definition and index definition:
        CREATE TABLE t1 [IF NOT EXIST] ( col1 INT NOT NULL, col2 BIGINT NOT NULL, col3 STRING NOT NULL, INDEX(key=col1, ts=col2); );
  - - - GROUP statement: support GROUP BY columns:
        SELECT [projection, ...] FROM table_reference GROUP BY [column,...]
        SELECT SUM(col1) from t1 GROUP BY col2;
        
        The Window Statement enhancement: support window with UNION
        SELECT sum(col1) FROM t1 window as w1(UNION t2 partition by col0 ORDER BY col2 ROWS BETWEN 1000 preceding and current;
        SELECT sum(col1) FROM t1 window as w1(UNION t2 partition by col0 ORDER BY col2 ROWS_RANGE BETWEN 1000s preceding and current;
        `` :
        
        SubQuery statement:: support subquery columns from table
        SELECT c1, c2, c3 from (SELECT col1 as c1, col2 as c2, col3 as c3 from t2);
    - - The Window Statement enhancement: support window with UNION
        SELECT sum(col1) FROM t1 window as w1(UNION t2 partition by col0 ORDER BY col2 ROWS BETWEN 1000 preceding and current;
        SELECT sum(col1) FROM t1 window as w1(UNION t2 partition by col0 ORDER BY col2 ROWS_RANGE BETWEN 1000s preceding and current;
        `` :
        
        SubQuery statement:: support subquery columns from table
        SELECT c1, c2, c3 from (SELECT col1 as c1, col2 as c2, col3 as c3 from t2);
    - - SELECT statement enhancement: support more functions and expressions.
        
        Math Functions
        
        String Functions
        
        DateTime Functions
        
        Condition Functions and Expressions
        
        The Window Statement enhancement: support window with MAXSIZE
        SELECT sum(col1) FROM t1 window as w1(PARTITION BY col0 ORDER BY col2 ROWS_RANGE BETWEN 1000s preceding and current MAXSIZE 100;
        ` :
      - SELECT statement enhancement: support more functions and expressions.
        
        Math Functions
        
        String Functions
        
        DateTime Functions
        
        Condition Functions and Expressions
        
        The Window Statement enhancement: support window with MAXSIZE
        SELECT sum(col1) FROM t1 window as w1(PARTITION BY col0 ORDER BY col2 ROWS_RANGE BETWEN 1000s preceding and current MAXSIZE 100;
        ` :
        
        INSERT Statement enhancement: support insert with parameters.
        INSERT INTO t1 (col1, col2, col3, col4) value (1, ?, ?, ?);
      - 2020.12
        
        Create Procedure with single query statement:
        CREATE PROCEDURE procedure_name AS BEGIN statement END;
        CREATE PROCEDURE sp1 AS BEGIN SELECT col1, col2, col3 from t1; END
        
        SQL Query Support Batch Request query and optimized with const columns
        
        SQL Support Distribution Environment
        
        Group Statement: support GROUP BY columns:
        SELECT [projection, ...] FROM table_reference GROUP BY [column,...]
        SELECT SUM(col1) from t1 GROUP BY col2;
        
        OpenMLDB V0.2.0 (2021.06)
        
        SQL Syntax Parser Refactor: Use ZetaSQL as parser
        
        OpenMLDB V0.2.3 (2021.09)
        
        Order Statement: ORDER BY columns:
        SELECT [projection, ...] FROM table_reference ORDER BY [column,...]
        SELECT col1, col2 FROM t1 ORDER BY col3;
        
        SELECT functions&expressions enhancement:
        
        BETWEEN ... AND ... Expressions
        
        IN (....) Expressions
        
        Condition Functions: NVL, NVL2
        
        The Window Statement enhancement: support window with MAXSIZE
        SELECT sum(col1) FROM t1 window as w1(PARTITION BY col0 ORDER BY col2 ROWS_RANGE BETWEN 1000s preceding and current MAXSIZE 100;
        ` :
        
        V0.3.0
        
        INSERT Statement enhancement: support insert with multiple rows.
        INSERT INTO t1 (col1, col2, col3, col4) valu (1, 2, 3.0, 'hello'), (11, 22, 3.3, 'world');
        
        Deploy Statement: deploy query statement
        Deploy deployment_name SELECT col1, col2, col3 FROM t1;
        
        TODO