You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by GitBox <gi...@apache.org> on 2019/03/12 07:21:56 UTC
[GitHub] [incubator-druid] xqwbx163 opened a new issue #7240: summation
calculation, the 2 decimal point becomes 6 or more
xqwbx163 opened a new issue #7240: summation calculation, the 2 decimal point becomes 6 or more
URL: https://github.com/apache/incubator-druid/issues/7240
Please provide a detailed title (e.g. "Broker crashes when using TopN query with Bound filter" instead of just "Broker crashes").
### Affected Version
Druid v0.13
### Description
Use KIS load streaming data into druid, Some columns are decimal(16,2) in mysql database,the value such as: 3.24
push mysql value into druid, I define the data type as float on druid, and when querying each data through dsql, the display is 2 digits.
However, sum(total) summation calculation, you will find that the decimal point becomes 6 or more。
the sum total is different from the calculations in relational databases(mysql)
could you help me to solve it ?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org