Search found 1 match
- Thu Nov 22, 2018 7:19 am
- Forum: General
- Topic: Usage of AT EPOCH LATEST in VIEW
- Replies: 0
- Views: 31825
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...