Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "metadata":{
- "status":"Success",
- "raw_request":"{\"attr\":[{\"name\":\"mm_sa192\",\"size\":50,\"displayName\":\"MM_SA192\",\"nullInclude\":false,\"sortMetric\":{\"displayName\":\"volume\",\"direction\":\"desc\"}},{\"name\":\"_classification_9460226_1\",\"size\":6,\"nullInclude\":false,\"sortMetric\":{\"displayName\":\"volume\",\"direction\":\"desc\"},\"nodes\":[\"9460227/9460339\",\"9460227/9460501\",\"9460227/9460435\",\"9460227/9460233\",\"9460227/-9460227\",\"9460227/9460393\"]}],\"filter\":{\"main\":{\"query\":{\"bool\":{\"must\":{\"query_string\":{\"query\":\"+( receivevia:phone ) \",\"default_field\":\"_words\"}}}}}},\"attributeNames\":[\"mm_sa192\",\"_classification_9460226_1\"],\"metrics\":[{\"name\":\"volume\",\"type\":\"sys\",\"nullInclude\":false}],\"metricNames\":[],\"systemMetricNames\":[\"volume\"],\"attributeDisplayNames\":[\"MM_SA192\",\"_classification_9460226_1\"],\"source\":{\"index\":{\"readAlias\":\"read_30$1314849\",\"writeAlias\":\"write_30$1314849\",\"dataIndexName\":\"30$1314849_2\",\"percolatorIndexName\":\"30$p$1314849_0\"},\"cluster\":{\"name\":\"es_cluster_dallas05\",\"description\":\"Data cluster\",\"hosts\":[{\"http\":{\"hostAddress\":\"10.81.196.146\",\"hostName\":\"10.81.196.146\",\"port\":9200}}]}},\"projectId\":1314849,\"startDate\":\"20161202063701\",\"weekDescription\":false,\"reportType\":\"Table\",\"systemSchema\":{\"description\":\"System schema\",\"password\":\"*************\",\"user\":\"cbss_nissan\",\"url\":\"jdbc:oracle:thin:@//navy_db:1521/orcl\",\"serverName\":\"navy_db\",\"portNumber\":1521,\"databaseName\":\"orcl\"},\"useHistoricPeriod\":false,\"clientRequestId\":\"55e929ce-14b0-4414-a90f-9043380b7c9b\",\"endDate\":\"20170302063701\"}",
- "sentence_query":{
- },
- "document_query":{
- },
- "stats":{
- "document_cardinality":50,
- "doc_count":754218,
- "attribute_count":2,
- "analyze_request_ms":0,
- "metrics_non_system_count":0,
- "document_search_time_ms":224,
- "metrics_custom_count":0,
- "sentence_search_time_ms":57,
- "queue_wait_time_ms":0,
- "resultset_postprocess_ms":0,
- "dispatch_child_queries_ms":231,
- "sentence_total_time_ms":64,
- "analyze_response_ms":0,
- "sentence_cardinality":100,
- "sort_time_ms":1,
- "document_total_time_ms":230,
- "metrics_total_count":1,
- "total_execute_ms":233,
- "join_time_ms":1,
- "request_length":1462
- },
- "cardinality":{
- "cardinality_High":0,
- "cardinality_Too_High":0,
- "cardinality_Low":1,
- "cardinality_Med":1,
- "total_cardinality_points":4,
- "cardinality_cap":10
- },
- "cache":"NoCache",
- "description":"Success",
- "request_total":{
- "time_elapsed_ms":695
- },
- "source":"{cluster: {hosts: [{http: {hostName: 10.81.196.146, address: 10.81.196.146, port: 9200}, transport: null}], name: es_cluster_dallas05, description: Data cluster}, index: {readAlias:read_30$1314849, writeAlias:write_30$1314849, dataIndexName:30$1314849_2}}",
- "project_id":1314849,
- "host":"navy_db",
- "es_host":"10.81.196.146:9200",
- "index_name":"30$1314849_2",
- "report_type":"Table",
- "version":"0.2.90",
- "protocol":"HTTP/1.1",
- "client_qid":"55e929ce-14b0-4414-a90f-9043380b7c9b",
- "parent_qid":"624f69da-6896-4f92-9c6e-b179e9d22ee5",
- "instance_id":"7e14a47f-106c-4542-937a-c83f5dfb9260",
- "qid":"65d53dc9-6afd-4028-8a38-84cd321c3f7e",
- "agent":"Java/1.8.0_11",
- "client_address":"10.16.44.38",
- "endpoint":"/v1/reports/struct_agg"
- },
- "data":{
- "doc_count":754218.0,
- "MM_SA192":{
- "buckets":[
- {
- "key":"andrew townes",
- "doc_count":364.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"cathy isbell",
- "doc_count":287.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"marco vega",
- "doc_count":243.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"perfinna king",
- "doc_count":234.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"adrianna ortiz",
- "doc_count":218.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"makenna hunter",
- "doc_count":216.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"kathleen vincent",
- "doc_count":210.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"monica cosby",
- "doc_count":201.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"chantoya ridgeway",
- "doc_count":195.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"regina thomas",
- "doc_count":191.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"stephen vallo",
- "doc_count":190.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"adam archuleta",
- "doc_count":189.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"tenia jenkins",
- "doc_count":186.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"ronald taylor",
- "doc_count":178.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"katima bryant",
- "doc_count":176.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"robert williams",
- "doc_count":169.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"cheryl osborne",
- "doc_count":166.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"byron hinkle",
- "doc_count":161.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"robert kline",
- "doc_count":160.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"shameka story",
- "doc_count":155.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"danielle lunceford",
- "doc_count":153.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"ebony riley",
- "doc_count":152.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"nancy baggerly",
- "doc_count":142.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"paul graff",
- "doc_count":141.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"crystal martinez",
- "doc_count":137.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"candice baca",
- "doc_count":136.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"danielle dudley",
- "doc_count":135.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"ann mcdonald",
- "doc_count":134.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"bazika chudnoff",
- "doc_count":133.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"cassandra pacheco",
- "doc_count":129.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"kayla naktewa",
- "doc_count":129.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"brittany moon",
- "doc_count":127.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"natasha davis",
- "doc_count":126.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"jolene dybas",
- "doc_count":123.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"aaron acosta",
- "doc_count":121.0
- },
- {
- "key":"julio aguayo",
- "doc_count":121.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"kamilah maddox",
- "doc_count":120.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"dhanzasikam toledo",
- "doc_count":119.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"mary black",
- "doc_count":119.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"amber teller",
- "doc_count":118.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"alan luna jacquez",
- "doc_count":115.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"veda aragon",
- "doc_count":115.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"jennifer vicent",
- "doc_count":113.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"lois maturana",
- "doc_count":113.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"jacques robinson",
- "doc_count":111.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"cynthia gregory",
- "doc_count":110.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"daja loving",
- "doc_count":110.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"sophia grimes",
- "doc_count":110.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"dena shondee",
- "doc_count":109.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- },
- {
- "key":"marcelle thomas",
- "doc_count":109.0,
- "_classification_9460226_1":{
- "buckets":[
- ]
- }
- }
- ]
- }
- },
- "client_qid":"55e929ce-14b0-4414-a90f-9043380b7c9b",
- "version":"0.2.90"
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement