Usage of AT EPOCH LATEST in VIEW

Moderator: NorbertKrupa

Post Reply
hismaimai8888
Newbie
Newbie
Posts: 1
Joined: Thu Nov 22, 2018 7:10 am
Contact:

Usage of AT EPOCH LATEST in VIEW

Post by hismaimai8888 » 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?
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

Post Reply

Return to “General”