You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Zoltán Rátkai (Jira)" <ji...@apache.org> on 2024/09/27 15:18:00 UTC
[jira] [Work started] (HIVE-28537) Iceberg: allow only partition columns in the WHERE clause predicate
[ https://issues.apache.org/jira/browse/HIVE-28537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on HIVE-28537 started by Zoltán Rátkai.
--------------------------------------------
> 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: Zoltán Rátkai
> 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)