Gabor Kaszab created IMPALA-9131:
------------------------------------

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


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)

Reply via email to