You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "N Campbell (JIRA)" <ji...@apache.org> on 2013/10/06 19:51:44 UTC

[jira] [Created] (HIVE-5470) support extract function

N Campbell created HIVE-5470:
--------------------------------

             Summary: support extract function
                 Key: HIVE-5470
                 URL: https://issues.apache.org/jira/browse/HIVE-5470
             Project: Hive
          Issue Type: Improvement
    Affects Versions: 0.11.0
            Reporter: N Campbell
            Priority: Minor


You have the equivalent scalar functions but do not offer ISO-SQL extract which should be a small enhancement.

Note, the second() scalar does not return the fractional seconds in a timestamp with ISO-SQL would expect extract (second) to implement.

select extract (year from cts), ....

vs 

select rnum, year (cts), month( cts), day( cts), hour(cts), minute (cts), second( cts), cts from tts



--
This message was sent by Atlassian JIRA
(v6.1#6144)