Skip to content

[BUG] JSQLParser Version : 4.6 hive overwrite #1846

Closed

Description

@chenmo-S

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
    Contributor

    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. 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
    Author

    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. minleejae commented on Sep 7, 2026

    @minleejae
    Contributor

    @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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions