zhoulii opened a new issue, #10932:
URL: https://github.com/apache/paimon/issues/10932

   ### Search before asking
   
   - [x] I searched in the [issues](https://github.com/apache/paimon/issues) 
and found nothing similar.
   
   
   ### Motivation
   
   Snapshots can store properties such as checkpoint and recovery metadata, but 
the `$snapshots` system table does not expose them. Users must inspect snapshot 
JSON or use an API to view these properties.
   
   Exposing them through SQL would make commit inspection and troubleshooting 
easier.
   
   ### Solution
   
   - Append a nullable `properties MAP<STRING, STRING>` column to `$snapshots`.
   - Return `NULL` when a snapshot has no properties.
   - Allow queries to select and filter properties by key:
   
   ```sql
   SELECT snapshot_id, properties['source.batch-id'] AS batch_id
   FROM my_table$snapshots
   WHERE properties['source.batch-id'] = '42';
   ```
   
   ### Anything else?
   
   This exposes existing metadata without changing the snapshot storage format 
or commit behavior.
   
   ### Are you willing to submit a PR?
   
   - [x] I'm willing to submit a PR!


-- 
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]

Reply via email to