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?
Usage of AT EPOCH LATEST in VIEW
Moderator: NorbertKrupa
-
hismaimai8888
- Newbie
- Posts: 1
- Joined: Thu Nov 22, 2018 7:10 am
- Contact:
Usage of AT EPOCH LATEST in VIEW
Công ty rut ham cau quan 12 giá rẻ dịch vụ rút hầm cầu quận 12 uy tín