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

Pad Decimal numbers with trailing zeros to the scale of the column

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.13.0, 0.14.0, 1.0.0, 1.1.0, 1.2.0
    • 2.0.0
    • Types
    • Incompatible change

    Description

      HIVE-7373 was to address the problems of trimming tailing zeros by Hive, which caused many problems including treating 0.0, 0.00 and so on as 0, which has different precision/scale. Please refer to HIVE-7373 description. However, HIVE-7373 was reverted by HIVE-8745 while the underlying problems remained. HIVE-11835 was resolved recently to address one of the problems, where 0.0, 0.00, and so on cannot be read into decimal(1,1).

      However, HIVE-11835 didn't address the problem of showing as 0 in query result for any decimal values such as 0.0, 0.00, etc. This causes confusion as 0 and 0.0 have different precision/scale than 0.

      The proposal here is to pad zeros for query result to the type's scale. This not only removes the confusion described above, but also aligns with many other DBs. Internal decimal number representation doesn't change, however.

      Attachments

        1. HIVE-12063.1.patch
          431 kB
          Xuefu Zhang
        2. HIVE-12063.2.patch
          471 kB
          Xuefu Zhang
        3. HIVE-12063.3.patch
          469 kB
          Xuefu Zhang
        4. HIVE-12063.patch
          422 kB
          Xuefu Zhang

        Issue Links

          Activity

            People

              xuefuz Xuefu Zhang
              xuefuz Xuefu Zhang
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: