hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "N Campbell (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-5470) support extract function
Date Sun, 06 Oct 2013 17:51:44 GMT
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)

Mime
View raw message