Page 1 of 1

Usage of AT EPOCH LATEST in VIEW

Posted: Thu Nov 22, 2018 7:19 am
by hismaimai8888
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 there an alternative for this?