database design - Should I store trailing zeros in a key/value storage -
in our application read , write hbase table. in hbase table store strings, no integers/doubles/bigdecimals
data read multiple sources have column value in it, have 2 decimal precision, have 9. after of our calculation of values might end more 2 decimals. when writing our own hbase table write decimals 9 decimal precision.
when converting our (big)decimals string before writing them, should add trailing zeroes, make our out have 9 decimals indicate precision of column.
just date formats shouldn't stored in equal format regardless of format received them as. (either unix timestamps, or without timezones etc etc)
Comments
Post a Comment