jimmyz created HUDI-4729:
----------------------------

             Summary: File group in pending compaction can not be queried when 
query ro table with spark
                 Key: HUDI-4729
                 URL: https://issues.apache.org/jira/browse/HUDI-4729
             Project: Apache Hudi
          Issue Type: Bug
          Components: spark-sql
            Reporter: jimmyz


reproduced steps:
1. create table
      
{code:sql}
create table h0 (
        id int,
        name string,
        price double,
        ts long
      ) using hudi
       partitioned by (ts)
       location 
'/private/var/folders/7p/8jjkvq110l348cd34v5lvbsc0000gn/T/spark-425a5d4e-6b7d-440e-b071-3c524f3ca727/h0'
       tblproperties (
        type = 'mor',
        primaryKey = 'id',
        preCombineField = 'ts'
       )
{code}

2. insert data
{code:sql}
insert into h0 values(1, 'a1', 10, 1000)
{code}

3. update data
{code:sql}
update h0 set price = 11 where id = 1
{code}

4. schedule compaction
{code:sql}
call run_compaction(table => 'h0', op = 'schedule')
{code}

5. when run sql 'select count(*) from h0', we got 0 but expected 1
               



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to