[HIVE-5470] support extract function

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 0.11.0
• Assignee: Unassigned
• Reporter: N Campbell
• Created: 06/Oct/13 17:50
• Updated: 26/Jul/17 15:14
• Resolved: 11/Jan/17 01:17

Description

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

Issue Links

• duplicates: HIVE-14579 Add support for date extract