You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "finchxxia (via GitHub)" <gi...@apache.org> on 2026/01/06 00:43:24 UTC
[I] Snowflake: does not support statement: Insert(Multi-table) [datafusion-sqlparser-rs]
finchxxia opened a new issue, #2150:
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/2150
I think we should support updates multiple tables by inserting one or more rows with column values (from a query) into the tables. Supports both unconditional and conditional inserts.
Example:
```
INSERT ALL
INTO t1
INTO t1 (c1, c2, c3) VALUES (n2, n1, DEFAULT)
INTO t2 (c1, c2, c3)
INTO t2 VALUES (n3, n2, n1)
SELECT n1, n2, n3 from src;
-- If t1 and t2 need to be truncated before inserting, OVERWRITE must be specified
INSERT OVERWRITE ALL
INTO t1
INTO t1 (c1, c2, c3) VALUES (n2, n1, DEFAULT)
INTO t2 (c1, c2, c3)
INTO t2 VALUES (n3, n2, n1)
SELECT n1, n2, n3 from src;
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
Re: [I] Snowflake: does not support statement: Insert(Multi-table) [datafusion-sqlparser-rs]
Posted by "finchxxia (via GitHub)" <gi...@apache.org>.
finchxxia closed issue #2150: Snowflake: does not support statement: Insert(Multi-table)
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/2150
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org