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

Add support for quarter in trunc udf

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

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

      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

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              deepesh Deepesh Khandelwal Assign to me
              Reporter:
              deepesh Deepesh Khandelwal

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment