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

ACID table update finishes but values not really updated if column names are not all lower case

    Details

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

      Description

      Column in table is defined with upper case or mixed case, when do update command with verbatim column names, update doesn't update the value. when do update with all lower case column names, it works.
      STEPS TO REPRODUCE:
      create table testable( a string, Bb string, c string)
      clustered by (c) into 3 buckets
      stored as orc
      tblproperties("transactional"="true");
      insert into table testable values ('a1','b1','c1), ('a2','b2','c2'), ('a3','b3','c3');
      update table testable set Bb='bb';
      job finishes, but the values are not really updated.
      update table testable set bb='bb'; it works.

        Attachments

        1. HIVE-10481.2.patch
          3 kB
          Eugene Koifman
        2. HIVE-10481.patch
          3 kB
          Eugene Koifman

          Issue Links

            Activity

              People

              • Assignee:
                ekoifman Eugene Koifman
                Reporter:
                ekoifman Eugene Koifman
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: