Alberto, > And for your second question, > When ³T=<x>² is specified in the ³select_fields², then the value of ³T=" > => start_time + (N*x), where N >= 0 and T <= end_time
The first value of “T=" is rounded off to the value divisible by x, so the subsequent values of “T=“ would be previous value of “T=“ + <x> Thanks, Sundar > On May 20, 2015, at 9:14 PM, Sundaresan Rajangam <[email protected]> wrote: > > Hi Albert, > > If you specify the start_time and end_time in UTC time format, then please > specify it as integer and not as string. > "start_time": ³1432131330502589² => "start_time": 1432131330502589 > > "end_time": ³1432131421676206² => ³end_time²: 1432131421676206 > > And for your second question, > When ³T=<x>² is specified in the ³select_fields², then the value of ³T=" > => start_time + (N*x), where N >= 0 and T <= end_time > > Thanks, > Sundar > > On 5/20/15, 8:15 PM, "[email protected]" <[email protected]> wrote: > >> 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.o >>> rg >>> >> >> > _______________________________________________ Users mailing list [email protected] http://lists.opencontrail.org/mailman/listinfo/users_lists.opencontrail.org
