lethrez opened a new issue #4502:
URL: https://github.com/apache/hudi/issues/4502
**_Tips before filing an issue_**
Just a quick question that might even end up as yes/no.
I've been looking into having a Hudi table queried by Athena. And wondering
about the compatibility of time travel queries.
To my understanding, there is functionality with presto/spark but this isn't
supported in hive. in order to build the time travel query use
`_hoodie_commit_time`. What is the efficiency like in using this method and
would it be best practice?
I was scanning some of the older issues and would an example like the
following be appropriate? (note the project has developed a bit since then and
wanted to make sure this is still the case)
https://github.com/apache/hudi/issues/2201
```
As you can imagine, there is already a "hacky" way to achieve time travel
using the following methodology : select * from table where _hoodie_commit_time
<= point_in_time. Obviously, this is not very efficient and can also lead to
inconsistent results since the point_in_time might be different that the hoodie
def~instant-time.
```
https://cwiki.apache.org/confluence/display/HUDI/RFC+-+07+%3A+Point+in+time+Time-Travel+queries+on+Hudi+table
A clear and concise description of what you expected to happen.
**Environment Description**
* Hudi version : 0.10.0
* Hive version : Glue Catalogue / Athena
--
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: commits-unsubscr...@hudi.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
