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

Type decimal(1,1) reads 0.0, 0.00, etc from text file as NULL

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.0, 1.1.0, 2.0.0
    • Fix Version/s: 1.3.0, 2.0.0
    • Component/s: Types
    • Labels:
      None

      Description

      Steps to reproduce:
      1. create a text file with values like 0.0, 0.00, etc.
      2. create table in hive with type decimal(1,1).
      3. run "load data local inpath ..." to load data into the table.
      4. run select * on the table.
      You will see that NULL is displayed for 0.0, 0.00, .0, etc. Instead, these should be read as 0.0.

        Attachments

        1. HIVE-11835.patch
          2 kB
          Xuefu Zhang
        2. HIVE-11835.1.patch
          420 kB
          Xuefu Zhang
        3. HIVE-11835.2.patch
          9 kB
          Xuefu Zhang

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: