[jira] [Commented] (IMPALA-14065) Support WHERE clause in SHOW PARTITIONS

["Michael Smith (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IMPALA-14065?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18037884#comment-18037884 ] 

Michael Smith commented on IMPALA-14065:
----------------------------------------

Are there other engines with similar functionality? Is there an existing pattern we should consider?

Looking, I found:
* [Spark](https://spark.apache.org/docs/latest/sql-ref-syntax-aux-show-partitions.html) and [Databricks](https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-aux-show-partitions) provide {{SHOW PARTITIONS part_tbl PARTITION (year = 2025, month = 6)}} to select a specific partition, or can use a partial spec {{(year = 2025)}}.
* [Starrocks](https://docs.starrocks.io/docs/sql-reference/sql-statements/table_bucket_part_index/SHOW_PARTITIONS/) supports a similar syntax to that proposed here.
* [Cockroach](https://www.cockroachlabs.com/docs/stable/show-partitions#querying-partitions-programmatically) provides a meta table to support querying partitions using {{WHERE}} and other modifiers.

So this syntax seems reasonable. 

> Support WHERE clause in SHOW PARTITIONS
> ---------------------------------------
>
>                 Key: IMPALA-14065
>                 URL: https://issues.apache.org/jira/browse/IMPALA-14065
>             Project: IMPALA
>          Issue Type: New Feature
>          Components: Backend, Frontend
>            Reporter: Quanlong Huang
>            Assignee: Arnab Karmakar
>            Priority: Major
>              Labels: ramp-up
>
> SHOW PARTITIONS <table> is a useful statement to check #Rows, #Files and size, etc. of partitions. Sometimes we just want to check the new partitions. It'd be helpful to support a WHERE clause in this statement to simplify the output, especially for tables with lots of partitions.
> An example statement:
> {code:sql}
> show partitions part_tbl where year = 2025 and month < 6;{code}



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

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org