commit 00abaf218735b6003af6eb4f482d6a6e2659a12c
author Yuval Shkolar <85674443+yuval-illumex@users.noreply.github.com> Mon Dec 09 22:25:10 2024 +0200
committer GitHub <noreply@github.com> Mon Dec 09 15:25:10 2024 -0500
tree 7524a8c9603bc7fe6d6b7c1156706417e4b819ec
parent d0fcc06652ba9880622d0ef8b426c809cee752fe

Support INSERT OVERWRITE INTO syntax (#1584)

src/parser/mod.rs

diff --git a/src/parser/mod.rs b/src/parser/mod.rs
index ac76f64..e47e71b 100644
--- a/src/parser/mod.rs
+++ b/src/parser/mod.rs
@@ -11291,9 +11291,8 @@
 
         let replace_into = false;
 
-        let action = self.parse_one_of_keywords(&[Keyword::INTO, Keyword::OVERWRITE]);
-        let into = action == Some(Keyword::INTO);
-        let overwrite = action == Some(Keyword::OVERWRITE);
+        let overwrite = self.parse_keyword(Keyword::OVERWRITE);
+        let into = self.parse_keyword(Keyword::INTO);
 
         let local = self.parse_keyword(Keyword::LOCAL);
 

tests/sqlparser_snowflake.rs

diff --git a/tests/sqlparser_snowflake.rs b/tests/sqlparser_snowflake.rs
index 3cbd87b..5ad861f 100644
--- a/tests/sqlparser_snowflake.rs
+++ b/tests/sqlparser_snowflake.rs
@@ -2952,3 +2952,9 @@
 
 #[test]
 fn test_parse_double_dot_notation_wrong_position() {}
+
+#[test]
+fn parse_insert_overwrite() {
+    let insert_overwrite_into = r#"INSERT OVERWRITE INTO schema.table SELECT a FROM b"#;
+    snowflake().verified_stmt(insert_overwrite_into);
+}