[ 
https://issues.apache.org/jira/browse/IMPALA-14555?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Arnab Karmakar updated IMPALA-14555:
------------------------------------
    Description: 
* Support for applying a {{WHERE}} clause in {{SHOW PARTITIONS}} was introduced 
in IMPALA-14065{*}{*}. However, the implementation was scoped only to 
HDFS-backed tables, and Iceberg support was deferred for a follow-up Jira.
 * The core reason is architectural: Iceberg stores partition metadata in 
{*}manifest files{*}, not in filesystem directory structures as HDFS tables do.
 * Currently, running {{SHOW PARTITIONS WHERE}} against an Iceberg table 
results in the following analysis exception:

{code:java}
WHERE clause in SHOW PARTITIONS is only supported for HDFS tables {code}

  was:
Enable {{SHOW PARTITIONS … WHERE}} support for Iceberg tables.
*Description*
Support for applying a {{WHERE}} clause in {{SHOW PARTITIONS}} was first 
introduced in 
{*}[IMPALA-14065|{*}{*}[http://issues.apache.org/jira/browse/IMPALA-14065]{*}{*}]{*}.
 However, the implementation was scoped only to HDFS-backed tables, and Iceberg 
support was deferred for a follow-up Jira.
The core reason is architectural: Iceberg stores partition metadata in 
{*}manifest files{*}, not in filesystem directory structures as HDFS tables do. 
Currently, running {{SHOW PARTITIONS WHERE}} against an Iceberg table results 
in the following analysis exception:
{code:java}
WHERE clause in SHOW PARTITIONS is only supported for HDFS tables{code}


> Support Iceberg tables in SHOW PARTITIONS WHERE
> -----------------------------------------------
>
>                 Key: IMPALA-14555
>                 URL: https://issues.apache.org/jira/browse/IMPALA-14555
>             Project: IMPALA
>          Issue Type: Improvement
>          Components: Frontend
>            Reporter: Arnab Karmakar
>            Assignee: Arnab Karmakar
>            Priority: Major
>              Labels: ramp-up
>
> * Support for applying a {{WHERE}} clause in {{SHOW PARTITIONS}} was 
> introduced in IMPALA-14065{*}{*}. However, the implementation was scoped only 
> to HDFS-backed tables, and Iceberg support was deferred for a follow-up Jira.
>  * The core reason is architectural: Iceberg stores partition metadata in 
> {*}manifest files{*}, not in filesystem directory structures as HDFS tables 
> do.
>  * Currently, running {{SHOW PARTITIONS WHERE}} against an Iceberg table 
> results in the following analysis exception:
> {code:java}
> WHERE clause in SHOW PARTITIONS is only supported for HDFS tables {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to