The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Is it possible to store the realtime stats/logs generated by Managment console in to a table

Hi,
Can it be possible to store the log/stats generated by management console and store those to a table.If yes how can e pull those stats/logs from console?

Answers

  • LenoyJLenoyJ Employee
    edited September 4

    Any more info on what logs/stats you are trying to store to a table?
    MC pulls all the data it needs to generate those charts from Vertica system tables in the first place. See: https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/SystemTables/VerticaSystemTables.htm
    You may find what you're looking for there.
     
    You can also get a list of queries that MC uses by looking at the xml files here:
    /opt/vconsole/reports

  • Thanks Lenoy

  • Hi, there is a feature extended monitoring in management console to stream data from source vertica and using kafka , we can load into target table.
    However i have one issues.
    1.i have 2 cluster (SRC1,SRC2) and using Kafka i stream and load into Target cluster, but the problem is both Source cluster data is getting loaded into same table of target cluster(dcschema).in that case how can i identify which data belong to which cluster.can we define 2 different schema for 2 src cluster.
    Let me know if it is possible
    thanks

  • SruthiASruthiA Employee

    It is possible. Please create 2 microbatches each for one source cluster. you can create two different schemas for two difference source clusters.

  • Hi Sruthi,
    Thanks for the reply but can you please explain bit more, where exactly the schema needs to be defined as it takes automatically dcschema.

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.