Hi, I'm trying to read a Number field from an Oracle database that contains an IPv6 address that was converted to its Decimal representation. Support for UInt128 (and 256) are missing from odbc-driver so I tried to create my field in my ClickHouse table as Decimal256(0) but that didn't work.
I also tried to making this field a String and try to convert it as part of my query but that didn't work either, the number was getting truncated.
Would an array of UInt64[2] work?
Can you think of a clever way to read that field in, short of implementing support for UInt128? Thanks!
Hi, I'm trying to read a
Number
field from an Oracle database that contains an IPv6 address that was converted to its Decimal representation. Support for UInt128 (and 256) are missing from odbc-driver so I tried to create my field in my ClickHouse table as Decimal256(0) but that didn't work. I also tried to making this field aString
and try to convert it as part of my query but that didn't work either, the number was getting truncated. Would an array of UInt64[2] work?Can you think of a clever way to read that field in, short of implementing support for UInt128? Thanks!