[
https://issues.apache.org/jira/browse/IMPALA-9131?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gabor Kaszab closed IMPALA-9131.
--------------------------------
Resolution: Fixed
> Use single quotes when printing out FORMAT clause within CAST.
> --------------------------------------------------------------
>
> Key: IMPALA-9131
> URL: https://issues.apache.org/jira/browse/IMPALA-9131
> Project: IMPALA
> Issue Type: Bug
> Components: Frontend
> Affects Versions: Impala 3.3.0
> Reporter: Gabor Kaszab
> Assignee: Gabor Kaszab
> Priority: Major
>
> Here the content of the FORMAT clause is surrounded by double quotes.
> {code:java}
> select cast('2016/10/10' as date format 'YYYY/MM/DD');
> +------------------------------------------------+
> | cast('2016/10/10' as date format "yyyy/mm/dd") |
> +------------------------------------------------+
> | 2016-10-10 |
> +------------------------------------------------+
> {code}
> In order to follow SQL standards this should be surrounded by single quotes
> regardless of how the user gave the FORMAT clause.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
