Options

# LAP - anchor table

Hi!

What is exact definition of ANCHOR PROJECTION? Its not clear from docs

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

0

## Comments

I too got confused with this first, but then I figured it out.

Anchor Projection is nothing but the a base projection for LAP with its rules on Segmentation columns and segmentation method.

This really leaves us with with 3 copies of same data.

A Super projection

A Anchor Projection

a Live Aggregate projection.

NC

Thanks for response.

What means "a base projection"? Same columns, same segmentation, same columns order but "pure" columns? Without any expression/group by, etc?

Thanks.

Question can be closed.

Thanks Navin for help.