[
https://issues.apache.org/jira/browse/HIVE-10481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14511616#comment-14511616
]
Alan Gates commented on HIVE-10481:
-----------------------------------
+1, assuming all the other IUD and ACID tests pass.
> 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
> Attachments: HIVE-10481.patch
>
>
> 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)
