Usage of AT EPOCH LATEST in VIEW
Posted: Thu Nov 22, 2018 7:19 am
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?
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?