[
https://issues.apache.org/jira/browse/HIVE-28537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dmitriy Fingerman updated HIVE-28537:
-------------------------------------
Description:
Currently Hive Iceberg compaction supports any columns in the WHERE clause
predicate. However, compaction happens only on partition level. Performance can
be improved if the columns in WHERE clause predicate will be limited to
partition columns.
For example, Athena project supports only partition columns in the WHERE clause:
[https://docs.aws.amazon.com/athena/latest/ug/optimize-statement.html]
{{}}
{code:java}
Only partition columns are allowed in the WHERE clause predicate. Specifying a
non-partition column will cause the query to fail.{code}
{{}}
was:
Currently Hive Iceberg compaction supports any columns in the WHERE clause
predicate. However, compaction happens only on partition level. Performance can
be improved if the columns in WHERE clause predicate will be limited to
partition columns.
For example, Athena project supports only partition columns in the WHERE clause:
https://docs.aws.amazon.com/athena/latest/ug/optimize-statement.html
> Iceberg: allow only partition columns in the WHERE clause predicate
> -------------------------------------------------------------------
>
> Key: HIVE-28537
> URL: https://issues.apache.org/jira/browse/HIVE-28537
> Project: Hive
> Issue Type: Improvement
> Security Level: Public(Viewable by anyone)
> Components: Hive, Iceberg integration
> Reporter: Dmitriy Fingerman
> Assignee: Dmitriy Fingerman
> Priority: Major
>
> Currently Hive Iceberg compaction supports any columns in the WHERE clause
> predicate. However, compaction happens only on partition level. Performance
> can be improved if the columns in WHERE clause predicate will be limited to
> partition columns.
> For example, Athena project supports only partition columns in the WHERE
> clause:
> [https://docs.aws.amazon.com/athena/latest/ug/optimize-statement.html]
> {{}}
> {code:java}
> Only partition columns are allowed in the WHERE clause predicate. Specifying
> a non-partition column will cause the query to fail.{code}
> {{}}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
