FrankChen021 opened a new pull request #10635:
URL: https://github.com/apache/druid/pull/10635


   This PR implements requirements described in #10584
   
   In this PR, 3 SQL functions and 3 corresponding native functions are 
provided to format numbers to different style.
   
   | SQL/Native function | Description |
   | --- | --- |
   | human_readable_binary_byte_format(value[, precision]) | Returns the value 
in human-readable [IEC](https://en.wikipedia.org/wiki/Binary_prefix) format. 
Supported unit suffix: `B`, `KiB`, `MiB`, `GiB`, `TiB`, `PiB`, `EiB`. 
`precision` must be in the range of [0,3] (default: 2). |
   | human_readable_decimal_byte_format(value[, precision]) | Returns the value 
in human-readable [SI](https://en.wikipedia.org/wiki/Binary_prefix) format. 
Supported unit suffix: `B`, `KB`, `MB`, `GB`, `TB`, `PB`, `EB`. `precision` 
must be in the range of [0,3] (default: 2). |
   | human_readable_decimal_format(value[, precision]) | Returns the value in 
human-readable SI format. Supported unit suffix:  `K`, `M`, `G`, `T`, `P`, `E`. 
`precision` must be in the range of [0,3] (default: 2). |
   
   The reason why 3 functions are provided to user instead of 1 function with 
different argument of format is that we think it's more simpler for a user to 
call these function. However in internal implementation, there's only one 
public format function exposed for all 3 format.
   
   We've tested this feature in our clusters, and it works as we expect.
   
   
![image](https://user-images.githubusercontent.com/6525742/102842930-1aea6a80-4443-11eb-9314-42d97332f070.png)
   
   
   Web Console now looks like
   
   
![image](https://user-images.githubusercontent.com/6525742/110092237-5656cd00-7dd4-11eb-8be9-850cee59c80b.png)
   
   <hr>
   
   This PR has:
   - [X] been self-reviewed.
   - [X] added documentation for new or modified features or behaviors.
   - [X] added Javadocs for most classes and all non-trivial methods. Linked 
related entities via Javadoc links.
   - [ ] added or updated version, license, or notice information in 
[licenses.yaml](https://github.com/apache/druid/blob/master/licenses.yaml)
   - [X] added comments explaining the "why" and the intent of the code 
wherever would not be obvious for an unfamiliar reader.
   - [X] added unit tests or modified existing tests to cover new code paths, 
ensuring the threshold for [code 
coverage](https://github.com/apache/druid/blob/master/dev/code-review/code-coverage.md)
 is met.
   - [ ] added integration tests.
   - [X] been tested in a test Druid cluster.
   
   


-- 
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:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@druid.apache.org
For additional commands, e-mail: commits-h...@druid.apache.org

Reply via email to