We have a requirement to store two pieces of information in Cassandra one is quantity and the other is cost. We are planning to use DOUBLE as the datatype for these two fields. I wanted to see if it is recommended to choose double. Will we lose precision if we use DOUBLE?
A CQL double datatype is a 64-bit floating point so it can hold decimal values much larger than a regular float.
For quantity, you'll be better off using one of the CQL integer datatypes like int (32-bit) or bigint (64-bit).
For details, see the CQL Data types documentation. Cheers!
Expanding on what @Erick Ramirez said: for monetary amounts you want to use arbitrary-precision types. The best type for that in CQL is decimal. Never use floating-point types like float or double, these are best suited for scientific measures mostly.
7 People are following this question.
