+1Hi
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
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.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
