[ https://issues.apache.org/jira/browse/HIVE-28537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17892693#comment-17892693 ]
Denys Kuzmenko commented on HIVE-28537: --------------------------------------- Merged to master Thanks [~zratkai] for the patch and [~difin] for the review! > Iceberg: Compaction: 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 > Labels: Compaction, pull-request-available > > 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)