[
https://issues.apache.org/jira/browse/IMPALA-11320?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zoltán Borók-Nagy reassigned IMPALA-11320:
------------------------------------------
Assignee: gaoxiaoqing
> SHOW PARTITIONS on Iceberg table doesn't list the partitions
> ------------------------------------------------------------
>
> Key: IMPALA-11320
> URL: https://issues.apache.org/jira/browse/IMPALA-11320
> Project: IMPALA
> Issue Type: Bug
> Components: Frontend
> Reporter: Dharmik Thakkar
> Assignee: gaoxiaoqing
> Priority: Major
> Labels: impala-iceberg
>
> Currently, SHOW PARTITIONS on Iceberg tables only outputs the partition spec
> which is not too useful.
> E.g.:
>
> {noformat}
> [localhost:21050] default> create table ice_part (i int, j int) partitioned
> by spec (i, bucket(9, j)) stored as iceberg;
> ...
> [localhost:21050] default> show partitions ice_part;
> +--------------+-----------+----------+------------+---------------------------+
> | Partition Id | Source Id | Field Id | Field Name | Field Partition
> Transform |
> +--------------+-----------+----------+------------+---------------------------+
> | 0 | 1 | 1000 | i | IDENTITY
> |
> | 0 | 2 | 1001 | j_bucket | BUCKET 9
> |
> +--------------+-----------+----------+------------+---------------------------+{noformat}
> Instead it should output the concrete partitions, number of files, number of
> rows in each partitions, similarly to Hive:
> [https://github.com/apache/hive/blob/34b24d55ade393673424f077b69add43bad9f731/iceberg/iceberg-handler/src/test/results/positive/query_iceberg_metadata_of_partitioned_table.q.out#L306-L316]
> {noformat}
> query: select * from default.ice_meta_3.partitions
> {"b":"four","c":"Saturday"} 3 1
> {"b":"four","c":"Sunday"} 1 1
> {"b":"four","c":"Thursday"} 1 1
> {"b":"one","c":"Monday"} 3 1
> {"b":"three","c":"Wednesday"} 3 1
> {"b":"two","c":"Friday"} 2 1
> {"b":"two","c":"Tuesday"} 2 1
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org
