Where clause in LAP

prad33p2301

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.

Vertica_Curtis

I've never tried it with a LAP, but you could try a Partition Range Projection.
https://docs.vertica.com/24.2.x/en/admin/projections/partition-range-projections/

Otherwise, a LAP is generally very small. It might take a bit to create it, but once built, shouldn't eat up a ton of resources.