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

Every hour how much data loaded into each tables

Hi

 

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.

 

Thanks,

Raj

Comments

  •  

    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
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.