You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Gabor Kaszab (Jira)" <ji...@apache.org> on 2019/12/04 11:06:00 UTC
[jira] [Closed] (IMPALA-9131) Use single quotes when printing out
FORMAT clause within CAST.
[ 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)