[jira] [Created] (IMPALA-11320) SHOW PARTITIONS on Iceberg table doesn't list the partitions

["Zoltán Borók-Nagy (Jira)" <ji...@apache.org>]

Zoltán Borók-Nagy created IMPALA-11320:
------------------------------------------

             Summary: 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: Zoltán Borók-Nagy


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)