Skip to content

[Python][Arrow] Don't deduplicate column names when outputting to Arrow#11160

Merged
Mytherin merged 1 commit into
duckdb:mainfrom
Tishj:dont_deduplicate_arrow_columns
Mar 14, 2024
Merged

[Python][Arrow] Don't deduplicate column names when outputting to Arrow#11160
Mytherin merged 1 commit into
duckdb:mainfrom
Tishj:dont_deduplicate_arrow_columns

Conversation

@Tishj
Copy link
Copy Markdown
Member

@Tishj Tishj commented Mar 14, 2024

This PR fixes #11157

This problem was likely introduced in #10532

When outputting to PyArrow, we create batches and then create a table from those batches.
When creating the batches we were deduplicating column names, but didn't do this for the schema passed to the table-from-batches function.

We properly skip deduplicating in both places now, Arrow has no problem with duplicate column names.

… in one place, but doing it in another, causing a schema mismatch in the produced arrow table
@Mytherin Mytherin merged commit 6218e71 into duckdb:main Mar 14, 2024
@Mytherin
Copy link
Copy Markdown
Collaborator

Thanks!

github-actions Bot pushed a commit to duckdb/duckdb-r that referenced this pull request Mar 17, 2024
Merge pull request duckdb/duckdb#11161 from Maxxen/bugfixes
Merge pull request duckdb/duckdb#11160 from Tishj/dont_deduplicate_arrow_columns
@Tishj Tishj deleted the dont_deduplicate_arrow_columns branch November 7, 2025 16:11
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

DuckDB 0.10.0 changes and exceptions in SQL JOIN duplicate column identifier treatment with Arrow (deduplicates through count)

2 participants