Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Expose lastddltime of hive views #8805

Closed
tooptoop4 opened this issue Aug 5, 2021 · 1 comment · Fixed by #8810
Closed

Expose lastddltime of hive views #8805

tooptoop4 opened this issue Aug 5, 2021 · 1 comment · Fixed by #8810

Comments

@tooptoop4
Copy link
Contributor

tooptoop4 commented Aug 5, 2021

Using trino there doesn't seem to be way to see the last time a Hive view was modified. Hive tables show transient_lastddltime in $properties. Perhaps Hive views should also have their own $properties ? Or alternatively add this value in information_schema.views

Having this would allow to answer the Q: what views were changed in the last 24hrs

@ebyhr
Copy link
Member

ebyhr commented Aug 5, 2021

Though I'm not sure about the context, the view support is disabled at

if (table.isEmpty() || table.get().getTableType().equals(TableType.VIRTUAL_VIEW.name())) {

We can get transient_lastddltime once we remove the 2nd condition.

trino> SELECT * FROM hive.default."v8805$properties";
 bucketing_version | transient_lastddltime
-------------------+-----------------------
 2                 | 1628177271

Relates to #268

cc: @kokosing @electrum

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

Successfully merging a pull request may close this issue.

2 participants