[IMPALA-3759] Add function for unix_timestamp with date format yyyyDDD

• Type: New Feature
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Impala 2.3.0
• Component/s: Backend
• Labels: built-in-function ramp-up
• Epic Link: Timestamp Compatibility
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Pavas Garg
• Created: 19/Jun/16 16:57
• Updated: 05/Oct/19 00:17
• Resolved: 05/Oct/19 00:17

Description

Add function for unix_timestamp with date format yyyyDDD

This works good from hive beeline shell
Select unix_timestamp('2000123', 'yyyyDDD') as julian_unix
, from_unixtime(unix_timestamp('2000123', 'yyyyDDD')) as julian_date
, unix_timestamp('20000502', 'yyMMDD') as yymmdd_unix
, from_unixtime(unix_timestamp('20000502', 'yyMMDD')) as yymmdd_date

But does not from impala-shell, throwing message -
WARNINGS: Bad date/time conversion format: yyyyDDD

Require the Hive functionality in Impala to deal with Julian dates.

Issue Links

• relates to: IMPALA-4018 Add support for SQL:2016 datetime templates/patterns/masks to CAST(... AS ... FORMAT <template>)