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

Support specifying decimal places for ROUND function

    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

            People

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

              Dates

                Created:
                Updated:
                Resolved: