Vertically stacking data should be easy and fast! DuckDB's UNION ALL BY NAME capability matches on column names instead of position - as it always should have been!
Reposted from
DuckDB
New blog post by @a13x.bsky.social:
Vertical Stacking as the Relational Model Intended: UNION ALL BY NAME
Alex takes us on a journey that includes a 1969 Ford Mustang, the not-too-successful SQL keyword "CORRESPONDING", and some cool DuckDB features.
Read more at duckdb.org/2025/01/10/u...
Vertical Stacking as the Relational Model Intended: UNION ALL BY NAME
Alex takes us on a journey that includes a 1969 Ford Mustang, the not-too-successful SQL keyword "CORRESPONDING", and some cool DuckDB features.
Read more at duckdb.org/2025/01/10/u...
Comments