dramaticlly opened a new issue, #7560:
URL: https://github.com/apache/iceberg/issues/7560

   ### Feature Request / Improvement
   
   It would be nice to provide last updated timestamp in partition metadata 
table to see if there's any change applied to given partition. 
   
    According to @szehon-ho , today this can be done via following SQL
   ```sql
   SELECT 
   e.data_file.partition,
   MAX(s.committed_at) AS last_modified_time
   FROM db.table.snapshots s 
   JOIN db.table.entries e 
   WHERE s.snapshot_id = e.snapshot_id 
   GROUP BY by e.data_file.partition
   ```
   
   which join the entries table and snapshot together to derive the max 
snapshot commit timestamp group by partition, however this feature request 
attempt to provide native support in partition metadata table
   
   ### Query engine
   
   None


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to