[ 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)