Options

Where clause in LAP

hi,

I have to create Live Aggregate projection for a table which has 100Billion records.

I see we are not allowed to include where clause in the projection definition. Is there a way I can filter out data before aggregating them?

The anchor table has 30-40% of data which I dont to participate in the aggregation.

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file