finchxxia opened a new pull request, #2148:
URL: https://github.com/apache/datafusion-sqlparser-rs/pull/2148

   1. I found that datafusion-sqlparser-rs cannot support [multi-table 
insert](https://docs.snowflake.com/en/sql-reference/sql/insert-multi-table) 
currently. 
   ```
   -- Unconditional multi-table insert
   INSERT [ OVERWRITE ] ALL
     intoClause [ ... ]
   <subquery>
   
   -- Conditional multi-table insert
   INSERT [ OVERWRITE ] { FIRST | ALL }
     { WHEN <condition> THEN intoClause [ ... ] }
     [ ... ]
     [ ELSE intoClause ]
   <subquery>
   ```
   
   2. Another case is when I using **SAMPLE** in subquery, it cannot work 
normally. 
   ```
   SELECT * FROM (SELECT * FROM (select report_from from my_table) SAMPLE 
(10000 ROWS)) AS anon_1
   ```


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to