You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@hudi.apache.org by GitBox <gi...@apache.org> on 2020/10/26 18:58:55 UTC

[GitHub] [hudi] getniz commented on issue #2201: hoodie_commit_timestamp time travel queries - can we implement operational analytics

getniz commented on issue #2201:
URL: https://github.com/apache/hudi/issues/2201#issuecomment-716757315


   Thank you for the detail response @n3nash , in above  hive query is there a easy way to determine number of commits for a particular end timestamp. For deletes let me put an example here, assume I have 6 rows as below. If the record for Feb 2019 is deleted on May 2020. With that being said, If I run a report for Jan to Mar 2019 Sales vs Jan to Mar 2020 Sales will the Feb 2019 sales record be included in the total sales? Or it will consider the delete and the feb 2019 sales will be excluded in the total sales?  
   Month|Yr|Sales|hoodie_commit_ts
   Jan,2019,$9000,Feb 28
   Feb,2019,$5000,Mar 31
   Mar,2019,$4000,Apr 30
   Jan,2020,$3500,Feb 28
   Feb,2020,$2000,Mar 31
   Mar,2020,$6000,Apr 30
   


----------------------------------------------------------------
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:
users@infra.apache.org