From XTDB Data Types | XTDB, I see that double is supported, but it doesn’t look like DECIMAL/NUMERIC. Two questions:
- How are “numeric” values persisted to the underlying arrow tables?
- Are there any plans to support NUMERIC in sql?
From XTDB Data Types | XTDB, I see that double is supported, but it doesn’t look like DECIMAL/NUMERIC. Two questions:
Hey @lsowen, thanks for getting in touch!
Yes, there are definitely plans to support SQL’s NUMERIC
, it’s on our backlog at the moment: #3746. Arrow has built-in support for higher (but not arbitrary) precision decimals up to 256 bits of mantissa - out of interest, would this be sufficient for your use case?
James
hi @jarohen,
Yes, decimal256
will cover our needs. In fact, in our current system we are able to use decimal128
for almost everything.
Thanks!
Logan
Hi again, just wanted to mention that decimals are already now available using the nightly build, and will land in the upcoming 2.0.0-beta7 release: XTDB Data Types | XTDB
Feedback welcome!
Amazing, I’ll give it a try!