LAP - anchor table
What is exact definition of ANCHOR PROJECTION? Its not clear from docs
Anchor ProjectionSometimes I get after I created an anchor projection (I think that I created, but actually its not):
An anchor projection is the physical storage for the anchor table data.
Before you create a live aggregate projection, you must create an anchor projection for the anchor table. The anchor projection's segmentation must be a subset of the live aggregate projection's segmentation. Each anchor table used for a live aggregate projection must have at least one anchor projection.
When you create a Top-K projection, the anchor table must have at least one projection that has the same PARTITION BY definition as in the CREATE PROJECTION statement. This projection is the anchor projection for the Top-K projection.
ROLLBACK 0: Cannot create aggregate/top-k projection: no suitable anchor projection.So I can't understand what does it mean ANCHOR PROJECTION.
Group-by/Partition-by columns of aggregate/top-k projection must be in the same order as and include all the segmentation columns of the anchor projection.
Anchor projection must contain all columns of the aggregate/top-k projection.
Anchor projection must be segmented by hash in case of multinode database.
Anchor projection must be ksafe