This message was deleted.
# troubleshootings
Slackbot
05/23/2023, 7:14 AMThis message was deleted.
g
Gian Merlino
05/24/2023, 2:00 AMit could be down to floating-point rounding
Gian Merlino
05/24/2023, 2:01 AMyou could check this by doing, like,
m_criticality BETWEEN 0.3799 AND 0.3801m_criticality = 0.38g
Ganesh Asokan
05/24/2023, 5:46 AMYes, it was down to rounding issue. When I give round(m_criticality, 2) <- this works. So like in other programming languages, the storage representation of float must be a approximation and not an exact.
I am indexing this data to druid from parquet and that field calculation is already round( x, 2). So I did not expect this issue.