Hi,
Can we specify aggregate functions in projection definition? For e.g.
create projection p1 (sid , sales )
as select sid, sum(sales) from sales group by sid
I'm considering building an aggregated fact table and was wondering if a projection on top of the detail-level fact table would do the job?
Thanks.
Aggregation in Projections?
Moderator: NorbertKrupa
Re: Aggregation in Projections?
Hi!
No, since projection should relay a table structure, but due statistics and histograms that Vertica collects such aggregate functions as MIN,MAX,AVG,SUM should run fast. Partitioning and segmentation should improve performance.
No, since projection should relay a table structure, but due statistics and histograms that Vertica collects such aggregate functions as MIN,MAX,AVG,SUM should run fast. Partitioning and segmentation should improve performance.