How to aggregate and push data for certain period?

I'm working with huge table in Vertica db, and every day need to get some aggregation about last days, can I make a live Top-K Projection, that will work for last day or not?

I need something that will aggregate data for the current day(or previous) and push it to table with information about all previous day.

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.