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
Question
Combining flattened table and Live Aggregate Projections for denormalized table with aggregates?
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.
+1We are actually doing this very thing in an important PoC that is running in Spain as we speak. And the results are very impressive.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
