Creating Live Aggregate Projection

Moderator: NorbertKrupa

Posts: 53
Joined: Thu Jun 21, 2012 11:05 am
Location: London, UK

Re: Creating Live Aggregate Projection

Post by Timbo » Tue Nov 24, 2015 9:45 am

Thanks Sharon, the following worked ok:-
CREATE PROJECTION point_max_lastupdated_agg AS
SELECT instrument_id, element_id ,max(last_updated) AS max_timestamp FROM Phoenix1.Point
group by instrument_id, element_id

select refresh('PHOENIX1.point');

select make_ahm_now();

Now to see if there are any performance improvements and it is used automatically.

Post Reply

Return to “Vertica Performance Tuning”