[GitHub] [hudi] eyjian commented on issue #8757: [SUPPORT] How to get a row of a primary key?

2023-05-25 Thread via GitHub
eyjian commented on issue #8757: URL: https://github.com/apache/hudi/issues/8757#issuecomment-1563690431 > PartialUpdateAvroPayload is only supported in 0.13.0. > > So Can you try with that version and let us know if you still get the issue. I confirmed its working as expected as past

[GitHub] [hudi] eyjian commented on issue #8757: [SUPPORT] How to get a row of a primary key?

2023-05-23 Thread via GitHub
eyjian commented on issue #8757: URL: https://github.com/apache/hudi/issues/8757#issuecomment-1559255957 > @eyjian Can you provide more details on your env, I was not able to reproduce your error as stated above. Hudi: 0.12.0 -- This is an automated message from the Apache Git Serv

[GitHub] [hudi] eyjian commented on issue #8757: [SUPPORT] How to get a row of a primary key?

2023-05-19 Thread via GitHub
eyjian commented on issue #8757: URL: https://github.com/apache/hudi/issues/8757#issuecomment-1554184806 Create table: ``` drop table if exists t31 purge; create table t31 ( ds BIGINT, ut STRING, pk BIGINT, f0 BIGINT, f1 BIGINT, f2 BIGINT

[GitHub] [hudi] eyjian commented on issue #8757: [SUPPORT] How to get a row of a primary key?

2023-05-18 Thread via GitHub
eyjian commented on issue #8757: URL: https://github.com/apache/hudi/issues/8757#issuecomment-1554076777 > You have to use upsert only to use partial update. So with Spark sql you must use merge into or update as Insert will act as insert operationType for which hudi doesn't guarantee uniqu

[GitHub] [hudi] eyjian commented on issue #8757: [SUPPORT] How to get a row of a primary key?

2023-05-18 Thread via GitHub
eyjian commented on issue #8757: URL: https://github.com/apache/hudi/issues/8757#issuecomment-1554065728 Create table: ```sql CREATE TABLE `test_db`.`t21` ( `_hoodie_commit_time` STRING, `_hoodie_commit_seqno` STRING, `_hoodie_record_key` STRING, `_hoodie_partiti

[GitHub] [hudi] eyjian commented on issue #8757: [SUPPORT] How to get a row of a primary key?

2023-05-18 Thread via GitHub
eyjian commented on issue #8757: URL: https://github.com/apache/hudi/issues/8757#issuecomment-1554061049 > Did you try update or merge into clause? Thank you. I will try to update and merge, but I need upsert to update a wide table. Each rows are in a different parquet file. -- Thi