Aggregation in Projections?

Moderator: NorbertKrupa

Post Reply
sean
Newbie
Newbie
Posts: 11
Joined: Mon Sep 10, 2012 6:52 pm

Aggregation in Projections?

Post by sean » Mon Sep 10, 2012 7:03 pm

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.

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Aggregation in Projections?

Post by id10t » Mon Sep 10, 2012 8:49 pm

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.

Post Reply

Return to “Vertica Database Development”