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

Add support for quarter in trunc udf

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.3.0
    • UDF

    Description

      Hive has a Date function trunc(string date, string format) that returns date truncated to the unit specified by the format. Supported formats: MONTH/MON/MM, YEAR/YYYY/YY.
      Goal here is to extend support to QUARTER/Q.
      Example:
      SELECT trunc('2017-03-15', 'Q');
      '2017-01-01'
      SELECT trunc('2017-12-31', 'Q');
      '2017-10-01'

      Attachments

        1. HIVE-16234.1.patch
          45 kB
          Deepesh Khandelwal

        Activity

          People

            deepesh Deepesh Khandelwal
            deepesh Deepesh Khandelwal
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: