[
https://issues.apache.org/jira/browse/HIVE-5470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan resolved HIVE-5470.
------------------------------------
Resolution: Duplicate
Fix Version/s: 2.2.0
> 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
> Fix For: 2.2.0
>
>
> 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.3.4#6332)
