Are there any recommended designs for how to handl...
# generald
Dan Hill
04/29/2020, 5:09 PMAre there any recommended designs for how to handle currency codes with Pinot tables that store money values?
k
Kishore G
04/29/2020, 5:21 PM
are you planning to convert them into a standard currency?
d
Dan Hill
04/29/2020, 5:22 PMFrom the client-side, we'll support USD and a customer-specific currency code. Requests made above the customer-level will be USD. Requests made below the customer-level can be specified using USD or customer-level.
Dan Hill
04/29/2020, 5:23 PMWe might add more levels of currency support over time. E.g. one at the platform level.
k
Kishore G
04/29/2020, 5:30 PM
best is to have 3 columns
Kishore G
04/29/2020, 5:30 PM
currency type, value, USD value
👍 1