Eugene Koifman created HIVE-10481:
-------------------------------------

             Summary: ACID table update finishes but values not really updated 
if column names are not all lower case
                 Key: HIVE-10481
                 URL: https://issues.apache.org/jira/browse/HIVE-10481
             Project: Hive
          Issue Type: Bug
          Components: Transactions
    Affects Versions: 1.0.0
            Reporter: Eugene Koifman
            Assignee: Eugene Koifman


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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to