Hive
  1. Hive
  2. HIVE-5564

Need to accomodate table decimal columns that were defined prior to HIVE-3976

    Details

    • Type: Task Task
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.13.0
    • Fix Version/s: 0.13.0
    • Component/s: Types
    • Labels:
      None

      Description

      With HIVE-3976, decimal columns are stored with precision/scale, such as decimal(17,5), as the type name. However, such columns defined in hive prior to HIVE-3976 have a name as "decimal". Those columns need to continue to work with a precision/scale as (10,0), per the functional doc. With patch in HIVE-3976, we may get the following error message in such case:

      0: jdbc:hive2://localhost:10000> desc dec;
      Error: Error while processing statement: FAILED: RuntimeException Decimal type is specified without length: decimal:int (state=42000,code=40000)
      

      This issue will be addressed in this JIRA as a follow-up task.

      1. HIVE-5564.1.patch
        6 kB
        Xuefu Zhang
      2. HIVE-5564.2.patch
        12 kB
        Xuefu Zhang
      3. HIVE-5564.3.patch
        12 kB
        Xuefu Zhang
      4. HIVE-5564.4.patch
        13 kB
        Xuefu Zhang
      5. HIVE-5564.patch
        6 kB
        Xuefu Zhang

        Issue Links

          Activity

          Xuefu Zhang created issue -
          Xuefu Zhang made changes -
          Field Original Value New Value
          Link This issue depends upon HIVE-3976 [ HIVE-3976 ]
          Xuefu Zhang made changes -
          Link This issue is part of HIVE-3065 [ HIVE-3065 ]
          Xuefu Zhang made changes -
          Attachment HIVE-5564.patch [ 12609004 ]
          Xuefu Zhang made changes -
          Link This issue is part of HIVE-3065 [ HIVE-3065 ]
          Xuefu Zhang made changes -
          Link This issue is part of HIVE-3976 [ HIVE-3976 ]
          Xuefu Zhang made changes -
          Attachment HIVE-5564.1.patch [ 12610951 ]
          Xuefu Zhang made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Xuefu Zhang made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Xuefu Zhang made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Xuefu Zhang made changes -
          Attachment HIVE-5564.2.patch [ 12612457 ]
          Xuefu Zhang made changes -
          Attachment HIVE-5564.3.patch [ 12612624 ]
          Xuefu Zhang made changes -
          Remote Link This issue links to "https://reviews.apache.org/r/15308/ (Web Link)" [ 13323 ]
          Xuefu Zhang made changes -
          Attachment HIVE-5564.4.patch [ 12612688 ]
          Xuefu Zhang made changes -
          Attachment HIVE-5564.4.patch [ 12612688 ]
          Xuefu Zhang made changes -
          Attachment HIVE-5564.4.patch [ 12613439 ]
          Xuefu Zhang made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]

            People

            • Assignee:
              Xuefu Zhang
              Reporter:
              Xuefu Zhang
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development