As per the SQL standard, SQL data types incl. HUGEINT are signed types.
For the respective values ranges see
https://www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes

The value you try to ingest is larger than the largest positive value
that can be supported / represented as a *signed* 128 bit integer.

Best,
Stefan

----- On May 11, 2016, at 7:28 PM, Shmagi Kavtaradze kavtaradze.s@gmail.com wrote:

> I create table with HUGEINT type. When I am trying to import data from text
> file, Monetdb fires error: Failed to import table line 508 field 3 'hugeint'
> expected in '170141183460469231731687303715888300032', but this value has
> exactly 128 bits. Any ideas how to fix the issue? Thanks.
>
>

> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list

--
| Stefan.Manegold@CWI.nl | DB Architectures   (DA) |
| www.CWI.nl/~manegold/  | Science Park 123 (L321) |
| +31 (0)20 592-4212     | 1098 XG Amsterdam  (NL) |
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list