Hive
  1. Hive
  2. HIVE-3976

Support specifying scale and precision with Hive decimal type

    Details

    • Type: New Feature New Feature
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.11.0
    • Fix Version/s: 0.13.0
    • Component/s: Query Processor, Types
    • Labels:
      None
    • Hadoop Flags:
      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.

      1. remove_prec_scale.diff
        8 kB
        Jason Dere
      2. HIVE-3976.patch
        55 kB
        Xuefu Zhang
      3. HIVE-3976.1.patch
        57 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.10.patch
        256 kB
        Xuefu Zhang
      13. HIVE-3976.11.patch
        256 kB
        Xuefu Zhang

        Issue Links

          Activity

          Mark Grover created issue -
          Mark Grover made changes -
          Field Original Value New Value
          Link This issue is related too HIVE-2693 [ HIVE-2693 ]
          Gavin made changes -
          Link This issue is related to HIVE-2693 [ HIVE-2693 ]
          Gavin made changes -
          Link This issue is related to HIVE-2693 [ HIVE-2693 ]
          Xuefu Zhang made changes -
          Assignee Xuefu Zhang [ xuefuz ]
          Xuefu Zhang made changes -
          Link This issue relates to HIVE-4884 [ HIVE-4884 ]
          Xuefu Zhang made changes -
          Link This issue relates to HIVE-4884 [ HIVE-4884 ]
          Xuefu Zhang made changes -
          Link This issue relates to HIVE-4844 [ HIVE-4844 ]
          Jason Dere made changes -
          Attachment remove_prec_scale.diff [ 12600625 ]
          Jason Dere made changes -
          Link This issue relates to HIVE-5022 [ HIVE-5022 ]
          Xuefu Zhang made changes -
          Attachment HIVE-3976.patch [ 12604850 ]
          Xuefu Zhang made changes -
          Attachment HIVE-3976.1.patch [ 12604923 ]
          Xuefu Zhang made changes -
          Issue Type Improvement [ 4 ] New Feature [ 2 ]
          Xuefu Zhang made changes -
          Link This issue incorporates HIVE-5356 [ HIVE-5356 ]
          Xuefu Zhang made changes -
          Link This issue incorporates HIVE-5355 [ HIVE-5355 ]
          Xuefu Zhang made changes -
          Link This issue incorporates HIVE-5354 [ HIVE-5354 ]
          Xuefu Zhang made changes -
          Link This issue depends upon HIVE-5366 [ HIVE-5366 ]
          Xuefu Zhang made changes -
          Link This issue depends upon HIVE-5372 [ HIVE-5372 ]
          Xuefu Zhang made changes -
          Attachment HIVE-3976.2.patch [ 12605335 ]
          Xuefu Zhang made changes -
          Attachment HIVE-3976.3.patch [ 12605448 ]
          Xuefu Zhang made changes -
          Link This issue incorporates HIVE-5408 [ HIVE-5408 ]
          Xuefu Zhang made changes -
          Link This issue is related to HIVE-5520 [ HIVE-5520 ]
          Xuefu Zhang made changes -
          Link This issue is blocked by HIVE-5520 [ HIVE-5520 ]
          Xuefu Zhang made changes -
          Link This issue blocks HIVE-5354 [ HIVE-5354 ]
          Xuefu Zhang made changes -
          Attachment HIVE-3976.4.patch [ 12608439 ]
          Xuefu Zhang made changes -
          Link This issue incorporates HIVE-5520 [ HIVE-5520 ]
          Xuefu Zhang made changes -
          Link This issue requires HIVE-5548 [ HIVE-5548 ]
          Xuefu Zhang made changes -
          Attachment HIVE-3976.5.patch [ 12608741 ]
          Xuefu Zhang made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Affects Version/s 0.11.0 [ 12323587 ]
          Fix Version/s 0.13.0 [ 12324986 ]
          Xuefu Zhang made changes -
          Remote Link This issue links to "https://reviews.apache.org/r/14674/ (Web Link)" [ 12925 ]
          Xuefu Zhang made changes -
          Link This issue is depended upon by HIVE-5564 [ HIVE-5564 ]
          Xuefu Zhang made changes -
          Link This issue incorporates HIVE-5565 [ HIVE-5565 ]
          Xuefu Zhang made changes -
          Link This issue is depended upon by HIVE-5565 [ HIVE-5565 ]
          Xuefu Zhang made changes -
          Attachment HIVE-3976.6.patch [ 12608796 ]
          Xuefu Zhang made changes -
          Attachment HIVE-3976.7.patch [ 12608827 ]
          Xuefu Zhang made changes -
          Attachment HIVE-3976.8.patch [ 12608863 ]
          Xuefu Zhang made changes -
          Attachment HIVE-3976.9.patch [ 12608946 ]
          Xuefu Zhang made changes -
          Link This issue incorporates HIVE-5564 [ HIVE-5564 ]
          Xuefu Zhang made changes -
          Link This issue is depended upon by HIVE-5355 [ HIVE-5355 ]
          Xuefu Zhang made changes -
          Link This issue is depended upon by HIVE-4523 [ HIVE-4523 ]
          Xuefu Zhang made changes -
          Attachment HIVE-3976.10.patch [ 12610273 ]
          Xuefu Zhang made changes -
          Attachment HIVE-3976.11.patch [ 12610458 ]
          Brock Noland made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Xuefu Zhang made changes -
          Link This issue requires HIVE-5706 [ HIVE-5706 ]
          Xuefu Zhang made changes -
          Link This issue incorporates HIVE-5872 [ HIVE-5872 ]
          Xuefu Zhang made changes -
          Link This issue incorporates HIVE-5866 [ HIVE-5866 ]
          Jason Dere made changes -
          Hadoop Flags Incompatible change [ 10342 ]
          Swarnim Kulkarni made changes -
          Labels TODOC13
          Lefty Leverenz made changes -
          Labels TODOC13

            People

            • Assignee:
              Xuefu Zhang
              Reporter:
              Mark Grover
            • Votes:
              1 Vote for this issue
              Watchers:
              15 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development