difin commented on code in PR #5792:
URL: https://github.com/apache/hive/pull/5792#discussion_r2082259745


##########
iceberg/iceberg-handler/src/main/java/org/apache/iceberg/mr/hive/compaction/IcebergQueryCompactor.java:
##########
@@ -96,16 +106,46 @@ public boolean run(CompactorContext context) throws 
IOException, HiveException,
         throw new HiveException(ErrorMsg.COMPACTION_NO_PARTITION);
       }
     } else {
-      long partitionHash = IcebergTableUtil.getPartitionHash(icebergTable, 
partSpec);
+      Pair<Integer, StructProjection> partSpecPair =
+          IcebergTableUtil.getPartitionSpecIdAndStruct(icebergTable, partSpec);

Review Comment:
   > why can't we do this directly on FILES table? 
   
   Because we need to know the values that need to be used in the 
`named_struct`, but IcebergQueryCompactor gets partition name in the human 
readable format and partition values needs to be retrieved and converted.
   
   An example from existing Iceberg compaction q-test: 
   
   - we compact a table with partition spec:`spec(truncate(3, event_src), 
month(event_time))`. 
   - IcebergQueryCompactor gets `ci.partName` = 
`event_src_trunc=BBB/event_time_month=2024-08`.
   - The query on the `files` table needs to be `select FILE_PATH from 
default.ice_orc.files where `partition` = 
named_struct("event_src_trunc","AAA",event_time_month,655);`
   
   event_time_month value `2024-08` is a human readable format it cannot be 
used as is in the query on files metadata table, it needs to be converted to 
`655`.
   
   To do that I am listing `partitions` table to find the` spec id` and 
partition struct for the given `ci.partName` and applying conversions to get 
the values that can be used in the condition on `partition` field from `files` 
metatable.
   



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org

Reply via email to