n3nash commented on issue #2201: URL: https://github.com/apache/hudi/issues/2201#issuecomment-718038487
@getniz I think what you're looking for is what @tooptoop4 pointed out, you want to read the table at certain instant in time. You can do this via _hoodie_commit_time. Please note that you will need to keep all the versions of data to be able to go back in time and query older versions. You might want to set the cleaner policy here- > https://hudi.apache.org/docs/configurations.html#withCleanerPolicy to the VERSION_RETAINED and then set the number of versions of the table you want to go back to. Then, you can do ``` select * from table where _hoodie_commit_time < "instant time before you deleted record for Feb" This will give the the un-deleted record. ``` ``` select * from table where _hoodie_commit_time < "instant time after you deleted record for Feb" This will give the the contents of the table with the record deleted. ``` ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected]
