Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Should a FIXED type for fixed-length character strings be added to DuckDB? #3

Closed
ghalimi opened this issue Jan 21, 2023 · 5 comments
Closed
Labels
question Further information is requested

Comments

@ghalimi
Copy link
Contributor

ghalimi commented Jan 21, 2023

Apache Iceberg supports the fixed(L) type for a fixed-length character string of length L. Should a similar type be added to DuckDB? Without it, values of this type are cast to the VARCHAR type, which encoding might lead to performance degradation and | or memory waste.

Link: Types

@ghalimi ghalimi added the question Further information is requested label Jan 21, 2023
@ghalimi
Copy link
Contributor Author

ghalimi commented Jan 23, 2023

This is probably not urgent.

@ghalimi ghalimi closed this as completed Jan 23, 2023
@alexey-milovidov
Copy link

Fixed-size string type, and more importantly, a binary data type, makes sense for hashes.
ClickHouse does it with the FixedString data type, and it is used for a wide range of applications.

@ghalimi
Copy link
Contributor Author

ghalimi commented Mar 22, 2023

Binary datatype of fixed size?

@alexey-milovidov
Copy link

Yes.

@ghalimi
Copy link
Contributor Author

ghalimi commented Mar 30, 2023

Got it. Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested
Projects
None yet
Development

No branches or pull requests

2 participants