bithw1 commented on issue #7994:
URL: https://github.com/apache/hudi/issues/7994#issuecomment-1442713934
> Specify the end query time point is how we get the history records, as
long as the instant is still alive in the timeline.
In my scenario as described in the question area, I updated **all** the
records in the last commit, then I can't get back the historic commits time, so
that I can't do point in time query like the following because I don't know how
to get back the historical commit times (`select distinct _hoodie_commit_time
from mytable` won't work in my scenario, this is my question here)
```
Seq("<the first commit time>", "<the second commit
time>").foreach(point_in_time => {
val df = spark.read.
format("hudi").
option("as.of.instant", point_in_time).
load(base_path)
df.show()
```
--
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]
