Description

chenmo-S

opened on Aug 11, 2023

Issue body actions

Whether the overwrite is not supported
insert overwrite table default.test select * from default.test2;
throw net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "default" "DEFAULT" at line 1, column 24.

Activity

1. manticore-projects commented on Aug 17, 2023

   

   manticore-projects

   on Aug 17, 2023

   Contributor

   More actions

   Greetings.

   This syntax is far away from any SQL Standard (what RDBMS is this please?)
   You will need to provide or sponsor an implementation if you want to see it supported.
2. chenmo-S

   changed the title [-][BUG] JSQLParser Version : RDBMS : failing feature description[/-] [+][BUG] JSQLParser Version : 4.6 hive overwrite[/+] on Aug 17, 2023
3. chenmo-S commented on Aug 17, 2023

   

   chenmo-S

   on Aug 17, 2023

   Author

   More actions

   Greetings.

   This syntax is far away from any SQL Standard (what RDBMS is this please?) You will need to provide or sponsor an implementation if you want to see it supported.

   Sorry,My question has the wrong title
   Now I corrected it.
4. manticore-projects

   added

   exotic

   on Aug 18, 2023
5. minleejae commented on Sep 7, 2026

   

   minleejae

   on Sep 7, 2026

   Contributor

   More actions

   @manticore-projects The exact reproducer now parses successfully on master 6c726d88:

   insert overwrite table default.test select * from default.test2;

   I checked both parts of the original report: the Insert AST has isOverwrite() == true and isTableKeyword() == true, and the target and source tables both retain "default" as their schema name. Both toString() and StatementDeParser produce:

   INSERT OVERWRITE TABLE default.test SELECT * FROM default.test2

   The output reparses with the same fields. INSERT OVERWRITE support was added in #2135, with existing coverage in InsertTest.testInsertOverwrite. The current identifier grammar also accepts DEFAULT in this context.

   Default parsing, parsing with unsupported-statement fallback disabled, and the full Gradle check all passed. Could you consider closing this issue if there is no remaining failing example on master?

   Reacted by manticore-projects
6. manticore-projects

   closed this as completedon Sep 12, 2026

Issue actions