Every hour how much data loaded into each tables

Rajzz

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

K_Krutiy

 

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.