Hi what s the best type choice for current in Pinot Is it ST

Question

Hi what s the best type choice for current in Pinot Is it STRING

Richard Startin · Answer

can you paraphrase your question What problem are you trying to solve

Alice · Answer

sorry it s a typo I mean currency or money

Alice · Answer

For mysql it s decimal type

Richard Startin · Answer

ok

Richard Startin · Answer

do you have multiple currencies or only one

Richard Startin · Answer

there isn t a built in data type for this but if you convert into cents you can store as a `LONG`

Richard Startin · Answer

however aggregation will performed using floating point numbers so is inexact

Kartik Khare · Answer

We have support for `SUM WITH PRECISION` but it only works for big decimal columns which are currently stored as byte For better performance we already have an effort in progress to add `DECIMAL` with fixed precision data type support

Alice · Answer

+1