Skip to content

Support UNION (ALL) BY NAME syntax (duckdb, spark) #899

Closed
@alexander-beedie

Description

@alexander-beedie

This is a very useful form of UNION that has the backend align the columns on either side of the union: https://duckdb.org/docs/sql/query_syntax/setops.html#union-all-by-name.

Would be wonderful to have parsing support :)
Many thanks!


SELECT * FROM table_x UNION BY NAME SELECT * FROM table_y;

Metadata

Metadata

Assignees

No one assigned

    Labels

    help wantedExtra attention is needed

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions