rahafrouz opened a new issue #10190:
URL: https://github.com/apache/druid/issues/10190


   ### Description
   Druid supports Double data type which is an Approximate Numeric Types. Is it 
on the roadmap anywhere to add support for Exact Numeric Types? 
   
   Highest numerical precision we can get with druid is the double (64bit) data 
type. Due to the nature of binary storage format, we would have 53 meaningful 
bits, which means 15 meaningful decimal digits for sure. ( 53 log10(2) ≈ 15.955 
). 
   
   As an example of Exact Numeric type: BigQuery has support for NUMERIC data 
type which gives 38 digits of precision and 9 decimal digits of scale. This is 
the ideal field for financial reporting, or any high precision calculations. 
   
   ### Motivation
   
   Support for data with High precision ranging that contains very small and 
very big data points without data loss. 
   - Financial reporting is a big motivating use-case. 


----------------------------------------------------------------
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:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to