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

Support specifying decimal places for ROUND function

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.3.0
    • Query Processor
    • None
    • Incompatible change, Reviewed
    • Hide
      HIVE-194. Support specifying decimal places for ROUND function. ROUND always rounds away from zero now. (David Phillips via zshao)
      Show
      HIVE-194 . Support specifying decimal places for ROUND function. ROUND always rounds away from zero now. (David Phillips via zshao)

    Description

      Standard behavior:

      ROUND( number, [ decimal_places ] )

      decimal_places can be negative, which rounds digits to the left of the decimal point. NULL is returned if either argument is NULL.

      Attachments

        1. hive-round.patch
          4 kB
          David Phillips

        Issue Links

        is depended upon by

        Wish - General wishlist item. HIVE-165 Add standard statistical functions

        • Minor - Minor loss of function, or other problem where easy workaround is present.
        • Resolved
        relates to

        Improvement - An improvement or enhancement to an existing feature or task. HIVE-4523 round() function with specified decimal places not consistent with mysql

        • Minor - Minor loss of function, or other problem where easy workaround is present.
        • Resolved

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            electrum David Phillips Assign to me
            electrum David Phillips
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment