How to compute flex table keys on subset of very large table

Flex table grew and grew... and grew... and grew more... and grew again... and so on.
Now, compute flex table keys are not going to finish in any reasonable time. And it does have new keys coming...
How I can compute flex table keys on recent date partitions only.
Thank you


  • Options
    Bryan_HBryan_H Vertica Employee Administrator

    Hi, sorry for the delay - does the flex table define partitions? If so, a possible solution is to swap a partition to a temporary table with identical DDL (CREATE TABLE LIKE) and perform the compute keys / build view there, then extract data from the temp table. However, it seems like this would leave you with views for each temp table that you'll need to consolidate into a persistent table to cover all partitions. You might open a support case for this to see if engineering can find a better way to update flex tables by partition or range.

Leave a Comment

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