Every hour how much data loaded into each tables



I want to generate a report every hour how many rows inserter into a table. i am trying to aggregare it using LOAD_STREAMS tables. But that table gets cleared every hour. 


either I want to extend the retention period of Load_Streams table or any other way to get Loaded row count details in table wise.





  • Options


    Quote from the doc on LOAD_STREAMS tables:


    "HP Vertica maintains system table metrics until they reach a designated size quota (in kilobytes). The quota is set through internal processes and cannot be set or viewed directly."


    I think this is not easy to change. You may want to work with HP Vertica support on this one.

Leave a Comment

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