[
https://issues.apache.org/jira/browse/IMPALA-14065?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18044489#comment-18044489
]
ASF subversion and git services commented on IMPALA-14065:
----------------------------------------------------------
Commit ddd82e02b93abe5fba0a971cd993543e7c3ddea1 in impala's branch
refs/heads/master from Arnab Karmakar
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=ddd82e02b ]
IMPALA-14065: Support WHERE clause in SHOW PARTITIONS statement
This patch extends the SHOW PARTITIONS statement to allow an optional
WHERE clause that filters partitions based on partition column values.
The implementation adds support for various comparison operators,
IN lists, BETWEEN clauses, IS NULL, and logical AND/OR expressions
involving partition columns.
Non-partition columns, subqueries, and analytic expressions in the
WHERE clause are not allowed and will result in an analysis error.
New analyzer tests have been added to AnalyzeDDLTest#TestShowPartitions
to verify correct parsing, semantic validation, and error handling for
supported and unsupported cases.
Testing:
- Added new unit tests in AnalyzeDDLTest for valid and invalid WHERE
clause cases.
- Verified functional tests covering partition filtering behavior.
Change-Id: I2e2a14aabcea3fb17083d4ad6f87b7861113f89e
Reviewed-on: http://gerrit.cloudera.org:8080/23566
Reviewed-by: Impala Public Jenkins <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>
> 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: [email protected]
For additional commands, e-mail: [email protected]
