[
https://issues.apache.org/jira/browse/IMPALA-9600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shant Hovsepian updated IMPALA-9600:
------------------------------------
Description:
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')}}
was:
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')}}}}
> Support Format Modifiers for String Conversion
> ----------------------------------------------
>
> Key: IMPALA-9600
> URL: https://issues.apache.org/jira/browse/IMPALA-9600
> Project: IMPALA
> Issue Type: Improvement
> 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]
