ad1happy2go commented on issue #11212:
URL: https://github.com/apache/hudi/issues/11212#issuecomment-2109406145
@Amar1404 Can you please try 0.14.1. This was fixed. I tried below code also
to demonstrate -
```
DROP TABLE issue_11212;
set hoodie.spark.sql.insert.into.operation=bulk_insert;
CREATE TABLE issue_11212 (
ts BIGINT,
uuid STRING,
rider STRING,
driver STRING,
fare DOUBLE,
city STRING
) USING HUDI
OPTIONS(
'hoodie.datasource.write.recordkey.field'='uuid',
'hoodie.datasource.write.precombine.field'='ts',
'hoodie.datasource.write.operation'='bulk_insert'
);
INSERT INTO issue_11212
VALUES
(1695159649087,'334e26e9-8355-45cc-97c6-c31daf0df330','rider-A','driver-K',19.10,'san_francisco');
INSERT INTO issue_11212
VALUES
(1695159649087,'334e26e9-8355-45cc-97c6-c31daf0df330','rider-C','driver-L',19.10,'san_francisco');
select * from issue_11212 where uuid =
'334e26e9-8355-45cc-97c6-c31daf0df330';
SELECT * FROM issue_11212 WHERE uuid =
'334e26e9-8355-45cc-97c6-c31daf0df330' and _hoodie_commit_seqno = '<seq no>';
DELETE FROM issue_11212 WHERE uuid = '334e26e9-8355-45cc-97c6-c31daf0df330'
and _hoodie_commit_seqno = '<seq no>'
select * from issue_11212 where uuid =
'334e26e9-8355-45cc-97c6-c31daf0df330';
```
Can you please check above and let us know.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
