[
https://issues.apache.org/jira/browse/IMPALA-3759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Greg Rahn resolved IMPALA-3759.
-------------------------------
Resolution: Fixed
> Add function for unix_timestamp with date format yyyyDDD
> --------------------------------------------------------
>
> Key: IMPALA-3759
> URL: https://issues.apache.org/jira/browse/IMPALA-3759
> Project: IMPALA
> Issue Type: New Feature
> Components: Backend
> Affects Versions: Impala 2.3.0
> Reporter: Pavas Garg
> Priority: Minor
> Labels: built-in-function, ramp-up
>
> 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.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
