Set refresh rate for flattened table?

Min_Yun_ChanMin_Yun_Chan Vertica Employee Employee
in General Discussion

Can we automatically refresh every 5 sec a flattened table built with SET USING?


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

Tagged:

Answers

  • MaurizioMaurizio Vertica Employee Employee

    You will have to run REFRESH_COLUMNS() on "SET USING" columns. This function has no "automatic refresh timeouts" but you can run it every X seconds - if really needed - using an external scheduler. It's probably a good idea to "link" REFRESH_COLUMNS() execution to ETL related events more than "fixed length timeouts".

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...