Search found 1 match

by hismaimai8888
Thu Nov 22, 2018 7:19 am
Forum: General
Topic: Usage of AT EPOCH LATEST in VIEW
Replies: 0
Views: 31822

Usage of AT EPOCH LATEST in VIEW

Hi, The queries running against views are taking time to execute when CDC is enabled(i.e. Delete/Update/Merge operation for the underlying tables). But Vertica is not allowing to use 'AT EPOCH LATEST' inside VIEW Definition as below: CREATE OR REPLACE VIEW ACCOUNT_view AS AT EPOCH LATEST SELECT Is t...

Go to advanced search