DX NetOps

 View Only
  • 1.  Vertica tables doubt

    Posted Jul 29, 2020 05:21 AM
    Hello,

    For the If Stats data in NetOPs Vertica I see the following tables:

    ifstats_eqd
    ifstats_gtd
    ifstats_rate

    Does anyone know what are the differences between these tables?

    Thank you.

    Best regards
    Bruno Sousa


  • 2.  RE: Vertica tables doubt
    Best Answer

    Broadcom Employee
    Posted Jul 29, 2020 05:35 AM
    The daily rollups are stored in a table named from the dataset name concatenated with the string "_eqd", such as "ifstats_eqd".
    The hourly rollups are stored in a table named from the dataset name concatenated with the string "_ltd", such as "ifstats_ltd".
    Long term roll-up data consists of weekly, monthly, and quarterly rollups and is calculated from the daily rollup records. The long term data is stored in a table named from the dataset name concatenated with the string "_gtd", such as



  • 3.  RE: Vertica tables doubt

    Posted Jul 29, 2020 05:50 AM
    Thank you for the feedback, Aravind!

    And the _rate table? what does it mean?

    Where can I find the raw data (as polled data) information table for IFStats in Vertica?

    Thank you.

    Best regards
    Bruno Sousa



  • 4.  RE: Vertica tables doubt

    Broadcom Employee
    Posted Jul 29, 2020 07:43 AM
    ifstats_rate (raw poll data)
    ifstats_ltd (hourly rollup)
    ifstats_eqd (daily rollup)
    ifstats_gtd (weekly rollup)


  • 5.  RE: Vertica tables doubt

    Posted Jul 29, 2020 07:46 AM
    Thank you both for the explanation!

    BR
    Bruno Sousa