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

Build UDF TRUNC to implement FIRST_DAY as compared with LAST_DAY

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.2.0
    • Component/s: UDF
    • Labels:
      None

      Description

      Hive already supports LAST_DAY UDF, in some cases, FIRST_DAY is necessary to do date/timestamp related computation. This JIRA is to track such an implementation. Choose to impl TRUNC, a more standard way to get the first day of a a month, e.g., SELECT TRUNC('2009-12-12', 'MM'); will return 2009-12-01, SELECT TRUNC('2009-12-12', 'YEAR'); will return 2009-01-01.

      BTW, this TRUNC is not as feature complete as aligned with Oracle one. only 'MM' and 'YEAR' are supported as format, however, it's a base to add on other formats.

        Attachments

        1. HIVE-9480.9.patch
          77 kB
          Xiaobing Zhou
        2. HIVE-9480.8.patch
          77 kB
          Xiaobing Zhou
        3. HIVE-9480.7.patch
          77 kB
          Xiaobing Zhou
        4. HIVE-9480.6.patch
          67 kB
          Xiaobing Zhou
        5. HIVE-9480.5.patch
          67 kB
          Xiaobing Zhou
        6. HIVE-9480.4.patch
          45 kB
          Xiaobing Zhou
        7. HIVE-9480.3.patch
          19 kB
          Xiaobing Zhou
        8. HIVE-9480.1.patch
          15 kB
          Xiaobing Zhou

          Issue Links

            Activity

              People

              • Assignee:
                xiaobingo Xiaobing Zhou
                Reporter:
                xiaobingo Xiaobing Zhou
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: