getniz opened a new issue #2201: URL: https://github.com/apache/hudi/issues/2201
In Apache HUDI, with hoodie_commit_timestamp time travel option can we implement operational analytics query like Q1 Inventory in Previous Year vs Q1 Inventory of Current Year. Also, in case of any delete operations(assume soft delete or hard delete) performed on this table in previous year data will that have impact on the Point-in-time queries. To achieve this as per DW standard, Should I need to implement a separate pipeline to take snapshot of the table in separate schema/table and periodically sync only the incremental changes from the original table by ignoring the deletes forming SCD type 2/3 table and use it for the analytics requirement. I'm looking for any suggestions and experience on anybody tried this in HUDI. ---------------------------------------------------------------- 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]
