Can not import 128 bit values
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.
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) |
Thanks a lot, it helped.
On Wed, May 11, 2016 at 9:10 PM, Stefan Manegold
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
participants (2)
-
Shmagi Kavtaradze -
Stefan Manegold