Harshini Elath
02/14/2020, 10:52 PMXiang Fu
{"pql":"select audit_date from iw_audit where str_num=37126 "}
and {"pql":"select count(audit_date) from iw_audit where str_num=37126 "}
Harshini Elath
02/14/2020, 11:02 PMHarshini Elath
02/14/2020, 11:02 PMHarshini Elath
02/14/2020, 11:02 PM{
"pql": "select count(audit_date) from iw_audit where str_num=37126 group by audit_date"
}
Harshini Elath
02/14/2020, 11:03 PM{
"aggregationResults": [
{
"groupByResult": [
{
"value": "2321",
"group": [
"2019-01-05"
]
},
{
"value": "2232",
"group": [
"2019-03-16"
]
},
{
"value": "2222",
"group": [
"2019-06-15"
]
},
{
"value": "2129",
"group": [
"2019-09-07"
]
},
{
"value": "2046",
"group": [
"2019-12-21"
]
}
],
"function": "count_star",
"groupByColumns": [
"audit_date"
]
}
],
"exceptions": [],
"numServersQueried": 2,
"numServersResponded": 2,
"numSegmentsQueried": 394,
"numSegmentsProcessed": 394,
"numSegmentsMatched": 5,
"numConsumingSegmentsQueried": 0,
"numDocsScanned": 10950,
"numEntriesScannedInFilter": 343046,
"numEntriesScannedPostFilter": 10950,
"numGroupsLimitReached": false,
"totalDocs": 75492369,
"timeUsedMs": 36,
"segmentStatistics": [],
"traceInfo": {},
"minConsumingFreshnessTimeMs": 0
}
Harshini Elath
02/14/2020, 11:05 PMHarshini Elath
02/14/2020, 11:06 PMXiang Fu
Xiang Fu
Harshini Elath
02/15/2020, 3:15 AMHarshini Elath
02/17/2020, 5:07 PMHarshini Elath
02/17/2020, 5:08 PM