You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Dmitriy Fingerman (Jira)" <ji...@apache.org> on 2024/09/25 16:07:00 UTC

[jira] [Created] (HIVE-28537) Iceberg: allow only partition columns in the WHERE clause predicate

Dmitriy Fingerman created HIVE-28537:
----------------------------------------

             Summary: 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


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



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