git.net

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[jira] [Created] (CALCITE-2310) SqlParser parse multiple sql statements split by semicolon


xufei created CALCITE-2310:
------------------------------

             Summary: SqlParser parse multiple sql statements split by semicolon
                 Key: CALCITE-2310
                 URL: https://issues.apache.org/jira/browse/CALCITE-2310
             Project: Calcite
          Issue Type: Improvement
          Components: core
            Reporter: xufei
            Assignee: Julian Hyde


Current, SqlParser only supports parse single sql statement to single SqlNode. But since we have server module, and support DDL syntax, It is common to write DDL statement and DML statement together to build a complete logic. 

For example:
 * Table orders is a source table;
 * Table output_console is a sink table;
 * Read data from source table, do some project and filter, then write to sink table. 

{code:java}
CREATE TABLE orders (
 createTime TIMESTAMP,
 productId bigint,
 orderId bigint,
 units bigint,
 user_name VARCHAR
); 

CREATE TABLE output_console(
 createTime TIMESTAMP,
 productId bigint,
 orderId bigint,
 units bigint,
 user_name VARCHAR
);

INSERT INTO output_console
SELECT
 createTime,
 productId,
 orderId,
 units,
 user_name
FROM orders
WHERE (productId>3) AND (productId<8);
{code}
So, I think it really helps if SqlParser support parse multiple sql statements.

 

 

 

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)