You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
[BUG] JSQLParser Version : 4.6 hive overwrite #1846
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.
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.
changed the title [-][BUG] JSQLParser Version : RDBMS : failing feature description[/-][+][BUG] JSQLParser Version : 4.6 hive overwrite[/+]on Aug 17, 2023
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.
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:
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?
Activity
manticore-projects commentedon Aug 17, 2023
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.
[-][BUG] JSQLParser Version : RDBMS : failing feature description[/-][+][BUG] JSQLParser Version : 4.6 hive overwrite[/+]chenmo-S commentedon Aug 17, 2023
Sorry,My question has the wrong title
Now I corrected it.
minleejae commentedon Sep 7, 2026
@manticore-projects The exact reproducer now parses successfully on master
6c726d88:I checked both parts of the original report: the
InsertAST hasisOverwrite() == trueandisTableKeyword() == true, and the target and source tables both retain"default"as their schema name. BothtoString()andStatementDeParserproduce: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
checkall passed. Could you consider closing this issue if there is no remaining failing example on master?