Answers

• LenoyJ - Select Field - Employee

  September 2019 edited September 2019

  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

  1
• opper20 ✭

  September 2019

  Thanks Lenoy

  0
• opper20 ✭

  November 2019

  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

  0
• SruthiA Administrator

  November 2019

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

  0
• opper20 ✭

  November 2019

  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.

  0