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?
1 post • Page 1 of 1