Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-3759

Add function for unix_timestamp with date format yyyyDDD

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: Impala 2.3.0
    • Fix Version/s: None
    • Component/s: Backend

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                pgarg_impala_3a7b Pavas Garg
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: