[
https://issues.apache.org/jira/browse/LENS-800?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14948514#comment-14948514
]
Rajat Khandelwal commented on LENS-800:
---------------------------------------
In measure definition, we have an attribute called "format_string" which is
right now ignored at the time of rewrite.
The proposal is to use that in the re-write phase to obtain a query in which
measures are properly formatted.
We need a generic way of taking format string and which will be used to modify
the query in the rewrite phase. Then, if needed, all drivers need to
incorporate conversion logic for this new change.
* Hive has a format_number method which takes number and format string in the
form of '##,###.##' etc
* Haven't found the corresponding method for format_number for SQL. Similar
functions exist, though.
http://stackoverflow.com/questions/1939326/number-format-with-mysql
* For Elastic search I hope [~amrk7] is able to help.
The formatting needs to be independent of drivers. And can possibly be obtained
by the locale information.
> Change rewrite to use format string around measures
> ---------------------------------------------------
>
> Key: LENS-800
> URL: https://issues.apache.org/jira/browse/LENS-800
> Project: Apache Lens
> Issue Type: Improvement
> Reporter: Rajat Khandelwal
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
