Rajkumar Singh created HIVE-22945:
-------------------------------------
Summary: Hive ACID Data Corruption: Update command mess the other
column data and produces incorrect result
Key: HIVE-22945
URL: https://issues.apache.org/jira/browse/HIVE-22945
Project: Hive
Issue Type: Bug
Components: Hive, Transactions
Affects Versions: 3.2.0
Reporter: Rajkumar Singh
Hive Update Operation update the other column incorrectly and produces
incorrect results:
Steps to reproduce:
{code:java}
CREATE TABLE `test`(
`start_dt` timestamp,
`stop_dt` timestamp
);
INSERT INTO test (start_dt, stop_dt) SELECT CURRENT_TIMESTAMP, CAST(NULL AS
TIMESTAMP);
select * from test;
+--------------------------+---------------+
| test.start_dt | test.stop_dt |
+--------------------------+---------------+
| 2020-02-28 20:06:29.116 | NULL |
+--------------------------+---------------+
UPDATE test SET STOP_DT = CURRENT_TIMESTAMP WHERE CAST(START_DT AS DATE) =
CURRENT_DATE;
+------------------------+--------------------------+
| test.start_dt | test.stop_dt |
+------------------------+--------------------------+
| 2020-02-28 00:00:00.0 | 2020-02-28 20:07:12.248 |
+------------------------+--------------------------+
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
