Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-3378

UDF to obtain the numeric day of an year from date or timestamp in HIVE.

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 0.8.1, 0.9.0
    • Fix Version/s: None
    • Component/s: UDF
    • Labels:
      None

      Description

      Hive current releases lacks a function which returns the numeric day of an year if a date or timestamp is given .The function DAYOFYEAR(date) would return the numeric day from a date / timestamp or which would be useful while using HiveQL.DAYOFYEAR can be used to compare data with respect to number of days till the given date.It can be used in different domains.

        Attachments

        1. HIVE-3378.03.patch
          20 kB
          Alexander Pivovarov
        2. HIVE-3378.02.patch
          20 kB
          Alexander Pivovarov
        3. HIVE-3378.02.patch
          20 kB
          Alexander Pivovarov
        4. HIVE-3378.1.patch.txt
          9 kB
          Deepti Antony

          Issue Links

            Activity

              People

              • Assignee:
                apivovarov Alexander Pivovarov
                Reporter:
                deepti Deepti Antony
              • Votes:
                2 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: