[
https://issues.apache.org/jira/browse/IMPALA-9600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong updated IMPALA-9600:
----------------------------------
Component/s: Backend
> Support Format Modifiers for String Conversion
> ----------------------------------------------
>
> Key: IMPALA-9600
> URL: https://issues.apache.org/jira/browse/IMPALA-9600
> Project: IMPALA
> Issue Type: Improvement
> Components: Backend
> Reporter: Shant Hovsepian
> Priority: Major
> Labels: built-in-function, ramp-up
>
> A lack of support for "format modifiers" or "template patterns" while
> converting numeric and potentially other types to strings is a hinderance on
> usability.
> There may not be a way to do this as part of the SQL Standard, most database
> have a common extension to type conversion functions such as CONVERT() CAST()
> or TO_CHAR() that take a "printf" style format string as an argument. Locale
> awareness may have to be taken into consideration.
> For example Postgresql uses this syntax to add a thousand separator:
> {{to_char(148.5, '999D999')}}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
