gnailJC commented on issue #5586:
URL: https://github.com/apache/hudi/issues/5586#issuecomment-1127387241
> hi @gnailJC Thanks for the question, now `timestamp as of` only supports
`table` operations, not `view` related operations yet. If there is a business
scenario requirement, we can implement it, and mention a jira.
thanks for your reply! I need to create a view based on hudi table data on a
special old instant to query the old data.
so I try two way to get it.
1. use `create view xx select * from hudi_tbl timestamp as of xxxx`, and
it's not support yet we know.
2. so i try the second way, like
`CREATE external TABLE tbl_snapshot_v20220512164415876
using hudi
options (
as.of.instant=20220513103255808
) LOCATION 'xxxx;`
create a table first, and create a view based on this table.
but the `as.of.instant` is not work, it always query the latest snapshot,
why?
and now I try use inc query:
`
CREATE external TABLE tbl_inc_v20220512170625756
using hudi
options (
hoodie.datasource.query.type='incremental',
hoodie.datasource.read.begin.instanttime=0,
hoodie.datasource.read.end.instanttime=20220512170625756
) LOCATION 'xxx';
`
and the `hoodie.datasource.read.end.instanttime` is work! so why the
`as.of.instant` can't but the ` hoodie.datasource.read.end.instanttime` can
work?
--
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]
