You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Zoltán Borók-Nagy (Jira)" <ji...@apache.org> on 2022/06/16 14:50:00 UTC
[jira] [Commented] (IMPALA-11320) SHOW PARTITIONS on Iceberg table doesn't list the partitions
[ 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-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org