[ https://issues.apache.org/jira/browse/IMPALA-11320?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17555112#comment-17555112 ]
Zoltán Borók-Nagy commented on IMPALA-11320: -------------------------------------------- Hi [~gaoxiaoqing], are you still working on this item? > 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