You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@paimon.apache.org by "zhoulii (via GitHub)" <gi...@apache.org> on 2025/12/29 02:37:00 UTC

[I] [Bug] flink show partitions statement may not work for dv table. [paimon]

zhoulii opened a new issue, #6920:
URL: https://github.com/apache/paimon/issues/6920

   ### Search before asking
   
   - [x] I searched in the [issues](https://github.com/apache/paimon/issues) and found nothing similar.
   
   
   ### Paimon version
   
   1.0
   
   ### Compute Engine
   
   flink 1.18
   
   ### Minimal reproduce step
   
   ```java
   sql(
                   "CREATE TABLE PartitionTableWithDVEnabled (\n"
                           + "    user_id BIGINT,\n"
                           + "    item_id BIGINT,\n"
                           + "    behavior STRING,\n"
                           + "    dt STRING,\n"
                           + "    hh STRING,\n"
                           + "    PRIMARY KEY (dt, hh, user_id) NOT ENFORCED\n"
                           + ") PARTITIONED BY (dt, hh) WITH ('deletion-vectors.enabled'='true', 'write-only'='true')");
           sql("INSERT INTO PartitionTableWithDVEnabled select 1,1,'a','2020-01-01','10'");
           sql("INSERT INTO PartitionTableWithDVEnabled select 2,2,'b','2020-01-02','11'");
           sql("INSERT INTO PartitionTableWithDVEnabled select 3,3,'c','2020-01-03','11'");
           result = sql("SHOW PARTITIONS PartitionTableWithDVEnabled");
           assertThat(result)
                   .containsExactlyInAnyOrder(
                           Row.of("dt=2020-01-01/hh=10"),
                           Row.of("dt=2020-01-02/hh=11"),
                           Row.of("dt=2020-01-03/hh=11"));
   
           result = sql("SHOW PARTITIONS PartitionTableWithDVEnabled partition (hh='11')");
           assertThat(result)
                   .containsExactlyInAnyOrder(
                           Row.of("dt=2020-01-02/hh=11"), Row.of("dt=2020-01-03/hh=11"));
   
           result =
                   sql(
                           "SHOW PARTITIONS PartitionTableWithDVEnabled partition (dt='2020-01-02', hh='11')");
           assertThat(result).containsExactlyInAnyOrder(Row.of("dt=2020-01-02/hh=11"));
   ```
   
   ### What doesn't meet your expectations?
   
   `SHOW PARTITIONS [TABLE]` can not list the existed partitions.
   
   ### Anything else?
   
   _No response_
   
   ### Are you willing to submit a PR?
   
   - [x] I'm willing to submit a PR!


-- 
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: issues-unsubscribe@paimon.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] [Bug] flink show partitions statement may not work for dv table. [paimon]

Posted by "JingsongLi (via GitHub)" <gi...@apache.org>.
JingsongLi closed issue #6920: [Bug] flink show partitions statement may not work for dv table.
URL: https://github.com/apache/paimon/issues/6920


-- 
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: issues-unsubscribe@paimon.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org