Numeric precision of xt2

Users
1

From XTDB Data Types | XTDB, I see that double is supported, but it doesn’t look like DECIMAL/NUMERIC. Two questions:

  1. How are “numeric” values persisted to the underlying arrow tables?
  2. Are there any plans to support NUMERIC in sql?
2

Hey @lsowen, thanks for getting in touch! :wave:

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

3

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

2 Likes