[HIVE-10481] ACID table update finishes but values not really updated if column names are not all lower case

• 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
• Assignee: Eugene Koifman
• Reporter: Eugene Koifman
• Created: 24/Apr/15 19:34
• Updated: 01/Oct/19 22:07
• Resolved: 28/Apr/15 23:19

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.

Issue Links

• is related to: HIVE-18104 Issue in HIVE Update Command for set columns