Dear all,

I want to have aggregations over the statistics but I don't know how to do aggregations. I have a test query as follows:
{
    "end_time": "now",
    "select_fields": [
"T", "cpu_info.cpu_share", "SUM(cpu_info.cpu_share)", "cpu_info.one_min_cpuload", "UUID", "COUNT(cpu_info)"
    ],
    "sort_fields": [],
    "start_time": "now-60m",
    "table": "StatTable.ComputeCpuState.cpu_info",
    "where": [
        [
            {
                "name": "Source",
                "op": 1,
                "suffix": null,
                "value": "contrail",
                "value2": null
            }
        ]
    ]
}

I send this query and I get around 12 instances with the information I requested. However, the count is 1 in each instance and the SUM is equal to de cpu_share (as it represents only 1 value). How can I have, for example, an aggregation over 3 (i.e. a count equal to 3)? Is it configured somewhere in contrail configuration?

Also, if you could provide me which kinds of aggregations are available I would be grateful. Are they the same as the aggregations available at Cassandra?

Thank you for reading.

Best regards,
Alberto.

_______________________________________________
Users mailing list
[email protected]
http://lists.opencontrail.org/mailman/listinfo/users_lists.opencontrail.org

Reply via email to