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)
