Things like Spark and Flink don’t do that as well, but because they need integration with proper Java types.
> On Jun 16, 2016, at 15:45, Yingyi Bu <[email protected]> wrote: > >>> Is there any database or SQL implementation supporting that? > Ok, it turns out MySQL supports that, while Postgres, MS SQL and Hive do > not have that. > > Best, > Yingyi > > On Thu, Jun 16, 2016 at 3:40 PM, Yingyi Bu <[email protected]> wrote: > >>>> I guess part of the reason why we do that is because Java used to lack >> native support of unsigned integers. >> Is there any database or SQL implementation supporting that? >> >> FYI: >> >> http://dba.stackexchange.com/questions/53050/why-arent-unsigned-integer-types-available-in-the-top-database-platforms >> >> Best, >> Yingyi >> >> >> On Thu, Jun 16, 2016 at 3:27 PM, Ildar Absalyamov < >> [email protected]> wrote: >> >>> Hi devs, >>> >>> As I was generating various data distributions for statistics experiments >>> one thing kept bothering me. >>> All Asterix integer types (int8, int16, int32, int64) are signed. However >>> majority of real use cases does not require negative integer values. Seems >>> like we are waisting half of the data range on something which does not get >>> used that often. I guess part of the reason why we do that is because Java >>> used to lack native support of unsigned integers. But since Java 8 there >>> are methods which do unsigned comparison and division (summation, >>> subtraction, multiplication are the same in both signed and unsigned >>> cases). So it seems like conversion to support unsigned integers would not >>> be that difficult. >>> >>> Any thoughts on whether we need unsigned integers in the type system? >>> >>> Best regards, >>> Ildar >>> >>> >> Best regards, Ildar
