hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "N Campbell (JIRA)" <>
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
             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), ....


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

This message was sent by Atlassian JIRA

View raw message