[CALCITE-2310] SqlParser parse multiple sql statements split by semicolon

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Fix Version/s: 1.20.0
• Component/s: core
• Assignee: Unassigned
• Reporter: Fei Xu
• Created: 15/May/18 10:09
• Updated: 21/Jan/22 19:20
• Resolved: 21/Jan/22 19:20

Description

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. 

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);

So, I think it really helps if SqlParser support parse multiple sql statements.

 

 

 

 

Issue Links

• is related to: CALCITE-2453 Enhance the SQL parser in order to optionally support semicolon at the end of the sql statements