Every hour how much data loaded into each tables

RajzzRajzz
in General Discussion

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

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

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