[jira] [Created] (IMPALA-9600) Support Format Modifiers for String Conversion

["Shant Hovsepian (Jira)" <ji...@apache.org>]

Shant Hovsepian created IMPALA-9600:
---------------------------------------

             Summary: 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


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)