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

[Epic] Support for unsigned integer types #3376

Closed
5 of 7 tasks
alamb opened this issue Sep 6, 2022 · 1 comment
Closed
5 of 7 tasks

[Epic] Support for unsigned integer types #3376

alamb opened this issue Sep 6, 2022 · 1 comment
Labels
enhancement New feature or request

Comments

@alamb
Copy link
Contributor

alamb commented Sep 6, 2022

This is a tracking epic to properly support Unsigned Integer Types.

DataFusion has fairly robust support for signed types like Int32, Int64, etc. #3359 added the ability to refer to unsigned types like UNSIGNED INT in SQL

The primary rationale for supporting unsigned integers is testing and better integration with the Arrow ecosystem (not, for example, performance). See additional discussion on supporting unsigned types here; #3325

Here are a list of items we still know of to complete

@alamb alamb added the enhancement New feature or request label Sep 6, 2022
@alamb alamb changed the title Support for unsigned integer types [EPIC] [Epic] Support for unsigned integer types Mar 5, 2023
@alamb
Copy link
Contributor Author

alamb commented Jan 13, 2024

I think this is done and unsigned ints work pretty well now:

DataFusion CLI v34.0.0
❯ create table foo (x int unsigned);
0 rows in set. Query took 0.002 seconds.

❯ insert into foo values (1);
+-------+
| count |
+-------+
| 1     |
+-------+
1 row in set. Query took 0.002 seconds.

❯ select arrow_typeof(x) from foo;
+---------------------+
| arrow_typeof(foo.x) |
+---------------------+
| UInt32              |
+---------------------+
1 row in set. Query took 0.002 seconds.

❯ select x + 4 from foo;
+------------------+
| foo.x + Int64(4) |
+------------------+
| 5                |
+------------------+
1 row in set. Query took 0.004 seconds.

@alamb alamb closed this as completed Jan 13, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant