Hi Sundaresan,
There are matching entries and if you ask for SUM and you set T (no
aggregation) it returns the aggregation for 1 element (same as asking
for normal attributes but with extra information (count)).
I have done a test with a proper contrail table.
I issue the following query:
{
"end_time": "now",
"select_fields": [
"T", "cpu_info.mem_virt", "cpu_info.cpu_share"
],
"sort_fields": [],
"start_time": "now-2m",
"table": "StatTable.AnalyticsCpuState.cpu_info",
"where": [
[
{
"name": "Source",
"op": 1,
"suffix": null,
"value": "mgmt01",
"value2": null
}
]
]
}
Which returns the following:
{
"value": [
{
"T": 1432131330502589,
"cpu_info.cpu_share": 0,
"cpu_info.mem_virt": 247720
},
{
"T": 1432131346917530,
"cpu_info.cpu_share": 0.258333,
"cpu_info.mem_virt": 697880
},
{
"T": 1432131361675782,
"cpu_info.cpu_share": 0.00208333,
"cpu_info.mem_virt": 716132
},
{
"T": 1432131390605063,
"cpu_info.cpu_share": 0,
"cpu_info.mem_virt": 247720
},
{
"T": 1432131406922257,
"cpu_info.cpu_share": 0.289535,
"cpu_info.mem_virt": 697880
},
{
"T": 1432131421676206,
"cpu_info.cpu_share": 0.0270833,
"cpu_info.mem_virt": 716132
}
]
}
With the timestamps of the first and the last message I create the
following query (same as previous but changing end and start time):
{
"end_time": "1432131421676206",
"select_fields": [
"T", "cpu_info.mem_virt", "cpu_info.cpu_share"
],
"sort_fields": [],
"start_time": "1432131330502589",
"table": "StatTable.AnalyticsCpuState.cpu_info",
"where": [
[
{
"name": "Source",
"op": 1,
"suffix": null,
"value": "mgmt01",
"value2": null
}
]
]
}
And I get this:
{
"value": []
}
Also a related question, How are the timestamp of aggregations
calculated? Is it the min, max or average?
[Sundar] ?T? in ?select_fields? indicates individual time sample =>
No aggregation
I was refering to how is the timestamp for each aggregation
calculated. For example: {
"value": [
{
"COUNT(cpu_info)": 2,
"SUM(cpu_info.cpu_share)": 0.560325,
"SUM(cpu_info.mem_virt)": 3075744,
"T=": 1432132000000000
},
{
"COUNT(cpu_info)": 4,
"SUM(cpu_info.cpu_share)": 0,
"SUM(cpu_info.mem_virt)": 247720,
"T=": 1432132100000000
}
]
}
How is the value of T= calculated?
Thanks for your support.
Best regards,
Alberto.
Quoting Sundaresan Rajangam <[email protected]>:
Hi Alberto,
Please see in line.
Date: Tue, 19 May 2015 17:44:10 +0200
From: [email protected]
To: [email protected]
Subject: [Users] Querying API with timestamps
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1; DelSp="Yes";
format="flowed"
Hi,
I'm having troubles when using timestamps while querying the API using POST.
I got the timestamp of a previous message as reference (the eldest of
a previous query) for start_time and tried to do the following query
(The table we are querying is a working table from a custom sandesh
message):
{
"start_time": "1432045370076142",
"sort_fields": [],
"end_time": "now",
"table": "StatTable.CDNAgent.QoSInfo",
"select_fields": ["Source", "name", "T", "QoSInfo.cache_id",
"SUM(QoSInfo.service_quality)", "SUM(QoSInfo.hit_ratio)",
"COUNT(QoSInfo)"],
"where": [[{"value2": null, "suffix": null, "name": "name", "value":
"CDNDataAgent", "op": 1}]]
}
Then the result we got was empty. Why is this happening?
[Sundar] No matching entry/stat for name=?CDNDataAgent? [where
clause] in the CDNAgent.QosInfo stat table for the specified
start_time and end_time.
Please verify if the value specified for name in the where clause is
correct and/or the start_time/end_time is correct.
Also a related question, How are the timestamp of aggregations
calculated? Is it the min, max or average?
[Sundar] ?T? in ?select_fields? indicates individual time sample =>
No aggregation
We are currently using OpenContrail 2.10.
Thanks,
Sundar
Best Regards,
Alberto.
------------------------------
Subject: Digest Footer
_______________________________________________
Users mailing list
[email protected]
http://lists.opencontrail.org/mailman/listinfo/users_lists.opencontrail.org
------------------------------
End of Users Digest, Vol 21, Issue 9
************************************
_______________________________________________
Users mailing list
[email protected]
http://lists.opencontrail.org/mailman/listinfo/users_lists.opencontrail.org
_______________________________________________
Users mailing list
[email protected]
http://lists.opencontrail.org/mailman/listinfo/users_lists.opencontrail.org
