Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Combining flattened table and Live Aggregate Projections for denormalized table with aggregates?

Regarding flattened table and Live Aggregate Projections, is it possible to combine these two techniques in order to produce denormalized table with aggregates?


Question from The shortest path to Vertica: Best practices for data warehouse migration & ETL
@marcothesane @Maurizio

Answers

  • ybeiybei Employee

    yes, that's the feature we supported in 9.2, allowing FT refresh_columns run on LAP. In 9.2.1 we support partition-based refresh_columns on FT. In 9.3 we supported partition-based refresh_columns on FT with LAP.
    In general, we attempt to extend FT/LAP capability every release. I can dig up more history if needed.

  • marcothesanemarcothesane Administrator

    We are actually doing this very thing in an important PoC that is running in Spain as we speak. And the results are very impressive.

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.