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

Support specifying scale and precision with Hive decimal type

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 0.11.0
    • 0.13.0
    • Query Processor, Types
    • None
    • Incompatible change

    Description

      HIVE-2693 introduced support for Decimal datatype in Hive. However, the current implementation has unlimited precision and provides no way to specify precision and scale when creating the table.

      For example, MySQL allows users to specify scale and precision of the decimal datatype when creating the table:

      CREATE TABLE numbers (a DECIMAL(20,2));

      Hive should support something similar too.

      Attachments

        1. HIVE-3976.1.patch
          57 kB
          Xuefu Zhang
        2. HIVE-3976.10.patch
          256 kB
          Xuefu Zhang
        3. HIVE-3976.11.patch
          256 kB
          Xuefu Zhang
        4. HIVE-3976.2.patch
          69 kB
          Xuefu Zhang
        5. HIVE-3976.3.patch
          61 kB
          Xuefu Zhang
        6. HIVE-3976.4.patch
          240 kB
          Xuefu Zhang
        7. HIVE-3976.5.patch
          255 kB
          Xuefu Zhang
        8. HIVE-3976.6.patch
          255 kB
          Xuefu Zhang
        9. HIVE-3976.7.patch
          254 kB
          Xuefu Zhang
        10. HIVE-3976.8.patch
          255 kB
          Xuefu Zhang
        11. HIVE-3976.9.patch
          255 kB
          Xuefu Zhang
        12. HIVE-3976.patch
          55 kB
          Xuefu Zhang
        13. remove_prec_scale.diff
          8 kB
          Jason Dere

        Issue Links

          blocks

          Task - A task that needs to be done. HIVE-5354 Decimal precision/scale support in ORC file

          • Major - Major loss of function.
          • Resolved
          depends upon

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-5366 Refactor a few object inspector class to eliminate redundant information

          • Major - Major loss of function.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-5372 Refactor TypeInfo and PrimitiveTypeEntry class hierachy to eliminate info repetition

          • Major - Major loss of function.
          • Resolved
          incorporates

          Bug - A problem which impairs or prevents the functions of the product. HIVE-5866 Hive divide operator generates wrong results in certain cases

          • Major - Major loss of function.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-5408 Method matching needs to be improved in NumericOpMethodResolver to suport decimal type with parameters

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-5520 Use factory methods to instantiate HiveDecimal instead of constructors

          • Major - Major loss of function.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-5872 Make UDAFs such as GenericUDAFSum report accurate precision/scale for decimal types

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. HIVE-5354 Decimal precision/scale support in ORC file

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. HIVE-5355 JDBC support for decimal precision/scale

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. HIVE-5356 Move arithmatic UDFs to generic UDF implementations

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. HIVE-5564 Need to accomodate table decimal columns that were defined prior to HIVE-3976

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. HIVE-5565 Limit Hive decimal type maximum precision and scale to 38

          • Major - Major loss of function.
          • Resolved
          is blocked by

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-5520 Use factory methods to instantiate HiveDecimal instead of constructors

          • Major - Major loss of function.
          • Resolved
          is depended upon by

          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

          Task - A task that needs to be done. HIVE-5355 JDBC support for decimal precision/scale

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. HIVE-5564 Need to accomodate table decimal columns that were defined prior to HIVE-3976

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. HIVE-5565 Limit Hive decimal type maximum precision and scale to 38

          • Major - Major loss of function.
          • Resolved
          is related to

          New Feature - A new feature of the product, which has yet to be developed. HIVE-2693 Add DECIMAL data type

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-5520 Use factory methods to instantiate HiveDecimal instead of constructors

          • Major - Major loss of function.
          • Resolved
          relates to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-5022 Decimal Arithmetic generates NULL value

          • Major - Major loss of function.
          • Resolved

          New Feature - A new feature of the product, which has yet to be developed. HIVE-4844 Add varchar data type

          • Major - Major loss of function.
          • Closed
          requires

          Bug - A problem which impairs or prevents the functions of the product. HIVE-5548 Tests under common directory don't run as part of 'ant test'

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. HIVE-5706 Move a few numeric UDFs to generic implementations

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link https://reviews.apache.org/r/14674/

          Activity

            People

              xuefuz Xuefu Zhang
              mgrover Mark Grover
              Votes:
              1 Vote for this issue
              Watchers:
              15 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: