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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
