Hi Alberto,

Please look at
http://www.opencontrail.org/statistics-in-opencontrail-analytics/
esp. the query examples section.. where it explains the 3 types of queries
1. Query for samples
2. Query for total aggregates
3. Query for binning

You have to know what you want, assuming you want the samples below, the select 
fields should be
"select_fields": ["Source", "name", "T", "QoSInfo.cache_id", 
"QoSInfo.service_quality", "QoSInfo.hit_ratio"],

If you want to do other types of queries see the pointer above..

regards,
-
Raj

On May 19, 2015, at 8:44 AM, [email protected] wrote:

> 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?
> Also a related question, How are the timestamp of aggregations calculated? Is 
> it the min, max or average?
> 
> We are currently using OpenContrail 2.10.
> 
> 
> Best Regards,
> Alberto.
> 
> 
> 
> 
> 
> _______________________________________________
> Users mailing list
> [email protected]
> http://lists.opencontrail.org/mailman/listinfo/users_lists.opencontrail.org

Attachment: signature.asc
Description: Message signed with OpenPGP using GPGMail

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

Reply via email to