DSL 语法介绍
| 语法 | 范围 |
| /_search | 集群上搜索所有的索引 |
| /index1/_search | index1 |
| /index1,index2/_search | index1和index2 |
| /index*/_search | 以index开头的索引 |
RUL 查询；使用q,指定查询字符串，查询内容是kv键值对
curl -XGET "http://127.0.0.1:9200/kibana_sample_data_ecommerce/_search?q=customer_first_name:Eddie"
{"took":3,"timed_out":false,"_shards":{"total":1,"successful":1,"skipped":0,"failed":0},"hits":{"total":{"value":100,"relation":"eq"},"max_score":4.016948,"hits":[{"_index":"kibana_sample_dat
a_ecommerce","_type":"_doc","_id":"UXYbP24B9uEN4vPiBjWP","_score":4.016948,"_source":{"category":["Men's Clothing"],"currency":"EUR","customer_first_name":"Eddie","customer_full_name":"Eddie Underwood","customer_gender":"MALE","customer_id":38,"customer_last_name":"Underwood","customer_phone":"","day_of_week":"Monday","day_of_week_i":0,"email":"[email protected]","manufacturer":["Elitelligence","Oceanavigations"],"order_date":"2019-11-25T09:28:48+00:00","order_id":584677,"products":[{"base_price":11.99,"discount_percentage":0,"quantity":1,"manufacturer":"Elitelligence","tax_amount":0,"product_id":6283,"category":"Men's Clothing","sku":"ZO0549605496","taxless_price":11.99,"unit_discount_amount":0,"min_price":6.35,"_id":"sold_product_584677_6283","discount_amount":0,"created_on":"2016-12-26T09:28:48+00:00","product_name":"Basic T-shirt - dark blue/white","price":11.99,"taxful_price":11.99,"base_unit_price":11.99},{"base_price":24.99,"discount_percentage":0,"quantity":1,"manufacturer":"Oceanavigations","tax_amount":0,"product_id":19400,"category":"Men's Clothing","sku":"ZO0299602996","taxless_price":24.99,"unit_discount_amount":0,"min_price":11.75,"_id":"sold_product_584677_19400","discount_amount":0,"created_on":"2016-12-26T09:28:48+00:00","product_name":"Sweatshirt - grey multicolor","price":24.99,"taxful_price":24.99,"base_unit_price":24.99}],"sku":["ZO0549605496","ZO0299602996"],"taxful_total_price":36.98,"taxless_total_price":36.98,"total_quantity":2,"total_unique_products":2,"type":"order","user":"eddie","geoip":{"country_iso_code":"EG","location":{"lon":31.3,"lat":30.1},"region_name":"Cairo Governorate","continent_name":"Africa","city_name":"Cairo"}}},{"_index":"kibana_sample_data_ecommerce","_type":"_doc","_id":"VXYbP24B9uEN4vPiBjWP","_score":4.016948,"_source":{"category":["Men's Clothing","Men's Accessories"],"currency":"EUR","customer_first_name":"Eddie","customer_full_name":"Eddie Weber","customer_gender":"MALE","customer_id":38,"customer_last_name":"Weber","customer_phone":"","day_of_week":"Monday","day_of_week_i":0,"email":"[email protected]","manufacturer":["Elitelligence"],"order_date":"2019-11-18T03:48:58+00:00","order_id":574916,"products":[{"base_price":59.99,"discount_percentage":0,"quantity":1,"manufacturer":"Elitelligence","tax_amount":0,"product_id":11262,"category":"Men's Clothing","sku":"ZO0542505425","taxless_price":59.99,"unit_discount_amount":0,"min_price":28.2,"_id":"sold_product_574916_11262","discount_amount":0,"created_on":"2016-12-19T03:48:58+00:00","product_name":"Winter jacket - black","price":59.99,"taxful_price":59.99,"base_unit_price":59.99},{"base_price":20.99,"discount_percentage":0,"quantity":1,"manufacturer":"Elitelligence","tax_amount":0,"product_id":15713,"category":"Men's Accessories","sku":"ZO0601306013","taxless_price":20.99,"unit_discount_amount":0,"min_price":10.7,"_id":"sold_product_574916_15713","discount_amount":0,"created_on":"2016-12-19T03:48:58+00:00","product_name":"Watch - green","price":20.99,"taxful_price":20.99,"base_unit_price":20.99}],"sku":["ZO0542505425","ZO0601306013"],"taxful_total_price":80.98,"taxless_total_price":80.98,"total_quantity":2,"total_unique_products":2,"type":"order","user":"eddie","geoip":{"country_iso_code":"EG","location":{"lon":31.3,"lat":30.1},"region_name":"Cairo Governorate","continent_name":"Africa","city_name":"Cairo"}}},{"_index":"kibana_sample_data_ecommerce","_type":"_doc","_id":"XHYbP24B9uEN4vPiBjWQ","_score":4.016948,"_source":{"category":["Men's Accessories","Men's Clothing"],"currency":"EUR","customer_first_name":"Eddie","customer_full_name":"Eddie Gregory","customer_gender":"MALE","customer_id":38,"customer_last_name":"Gregory","customer_phone":"","day_of_week":"Tuesday","day_of_week_i":1,"email":"[email protected]","manufacturer":["Angeldale","Low Tide Media","Oceanavigations","Elitelligence"],"order_date":"2019-11-26T13:10:34+00:00","order_id":718424,"products":[{"base_price":17.99,"discount_percentage":0,"quantity":1,"manufacturer":"Angeldale","tax_amount":0,"product_id":19655,"category":"Men's Accessories","sku":"ZO0700707007","taxless_price":17.99,"unit_discount_amount":0,"min_price":8.28,"_id":"sold_product_718424_19655","discount_amount":0,"created_on":"2016-12-27T13:10:34+00:00","product_name":"Belt - black","price":17.99,"taxful_price":17.99,"base_unit_price":17.99},{"base_price":10.99,"discount_percentage":0,"quantity":1,"manufacturer":"Low Tide Media","tax_amount":0,"product_id":12500,"category":"Men's Accessories","sku":"ZO0459704597","taxless_price":10.99,"unit_discount_amount":0,"min_price":5.06,"_id":"sold_product_718424_12500","discount_amount":0,"created_on":"2016-12-27T13:10:34+00:00","product_name":"Gloves - dark grey multicolor/bordeaux","price":10.99,"taxful_price":10.99,"base_unit_price":10.99},{"base_price":16.99,"discount_percentage":0,"quantity":1,"manufacturer":"Oceanavigations","tax_amount":0,"product_id":17739,"category":"Men's Clothing","sku":"ZO0293702937","taxless_price":16.99,"unit_discount_amount":0,"min_price":8.83,"_id":"sold_product_718424_17739","discount_amount":0,"created_on":"2016-12-27T13:10:34+00:00","product_name":"Long sleeved top - khaki","price":16.99,"taxful_price":16.99,"base_unit_price":16.99},{"base_price":22.99,"discount_percentage":0,"quantity":1,"manufacturer":"Elitelligence","tax_amount":0,"product_id":23793,"category":"Men's Clothing","sku":"ZO0592705927","taxless_price":22.99,"unit_discount_amount":0,"min_price":11.04,"_id":"sold_product_718424_23793","discount_amount":0,"created_on":"2016-12-27T13:10:34+00:00","product_name":"Hoodie - mottled light grey","price":22.99,"taxful_price":22.99,"base_unit_price":22.99}],"sku":["ZO0700707007","ZO0459704597","ZO0293702937","ZO0592705927"],"taxful_total_price":68.96,"taxless_total_price":68.96,"total_quantity":4,"total_unique_products":4,"type":"order","user":"eddie","geoip":{"country_iso_code":"EG","location":{"lon":31.3,"lat":30.1},"region_name":"Cairo Governorate","continent_name":"Africa","city_name":"Cairo"}}},{"_index":"kibana_sample_data_ecommerce","_type":"_doc","_id":"XnYbP24B9uEN4vPiBjWQ","_score":4.016948,"_source":{"category":["Men's Clothing"],"currency":"EUR","customer_first_name":"Eddie","customer_full_name":"Eddie Wolfe","customer_gender":"MALE","customer_id":38,"customer_last_name":"Wolfe","customer_phone":"","day_of_week":"Monday","day_of_week_i":0,"email":"[email protected]","manufacturer":["Elitelligence","Oceanavigations","Low Tide Media"],"order_date":"2019-11-18T19:59:31+00:00","order_id":715061,"products":[{"base_price":28.99,"discount_percentage":0,"quantity":1,"manufacturer":"Elitelligence","tax_amount":0,"product_id":13695,"category":"Men's Clothing","sku":"ZO0590205902","taxless_price":28.99,"unit_discount_amount":0,"min_price":14.21,"_id":"sold_product_715061_13695","discount_amount":0,"created_on":"2016-12-19T19:59:31+00:00","product_name":"Sweatshirt - white","price":28.99,"taxful_price":28.99,"base_unit_price":28.99},{"base_price":199.99,"discount_percentage":0,"quantity":1,"manufacturer":"Oceanavigations","tax_amount":0,"product_id":16955,"category":"Men's Clothing","sku":"ZO0291402914","taxless_price":199.99,"unit_discount_amount":0,"min_price":92,"_id":"sold_product_715061_16955","discount_amount":0,"created_on":"2016-12-19T19:59:31+00:00","product_name":"Classic coat - navy","price":199.99,"taxful_price":199.99,"base_unit_price":199.99},{"base_price":24.99,"discount_percentage":0,"quantity":1,"manufacturer":"Oceanavigations","tax_amount":0,"product_id":16663,"category":"Men's Clothing","sku":"ZO0297002970","taxless_price":24.99,"unit_discount_amount":0,"min_price":12.25,"_id":"sold_product_715061_16663","discount_amount":0,"created_on":"2016-12-19T19:59:31+00:00","product_name":"Jumper - dark grey multicolor","price":24.99,"taxful_price":24.99,"base_unit_price":24.99},{"base_price":12.99,"discount_percentage":0,"quantity":1,"manufacturer":"Low Tide Media","tax_amount":0,"product_id":14513,"category":"Men's Clothing","sku":"ZO0476504765","taxless_price":12.99,"unit_discount_amount":0,"min_price":7.14,"_id":"sold_product_715061_14513","discount_amount":0,"created_on":"2016-12-19T19:59:31+00:00","product_name":"3 PACK - Shorts - Blue Violety/navy/grey","price":12.99,"taxful_price":12.99,"base_unit_price":12.99}],"sku":["ZO0590205902","ZO0291402914","ZO0297002970","ZO0476504765"],"taxful_total_price":266.96,"taxless_total_price":266.96,"total_quantity":4,"total_unique_products":4,"type":"order","user":"eddie","geoip":{"country_iso_code":"EG","location":{"lon":31.3,"lat":30.1},"region_name":"Cairo Governorate","continent_name":"Africa","city_name":"Cairo"}}},{"_index":"kibana_sample_data_ecommerce","_type":"_doc","_id":"H3YbP24B9uEN4vPiBjaU","_score":4.016948,"_source":{"category":["Men's Clothing"],"currency":"EUR","customer_first_name":"Eddie","customer_full_name":"Eddie Simpson","customer_gender":"MALE","customer_id":38,"customer_last_name":"Simpson","customer_phone":"","day_of_week":"Sunday","day_of_week_i":6,"email":"[email protected]","manufacturer":["Low Tide Media"],"order_date":"2019-11-17T06:25:55+00:00","order_id":573745,"products":[{"base_price":28.99,"discount_percentage":0,"quantity":1,"manufacturer":"Low Tide Media","tax_amount":0,"product_id":23923,"category":"Men's Clothing","sku":"ZO0421804218","taxless_price":28.99,"unit_discount_amount":0,"min_price":14.21,"_id":"sold_product_573745_23923","discount_amount":0,"created_on":"2016-12-18T06:25:55+00:00","product_name":"Chinos - dark blue","price":28.99,"taxful_price":28.99,"base_unit_price":28.99},{"base_price":10.99,"discount_percentage":0,"quantity":1,"manufacturer":"Low Tide Media","tax_amount":0,"product_id":17547,"category":"Men's Clothing","sku":"ZO0435704357","taxless_price":10.99,"unit_discount_amount":0,"min_price":5.71,"_id":"sold_product_573745_17547","discount_amount":0,"created_on":"2016-12-18T06:25:55+00:00","product_name":"Basic T-shirt - light grey multicolor","price":10.99,"taxful_price":10.99,"base_unit_price":10.99}],"sku":["ZO0421804218","ZO0435704357"],"taxful_total_price":39.98,"taxless_total_price":39.98,"total_quantity":2,"total_unique_products":2,"type":"order","user":"eddie","geoip":{"country_iso_code":"EG","location":{"lon":31.3,"lat":30.1},"region_name":"Cairo Governorate","continent_name":"Africa","city_name":"Cairo"}}},{"_index":"kibana_sample_data_ecommerce","_type":"_doc","_id":"JHYbP24B9uEN4vPiBjaU","_score":4.016948,"_source":{"category":["Men's Clothing","Men's Shoes"],"currency":"EUR","customer_first_name":"Eddie","customer_full_name":"Eddie Riley","customer_gender":"MALE","customer_id":38,"customer_last_name":"Riley","customer_phone":"","day_of_week":"Thursday","day_of_week_i":3,"email":"[email protected]","manufacturer":["Spritechnologies","Elitelligence","Low Tide Media"],"order_date":"2019-11-28T05:54:14+00:00","order_id":717415,"products":[{"base_price":74.99,"discount_percentage":0,"quantity":1,"manufacturer":"Spritechnologies","tax_amount":0,"product_id":19307,"category":"Men's Clothing","sku":"ZO0623206232","taxless_price":74.99,"unit_discount_amount":0,"min_price":36.75,"_id":"sold_product_717415_19307","discount_amount":0,"created_on":"2016-12-29T05:54:14+00:00","product_name":"Parka - navy blazer","price":74.99,"taxful_price":74.99,"base_unit_price":74.99},{"base_price":20.99,"discount_percentage":0,"quantity":1,"manufacturer":"Elitelligence","tax_amount":0,"product_id":14146,"category":"Men's Clothing","sku":"ZO0612506125","taxless_price":20.99,"unit_discount_amount":0,"min_price":11.54,"_id":"sold_product_717415_14146","discount_amount":0,"created_on":"2016-12-29T05:54:14+00:00","product_name":"Swimming shorts - banana","price":20.99,"taxful_price":20.99,"base_unit_price":20.99},{"base_price":32.99,"discount_percentage":0,"quantity":1,"manufacturer":"Elitelligence","tax_amount":0,"product_id":14250,"category":"Men's Shoes","sku":"ZO0517405174","taxless_price":32.99,"unit_discount_amount":0,"min_price":15.51,"_id":"sold_product_717415_14250","discount_amount":0,"created_on":"2016-12-29T05:54:14+00:00","product_name":"High-top trainers - grey","price":32.99,"taxful_price":32.99,"base_unit_price":32.99},{"base_price":20.99,"discount_percentage":0,"quantity":1,"manufacturer":"Low Tide Media","tax_amount":0,"product_id":19880,"category":"Men's Clothing","sku":"ZO0445204452","taxless_price":20.99,"unit_discount_amount":0,"min_price":11.54,"_id":"sold_product_717415_19880","discount_amount":0,"created_on":"2016-12-29T05:54:14+00:00","product_name":"Polo shirt - Medium Slate Blue","price":20.99,"taxful_price":20.99,"base_unit_price":20.99}],"sku":["ZO0623206232","ZO0612506125","ZO0517405174","ZO0445204452"],"taxful_total_price":149.96,"taxless_total_price":149.96,"total_quantity":4,"total_unique_products":4,"type":"order","user":"eddie","geoip":{"country_iso_code":"EG","location":{"lon":31.3,"lat":30.1},"region_name":"Cairo Governorate","continent_name":"Africa","city_name":"Cairo"}}},{"_index":"kibana_sample_data_ecommerce","_type":"_doc","_id":"PnYbP24B9uEN4vPiBjaV","_score":4.016948,"_source":{"category":["Men's Clothing"],"currency":"EUR","customer_first_name":"Eddie","customer_full_name":"Eddie Graham","customer_gender":"MALE","customer_id":38,"customer_last_name":"Graham","customer_phone":"","day_of_week":"Thursday","day_of_week_i":3,"email":"[email protected]","manufacturer":["Low Tide Media","Oceanavigations","Elitelligence"],"order_date":"2019-11-21T16:12:00+00:00","order_id":719618,"products":[{"base_price":21.99,"discount_percentage":0,"quantity":1,"manufacturer":"Low Tide Media","tax_amount":0,"product_id":12461,"category":"Men's Clothing","sku":"ZO0449604496","taxless_price":21.99,"unit_discount_amount":0,"min_price":10.34,"_id":"sold_product_719618_12461","discount_amount":0,"created_on":"2016-12-22T16:12:00+00:00","product_name":"Jumper - dark blue","price":21.99,"taxful_price":21.99,"base_unit_price":21.99},{"base_price":41.99,"discount_percentage":0,"quantity":1,"manufacturer":"Oceanavigations","tax_amount":0,"product_id":17481,"category":"Men's Clothing","sku":"ZO0287802878","taxless_price":41.99,"unit_discount_amount":0,"min_price":20.16,"_id":"sold_product_719618_17481","discount_amount":0,"created_on":"2016-12-22T16:12:00+00:00","product_name":"Waistcoat - bright blue","price":41.99,"taxful_price":41.99,"base_unit_price":41.99},{"base_price":24.99,"discount_percentage":0,"quantity":1,"manufacturer":"Elitelligence","tax_amount":0,"product_id":15234,"category":"Men's Clothing","sku":"ZO0526105261","taxless_price":24.99,"unit_discount_amount":0,"min_price":11.5,"_id":"sold_product_719618_15234","discount_amount":0,"created_on":"2016-12-22T16:12:00+00:00","product_name":"Chinos - olive","price":24.99,"taxful_price":24.99,"base_unit_price":24.99},{"base_price":10.99,"discount_percentage":0,"quantity":1,"manufacturer":"Elitelligence","tax_amount":0,"product_id":12663,"category":"Men's Clothing","sku":"ZO0561005610","taxless_price":10.99,"unit_discount_amount":0,"min_price":5.93,"_id":"sold_product_719618_12663","discount_amount":0,"created_on":"2016-12-22T16:12:00+00:00","product_name":"Print T-shirt - dark blue","price":10.99,"taxful_price":10.99,"base_unit_price":10.99}],"sku":["ZO0449604496","ZO0287802878","ZO0526105261","ZO0561005610"],"taxful_total_price":99.96,"taxless_total_price":99.96,"total_quantity":4,"total_unique_products":4,"type":"order","user":"eddie","geoip":{"country_iso_code":"EG","location":{"lon":31.3,"lat":30.1},"region_name":"Cairo Governorate","continent_name":"Africa","city_name":"Cairo"}}},{"_index":"kibana_sample_data_ecommerce","_type":"_doc","_id":"Y3YbP24B9uEN4vPiBjaW","_score":4.016948,"_source":{"category":["Men's Clothing","Women's Accessories"],"currency":"EUR","customer_first_name":"Eddie","customer_full_name":"Eddie Clayton","customer_gender":"MALE","customer_id":38,"customer_last_name":"Clayton","customer_phone":"","day_of_week":"Wednesday","day_of_week_i":2,"email":"[email protected]","manufacturer":["Oceanavigations","Elitelligence"],"order_date":"2019-11-20T12:31:41+00:00","order_id":578044,"products":[{"base_price":22.99,"discount_percentage":0,"quantity":1,"manufacturer":"Oceanavigations","tax_amount":0,"product_id":22200,"category":"Men's Clothing","sku":"ZO0279602796","taxless_price":22.99,"unit_discount_amount":0,"min_price":11.72,"_id":"sold_product_578044_22200","discount_amount":0,"created_on":"2016-12-21T12:31:41+00:00","product_name":"Shirt - off white","price":22.99,"taxful_price":22.99,"base_unit_price":22.99},{"base_price":18.99,"discount_percentage":0,"quantity":1,"manufacturer":"Elitelligence","tax_amount":0,"product_id":20111,"category":"Women's Accessories","sku":"ZO0605006050","taxless_price":18.99,"unit_discount_amount":0,"min_price":9.12,"_id":"sold_product_578044_20111","discount_amount":0,"created_on":"2016-12-21T12:31:41+00:00","product_name":"Rucksack - black/cognac","price":18.99,"taxful_price":18.99,"base_unit_price":18.99}],"sku":["ZO0279602796","ZO0605006050"],"taxful_total_price":41.98,"taxless_total_price":41.98,"total_quantity":2,"total_unique_products":2,"type":"order","user":"eddie","geoip":{"country_iso_code":"EG","location":{"lon":31.3,"lat":30.1},"region_name":"Cairo Governorate","continent_name":"Africa","city_name":"Cairo"}}},{"_index":"kibana_sample_data_ecommerce","_type":"_doc","_id":"jHYbP24B9uEN4vPiBjaW","_score":4.016948,"_source":{"category":["Men's Accessories","Men's Clothing"],"currency":"EUR","customer_first_name":"Eddie","customer_full_name":"Eddie Riley","customer_gender":"MALE","customer_id":38,"customer_last_name":"Riley","customer_phone":"","day_of_week":"Sunday","day_of_week_i":6,"email":"[email protected]","manufacturer":["Elitelligence","Microlutions"],"order_date":"2019-11-17T13:26:24+00:00","order_id":574129,"products":[{"base_price":24.99,"discount_percentage":0,"quantity":1,"manufacturer":"Elitelligence","tax_amount":0,"product_id":19430,"category":"Men's Accessories","sku":"ZO0606706067","taxless_price":24.99,"unit_discount_amount":0,"min_price":11.75,"_id":"sold_product_574129_19430","discount_amount":0,"created_on":"2016-12-18T13:26:24+00:00","product_name":"Across body bag - black","price":24.99,"taxful_price":24.99,"base_unit_price":24.99},{"base_price":14.99,"discount_percentage":0,"quantity":1,"manufacturer":"Microlutions","tax_amount":0,"product_id":18256,"category":"Men's Clothing","sku":"ZO0118301183","taxless_price":14.99,"unit_discount_amount":0,"min_price":8.09,"_id":"sold_product_574129_18256","discount_amount":0,"created_on":"2016-12-18T13:26:24+00:00","product_name":"Print T-shirt - bright white","price":14.99,"taxful_price":14.99,"base_unit_price":14.99}],"sku":["ZO0606706067","ZO0118301183"],"taxful_total_price":39.98,"taxless_total_price":39.98,"total_quantity":2,"total_unique_products":2,"type":"order","user":"eddie","geoip":{"country_iso_code":"EG","location":{"lon":31.3,"lat":30.1},"region_name":"Cairo Governorate","continent_name":"Africa","city_name":"Cairo"}}},{"_index":"kibana_sample_data_ecommerce","_type":"_doc","_id":"xXYbP24B9uEN4vPiBjaX","_score":4.016948,"_source":{"category":["Men's Shoes"],"currency":"EUR","customer_first_name":"Eddie","customer_full_name":"Eddie Garza","customer_gender":"MALE","customer_id":38,"customer_last_name":"Garza","customer_phone":"","day_of_week":"Friday","day_of_week_i":4,"email":"[email protected]","manufacturer":["Angeldale","Low Tide Media"],"order_date":"2019-11-22T05:06:43+00:00","order_id":580284,"products":[{"base_price":84.99,"discount_percentage":0,"quantity":1,"manufacturer":"Angeldale","tax_amount":0,"product_id":2301,"category":"Men's Shoes","sku":"ZO0689906899","taxless_price":84.99,"unit_discount_amount":0,"min_price":42.49,"_id":"sold_product_580284_2301","discount_amount":0,"created_on":"2016-12-23T05:06:43+00:00","product_name":"Lace-up boots - Blue Violet","price":84.99,"taxful_price":84.99,"base_unit_price":84.99},{"base_price":49.99,"discount_percentage":0,"quantity":1,"manufacturer":"Low Tide Media","tax_amount":0,"product_id":13705,"category":"Men's Shoes","sku":"ZO0395903959","taxless_price":49.99,"unit_discount_amount":0,"min_price":25,"_id":"sold_product_580284_13705","discount_amount":0,"created_on":"2016-12-23T05:06:43+00:00","product_name":"Casual lace-ups - brown","price":49.99,"taxful_price":49.99,"base_unit_price":49.99}],"sku":["ZO0689906899","ZO0395903959"],"taxful_total_price":134.98,"taxless_total_price":134.98,"total_quantity":2,"total_unique_products":2,"type":"order","user":"eddie","geoip":{"country_iso_code":"EG","location":{"lon":31.3,"lat":30.1},"region_name":"Cairo Governorate","continent_name":"Africa","city_name":"Cairo"}}}]}}
Request Body查询，方法支持get post -H包头 -d数据
[root@ES ~]# curl -XGET "http://127.0.0.1:9200/kibana_sample_data_ecommerce/_search" -H 'Content-Type:application/json' -d'
{
"query":{ 查询
"match_all":{} 返回所有文档
}
}' {"took":1,"timed_out":false,"_shards":{"total":1,"successful":1,"skipped":0,"failed":0},"hits":{"total":{"value":4675,"relation":"eq"},"max_score":1.0,"hits":[{"_index":"kibana_sample_data_ec
ommerce","_type":"_doc","_id":"UXYbP24B9uEN4vPiBjWP","_score":1.0,"_source":{"category":["Men's Clothing"],"currency":"EUR","customer_first_name":"Eddie","customer_full_name":"Eddie Underwood","customer_gender":"MALE","customer_id":38,"customer_last_name":"Underwood","customer_phone":"","day_of_week":"Monday","day_of_week_i":0,"email":"[email protected]","manufacturer":["Elitelligence","Oceanavigations"],"order_date":"2019-11-25T09:28:48+00:00","order_id":584677,"products":[{"base_price":11.99,"discount_percentage":0,"quantity":1,"manufacturer":"Elitelligence","tax_amount":0,"product_id":6283,"category":"Men's Clothing","sku":"ZO0549605496","taxless_price":11.99,"unit_discount_amount":0,"min_price":6.35,"_id":"sold_product_584677_6283","discount_amount":0,"created_on":"2016-12-26T09:28:48+00:00","product_name":"Basic T-shirt - dark blue/white","price":11.99,"taxful_price":11.99,"base_unit_price":11.99},{"base_price":24.99,"discount_percentage":0,"quantity":1,"manufacturer":"Oceanavigations","tax_amount":0,"product_id":19400,"category":"Men's Clothing","sku":"ZO0299602996","taxless_price":24.99,"unit_discount_amount":0,"min_price":11.75,"_id":"sold_product_584677_19400","discount_amount":0,"created_on":"2016-12-26T09:28:48+00:00","product_name":"Sweatshirt - grey multicolor","price":24.99,"taxful_price":24.99,"base_unit_price":24.99}],"sku":["ZO0549605496","ZO0299602996"],"taxful_total_price":36.98,"taxless_total_price":36.98,"total_quantity":2,"total_unique_products":2,"type":"order","user":"eddie","geoip":{"country_iso_code":"EG","location":{"lon":31.3,"lat":30.1},"region_name":"Cairo Governorate","continent_name":"Africa","city_name":"Cairo"}}},{"_index":"kibana_sample_data_ecommerce","_type":"_doc","_id":"UnYbP24B9uEN4vPiBjWP","_score":1.0,"_source":{"category":["Women's Clothing"],"currency":"EUR","customer_first_name":"Mary","customer_full_name":"Mary Bailey","customer_gender":"FEMALE","customer_id":20,"customer_last_name":"Bailey","customer_phone":"","day_of_week":"Sunday","day_of_week_i":6,"email":"[email protected]","manufacturer":["Champion Arts","Pyramidustries"],"order_date":"2019-11-24T21:59:02+00:00","order_id":584021,"products":[{"base_price":24.99,"discount_percentage":0,"quantity":1,"manufacturer":"Champion Arts","tax_amount":0,"product_id":11238,"category":"Women's Clothing","sku":"ZO0489604896","taxless_price":24.99,"unit_discount_amount":0,"min_price":11.75,"_id":"sold_product_584021_11238","discount_amount":0,"created_on":"2016-12-25T21:59:02+00:00","product_name":"Denim dress - black denim","price":24.99,"taxful_price":24.99,"base_unit_price":24.99},{"base_price":28.99,"discount_percentage":0,"quantity":1,"manufacturer":"Pyramidustries","tax_amount":0,"product_id":20149,"category":"Women's Clothing","sku":"ZO0185501855","taxless_price":28.99,"unit_discount_amount":0,"min_price":15.65,"_id":"sold_product_584021_20149","discount_amount":0,"created_on":"2016-12-25T21:59:02+00:00","product_name":"Shorts - black","price":28.99,"taxful_price":28.99,"base_unit_price":28.99}],"sku":["ZO0489604896","ZO0185501855"],"taxful_total_price":53.98,"taxless_total_price":53.98,"total_quantity":2,"total_unique_products":2,"type":"order","user":"mary","geoip":{"country_iso_code":"AE","location":{"lon":55.3,"lat":25.3},"region_name":"Dubai","continent_name":"Asia","city_name":"Dubai"}}},{"_index":"kibana_sample_data_ecommerce","_type":"_doc","_id":"U3YbP24B9uEN4vPiBjWP","_score":1.0,"_source":{"category":["Women's Shoes","Women's Clothing"],"currency":"EUR","customer_first_name":"Gwen","customer_full_name":"Gwen Butler","customer_gender":"FEMALE","customer_id":26,"customer_last_name":"Butler","customer_phone":"","day_of_week":"Sunday","day_of_week_i":6,"email":"[email protected]","manufacturer":["Low Tide Media","Oceanavigations"],"order_date":"2019-11-24T22:32:10+00:00","order_id":584058,"products":[{"base_price":99.99,"discount_percentage":0,"quantity":1,"manufacturer":"Low Tide Media","tax_amount":0,"product_id":22794,"category":"Women's Shoes","sku":"ZO0374603746","taxless_price":99.99,"unit_discount_amount":0,"min_price":46,"_id":"sold_product_584058_22794","discount_amount":0,"created_on":"2016-12-25T22:32:10+00:00","product_name":"Boots - Midnight Blue","price":99.99,"taxful_price":99.99,"base_unit_price":99.99},{"base_price":99.99,"discount_percentage":0,"quantity":1,"manufacturer":"Oceanavigations","tax_amount":0,"product_id":23386,"category":"Women's Clothing","sku":"ZO0272202722","taxless_price":99.99,"unit_discount_amount":0,"min_price":53.99,"_id":"sold_product_584058_23386","discount_amount":0,"created_on":"2016-12-25T22:32:10+00:00","product_name":"Short coat - white/black","price":99.99,"taxful_price":99.99,"base_unit_price":99.99}],"sku":["ZO0374603746","ZO0272202722"],"taxful_total_price":199.98,"taxless_total_price":199.98,"total_quantity":2,"total_unique_products":2,"type":"order","user":"gwen","geoip":{"country_iso_code":"US","location":{"lon":-118.2,"lat":34.1},"region_name":"California","continent_name":"North America","city_name":"Los Angeles"}}},{"_index":"kibana_sample_data_ecommerce","_type":"_doc","_id":"VHYbP24B9uEN4vPiBjWP","_score":1.0,"_source":{"category":["Women's Shoes","Women's Clothing"],"currency":"EUR","customer_first_name":"Diane","customer_full_name":"Diane Chandler","customer_gender":"FEMALE","customer_id":22,"customer_last_name":"Chandler","customer_phone":"","day_of_week":"Sunday","day_of_week_i":6,"email":"[email protected]","manufacturer":["Primemaster","Oceanavigations"],"order_date":"2019-11-24T22:58:05+00:00","order_id":584093,"products":[{"base_price":74.99,"discount_percentage":0,"quantity":1,"manufacturer":"Primemaster","tax_amount":0,"product_id":12304,"category":"Women's Shoes","sku":"ZO0360303603","taxless_price":74.99,"unit_discount_amount":0,"min_price":34.5,"_id":"sold_product_584093_12304","discount_amount":0,"created_on":"2016-12-25T22:58:05+00:00","product_name":"High heeled sandals - argento","price":74.99,"taxful_price":74.99,"base_unit_price":74.99},{"base_price":99.99,"discount_percentage":0,"quantity":1,"manufacturer":"Oceanavigations","tax_amount":0,"product_id":19587,"category":"Women's Clothing","sku":"ZO0272002720","taxless_price":99.99,"unit_discount_amount":0,"min_price":47,"_id":"sold_product_584093_19587","discount_amount":0,"created_on":"2016-12-25T22:58:05+00:00","product_name":"Classic coat - black","price":99.99,"taxful_price":99.99,"base_unit_price":99.99}],"sku":["ZO0360303603","ZO0272002720"],"taxful_total_price":174.98,"taxless_total_price":174.98,"total_quantity":2,"total_unique_products":2,"type":"order","user":"diane","geoip":{"country_iso_code":"GB","location":{"lon":-0.1,"lat":51.5},"continent_name":"Europe"}}},{"_index":"kibana_sample_data_ecommerce","_type":"_doc","_id":"VXYbP24B9uEN4vPiBjWP","_score":1.0,"_source":{"category":["Men's Clothing","Men's Accessories"],"currency":"EUR","customer_first_name":"Eddie","customer_full_name":"Eddie Weber","customer_gender":"MALE","customer_id":38,"customer_last_name":"Weber","customer_phone":"","day_of_week":"Monday","day_of_week_i":0,"email":"[email protected]","manufacturer":["Elitelligence"],"order_date":"2019-11-18T03:48:58+00:00","order_id":574916,"products":[{"base_price":59.99,"discount_percentage":0,"quantity":1,"manufacturer":"Elitelligence","tax_amount":0,"product_id":11262,"category":"Men's Clothing","sku":"ZO0542505425","taxless_price":59.99,"unit_discount_amount":0,"min_price":28.2,"_id":"sold_product_574916_11262","discount_amount":0,"created_on":"2016-12-19T03:48:58+00:00","product_name":"Winter jacket - black","price":59.99,"taxful_price":59.99,"base_unit_price":59.99},{"base_price":20.99,"discount_percentage":0,"quantity":1,"manufacturer":"Elitelligence","tax_amount":0,"product_id":15713,"category":"Men's Accessories","sku":"ZO0601306013","taxless_price":20.99,"unit_discount_amount":0,"min_price":10.7,"_id":"sold_product_574916_15713","discount_amount":0,"created_on":"2016-12-19T03:48:58+00:00","product_name":"Watch - green","price":20.99,"taxful_price":20.99,"base_unit_price":20.99}],"sku":["ZO0542505425","ZO0601306013"],"taxful_total_price":80.98,"taxless_total_price":80.98,"total_quantity":2,"total_unique_products":2,"type":"order","user":"eddie","geoip":{"country_iso_code":"EG","location":{"lon":31.3,"lat":30.1},"region_name":"Cairo Governorate","continent_name":"Africa","city_name":"Cairo"}}},{"_index":"kibana_sample_data_ecommerce","_type":"_doc","_id":"VnYbP24B9uEN4vPiBjWP","_score":1.0,"_source":{"category":["Women's Shoes","Women's Clothing"],"currency":"EUR","customer_first_name":"Diane","customer_full_name":"Diane Goodwin","customer_gender":"FEMALE","customer_id":22,"customer_last_name":"Goodwin","customer_phone":"","day_of_week":"Sunday","day_of_week_i":6,"email":"[email protected]","manufacturer":["Low Tide Media","Pyramidustries"],"order_date":"2019-11-17T21:44:38+00:00","order_id":574586,"products":[{"base_price":59.99,"discount_percentage":0,"quantity":1,"manufacturer":"Low Tide Media","tax_amount":0,"product_id":5419,"category":"Women's Shoes","sku":"ZO0376303763","taxless_price":59.99,"unit_discount_amount":0,"min_price":31.79,"_id":"sold_product_574586_5419","discount_amount":0,"created_on":"2016-12-18T21:44:38+00:00","product_name":"Winter boots - brown","price":59.99,"taxful_price":59.99,"base_unit_price":59.99},{"base_price":11.99,"discount_percentage":0,"quantity":1,"manufacturer":"Pyramidustries","tax_amount":0,"product_id":19325,"category":"Women's Clothing","sku":"ZO0212402124","taxless_price":11.99,"unit_discount_amount":0,"min_price":6.47,"_id":"sold_product_574586_19325","discount_amount":0,"created_on":"2016-12-18T21:44:38+00:00","product_name":"Shorts - dark blue/pink/dark green","price":11.99,"taxful_price":11.99,"base_unit_price":11.99}],"sku":["ZO0376303763","ZO0212402124"],"taxful_total_price":71.98,"taxless_total_price":71.98,"total_quantity":2,"total_unique_products":2,"type":"order","user":"diane","geoip":{"country_iso_code":"GB","location":{"lon":-0.1,"lat":51.5},"continent_name":"Europe"}}},{"_index":"kibana_sample_data_ecommerce","_type":"_doc","_id":"V3YbP24B9uEN4vPiBjWP","_score":1.0,"_source":{"category":["Men's Clothing"],"currency":"EUR","customer_first_name":"Oliver","customer_full_name":"Oliver Rios","customer_gender":"MALE","customer_id":7,"customer_last_name":"Rios","customer_phone":"","day_of_week":"Monday","day_of_week_i":0,"email":"[email protected]","manufacturer":["Low Tide Media","Elitelligence"],"order_date":"2019-11-11T09:27:22+00:00","order_id":565855,"products":[{"base_price":20.99,"discount_percentage":0,"quantity":1,"manufacturer":"Low Tide Media","tax_amount":0,"product_id":19919,"category":"Men's Clothing","sku":"ZO0417504175","taxless_price":20.99,"unit_discount_amount":0,"min_price":9.87,"_id":"sold_product_565855_19919","discount_amount":0,"created_on":"2016-12-12T09:27:22+00:00","product_name":"Shirt - dark blue white","price":20.99,"taxful_price":20.99,"base_unit_price":20.99},{"base_price":24.99,"discount_percentage":0,"quantity":1,"manufacturer":"Elitelligence","tax_amount":0,"product_id":24502,"category":"Men's Clothing","sku":"ZO0535205352","taxless_price":24.99,"unit_discount_amount":0,"min_price":12.49,"_id":"sold_product_565855_24502","discount_amount":0,"created_on":"2016-12-12T09:27:22+00:00","product_name":"Slim fit jeans - raw blue","price":24.99,"taxful_price":24.99,"base_unit_price":24.99}],"sku":["ZO0417504175","ZO0535205352"],"taxful_total_price":45.98,"taxless_total_price":45.98,"total_quantity":2,"total_unique_products":2,"type":"order","user":"oliver","geoip":{"country_iso_code":"GB","location":{"lon":-0.1,"lat":51.5},"continent_name":"Europe"}}},{"_index":"kibana_sample_data_ecommerce","_type":"_doc","_id":"WHYbP24B9uEN4vPiBjWQ","_score":1.0,"_source":{"category":["Men's Clothing","Men's Accessories","Men's Shoes"],"currency":"EUR","customer_first_name":"Abd","customer_full_name":"Abd Sutton","customer_gender":"MALE","customer_id":52,"customer_last_name":"Sutton","customer_phone":"","day_of_week":"Monday","day_of_week_i":0,"email":"[email protected]","manufacturer":["Low Tide Media","Oceanavigations","Elitelligence"],"order_date":"2019-11-25T02:19:41+00:00","order_id":723055,"products":[{"base_price":28.99,"discount_percentage":0,"quantity":1,"manufacturer":"Low Tide Media","tax_amount":0,"product_id":11751,"category":"Men's Clothing","sku":"ZO0423104231","taxless_price":28.99,"unit_discount_amount":0,"min_price":14.78,"_id":"sold_product_723055_11751","discount_amount":0,"created_on":"2016-12-26T02:19:41+00:00","product_name":"Shorts - beige","price":28.99,"taxful_price":28.99,"base_unit_price":28.99},{"base_price":41.99,"discount_percentage":0,"quantity":1,"manufacturer":"Oceanavigations","tax_amount":0,"product_id":13452,"category":"Men's Accessories","sku":"ZO0314203142","taxless_price":41.99,"unit_discount_amount":0,"min_price":20.58,"_id":"sold_product_723055_13452","discount_amount":0,"created_on":"2016-12-26T02:19:41+00:00","product_name":"Weekend bag - black","price":41.99,"taxful_price":41.99,"base_unit_price":41.99},{"base_price":59.99,"discount_percentage":0,"quantity":1,"manufacturer":"Low Tide Media","tax_amount":0,"product_id":22434,"category":"Men's Shoes","sku":"ZO0394403944","taxless_price":59.99,"unit_discount_amount":0,"min_price":30,"_id":"sold_product_723055_22434","discount_amount":0,"created_on":"2016-12-26T02:19:41+00:00","product_name":"Casual lace-ups - cognac","price":59.99,"taxful_price":59.99,"base_unit_price":59.99},{"base_price":7.99,"discount_percentage":0,"quantity":1,"manufacturer":"Elitelligence","tax_amount":0,"product_id":7059,"category":"Men's Clothing","sku":"ZO0561805618","taxless_price":7.99,"unit_discount_amount":0,"min_price":3.76,"_id":"sold_product_723055_7059","discount_amount":0,"created_on":"2016-12-26T02:19:41+00:00","product_name":"Print T-shirt - off white/green","price":7.99,"taxful_price":7.99,"base_unit_price":7.99}],"sku":["ZO0423104231","ZO0314203142","ZO0394403944","ZO0561805618"],"taxful_total_price":138.96,"taxless_total_price":138.96,"total_quantity":4,"total_unique_products":4,"type":"order","user":"abd","geoip":{"country_iso_code":"EG","location":{"lon":31.3,"lat":30.1},"region_name":"Cairo Governorate","continent_name":"Africa","city_name":"Cairo"}}},{"_index":"kibana_sample_data_ecommerce","_type":"_doc","_id":"WXYbP24B9uEN4vPiBjWQ","_score":1.0,"_source":{"category":["Women's Accessories","Women's Clothing"],"currency":"EUR","customer_first_name":"Wilhemina St.","customer_full_name":"Wilhemina St. Tran","customer_gender":"FEMALE","customer_id":17,"customer_last_name":"Tran","customer_phone":"","day_of_week":"Sunday","day_of_week_i":6,"email":"wilhemina [email protected]","manufacturer":["Pyramidustries","Tigress Enterprises","Pyramidustries active","Oceanavigations"],"order_date":"2019-11-17T00:59:02+00:00","order_id":727462,"products":[{"base_price":8.99,"discount_percentage":0,"quantity":1,"manufacturer":"Pyramidustries","tax_amount":0,"product_id":12012,"category":"Women's Accessories","sku":"ZO0186801868","taxless_price":8.99,"unit_discount_amount":0,"min_price":4.14,"_id":"sold_product_727462_12012","discount_amount":0,"created_on":"2016-12-18T00:59:02+00:00","product_name":"Mittens - grey","price":8.99,"taxful_price":8.99,"base_unit_price":8.99},{"base_price":20.99,"discount_percentage":0,"quantity":1,"manufacturer":"Tigress Enterprises","tax_amount":0,"product_id":16471,"category":"Women's Clothing","sku":"ZO0074100741","taxless_price":20.99,"unit_discount_amount":0,"min_price":9.66,"_id":"sold_product_727462_16471","discount_amount":0,"created_on":"2016-12-18T00:59:02+00:00","product_name":"Vest - black/Chocolate","price":20.99,"taxful_price":20.99,"base_unit_price":20.99},{"base_price":16.99,"discount_percentage":0,"quantity":1,"manufacturer":"Pyramidustries active","tax_amount":0,"product_id":10554,"category":"Women's Clothing","sku":"ZO0223202232","taxless_price":16.99,"unit_discount_amount":0,"min_price":7.82,"_id":"sold_product_727462_10554","discount_amount":0,"created_on":"2016-12-18T00:59:02+00:00","product_name":"Tracksuit bottoms - Pale Violet Red","price":16.99,"taxful_price":16.99,"base_unit_price":16.99},{"base_price":41.99,"discount_percentage":0,"quantity":1,"manufacturer":"Oceanavigations","tax_amount":0,"product_id":22882,"category":"Women's Clothing","sku":"ZO0267602676","taxless_price":41.99,"unit_discount_amount":0,"min_price":23.09,"_id":"sold_product_727462_22882","discount_amount":0,"created_on":"2016-12-18T00:59:02+00:00","product_name":"Cardigan - black","price":41.99,"taxful_price":41.99,"base_unit_price":41.99}],"sku":["ZO0186801868","ZO0074100741","ZO0223202232","ZO0267602676"],"taxful_total_price":88.96,"taxless_total_price":88.96,"total_quantity":4,"total_unique_products":4,"type":"order","user":"wilhemina","geoip":{"country_iso_code":"MC","location":{"lon":7.4,"lat":43.7},"continent_name":"Europe","city_name":"Monte Carlo"}}},{"_index":"kibana_sample_data_ecommerce","_type":"_doc","_id":"WnYbP24B9uEN4vPiBjWQ","_score":1.0,"_source":{"category":["Women's Shoes","Women's Clothing"],"currency":"EUR","customer_first_name":"Rabbia Al","customer_full_name":"Rabbia Al Baker","customer_gender":"FEMALE","customer_id":5,"customer_last_name":"Baker","customer_phone":"","day_of_week":"Monday","day_of_week_i":0,"email":"rabbia [email protected]","manufacturer":["Oceanavigations","Tigress Enterprises","Champion Arts","Pyramidustries"],"order_date":"2019-11-25T03:41:46+00:00","order_id":727269,"products":[{"base_price":74.99,"discount_percentage":0,"quantity":1,"manufacturer":"Oceanavigations","tax_amount":0,"product_id":22880,"category":"Women's Shoes","sku":"ZO0249902499","taxless_price":74.99,"unit_discount_amount":0,"min_price":35.25,"_id":"sold_product_727269_22880","discount_amount":0,"created_on":"2016-12-26T03:41:46+00:00","product_name":"Boots - black","price":74.99,"taxful_price":74.99,"base_unit_price":74.99},{"base_price":32.99,"discount_percentage":0,"quantity":1,"manufacturer":"Tigress Enterprises","tax_amount":0,"product_id":12484,"category":"Women's Clothing","sku":"ZO0068400684","taxless_price":32.99,"unit_discount_amount":0,"min_price":17.48,"_id":"sold_product_727269_12484","discount_amount":0,"created_on":"2016-12-26T03:41:46+00:00","product_name":"Cardigan - black/white","price":32.99,"taxful_price":32.99,"base_unit_price":32.99},{"base_price":13.99,"discount_percentage":0,"quantity":1,"manufacturer":"Champion Arts","tax_amount":0,"product_id":21362,"category":"Women's Clothing","sku":"ZO0494704947","taxless_price":13.99,"unit_discount_amount":0,"min_price":6.58,"_id":"sold_product_727269_21362","discount_amount":0,"created_on":"2016-12-26T03:41:46+00:00","product_name":"Long sleeved top - blue","price":13.99,"taxful_price":13.99,"base_unit_price":13.99},{"base_price":49.99,"discount_percentage":0,"quantity":1,"manufacturer":"Pyramidustries","tax_amount":0,"product_id":13854,"category":"Women's Shoes","sku":"ZO0143401434","taxless_price":49.99,"unit_discount_amount":0,"min_price":25.49,"_id":"sold_product_727269_13854","discount_amount":0,"created_on":"2016-12-26T03:41:46+00:00","product_name":"Lace-up boots - black","price":49.99,"taxful_price":49.99,"base_unit_price":49.99}],"sku":["ZO0249902499","ZO0068400684","ZO0494704947","ZO0143401434"],"taxful_total_price":171.96,"taxless_total_price":171.96,"total_quantity":4,"total_unique_products":4,"type":"order","user":"rabbia","geoip":{"country_iso_code":"AE","location":{"lon":55.3,"lat":25.3},"region_name":"Dubai","continent_name":"Asia","city_name":"Dubai"}}}]}}
kibana 上查询
POST kibana_sample_data_ecommerce/_search
{
"query":{
"match_all":{}
}
} {
"took" : 2, 花费的时间
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 4675, 符合条件的总文档数
"relation" : "eq"
},
"max_score" : 1.0,
"hits" : [ 结果集，默认前10个
{
"_index" : "kibana_sample_data_ecommerce", 索引名
"_type" : "_doc",
"_id" : "UXYbP24B9uEN4vPiBjWP", ID
"_score" : 1.0, 相关度评分
"_source" : { 文档原始数据
"category" : [
"Men's Clothing"
],
"currency" : "EUR",
"customer_first_name" : "Eddie",
"customer_full_name" : "Eddie Underwood",
"customer_gender" : "MALE",
"customer_id" : 38,
"customer_last_name" : "Underwood",
"customer_phone" : "",
"day_of_week" : "Monday",
"day_of_week_i" : 0,
"email" : "[email protected]",
"manufacturer" : [
"Elitelligence",
"Oceanavigations"
],
"order_date" : "2019-11-25T09:28:48+00:00",
"order_id" : 584677,
"products" : [
{
"base_price" : 11.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Elitelligence",
"tax_amount" : 0,
"product_id" : 6283,
"category" : "Men's Clothing",
"sku" : "ZO0549605496",
"taxless_price" : 11.99,
"unit_discount_amount" : 0,
"min_price" : 6.35,
"_id" : "sold_product_584677_6283",
"discount_amount" : 0,
"created_on" : "2016-12-26T09:28:48+00:00",
"product_name" : "Basic T-shirt - dark blue/white",
"price" : 11.99,
"taxful_price" : 11.99,
"base_unit_price" : 11.99
},
{
"base_price" : 24.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Oceanavigations",
"tax_amount" : 0,
"product_id" : 19400,
"category" : "Men's Clothing",
"sku" : "ZO0299602996",
"taxless_price" : 24.99,
"unit_discount_amount" : 0,
"min_price" : 11.75,
"_id" : "sold_product_584677_19400",
"discount_amount" : 0,
"created_on" : "2016-12-26T09:28:48+00:00",
"product_name" : "Sweatshirt - grey multicolor",
"price" : 24.99,
"taxful_price" : 24.99,
"base_unit_price" : 24.99
}
],
"sku" : [
"ZO0549605496",
"ZO0299602996"
],
"taxful_total_price" : 36.98,
"taxless_total_price" : 36.98,
"total_quantity" : 2,
"total_unique_products" : 2,
"type" : "order",
"user" : "eddie",
"geoip" : {
"country_iso_code" : "EG",
"location" : {
"lon" : 31.3,
"lat" : 30.1
},
"region_name" : "Cairo Governorate",
"continent_name" : "Africa",
"city_name" : "Cairo"
}
}
},
{
"_index" : "kibana_sample_data_ecommerce",
"_type" : "_doc",
"_id" : "UnYbP24B9uEN4vPiBjWP",
"_score" : 1.0,
"_source" : {
"category" : [
"Women's Clothing"
],
"currency" : "EUR",
"customer_first_name" : "Mary",
"customer_full_name" : "Mary Bailey",
"customer_gender" : "FEMALE",
"customer_id" : 20,
"customer_last_name" : "Bailey",
"customer_phone" : "",
"day_of_week" : "Sunday",
"day_of_week_i" : 6,
"email" : "[email protected]",
"manufacturer" : [
"Champion Arts",
"Pyramidustries"
],
"order_date" : "2019-11-24T21:59:02+00:00",
"order_id" : 584021,
"products" : [
{
"base_price" : 24.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Champion Arts",
"tax_amount" : 0,
"product_id" : 11238,
"category" : "Women's Clothing",
"sku" : "ZO0489604896",
"taxless_price" : 24.99,
"unit_discount_amount" : 0,
"min_price" : 11.75,
"_id" : "sold_product_584021_11238",
"discount_amount" : 0,
"created_on" : "2016-12-25T21:59:02+00:00",
"product_name" : "Denim dress - black denim",
"price" : 24.99,
"taxful_price" : 24.99,
"base_unit_price" : 24.99
},
{
"base_price" : 28.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Pyramidustries",
"tax_amount" : 0,
"product_id" : 20149,
"category" : "Women's Clothing",
"sku" : "ZO0185501855",
"taxless_price" : 28.99,
"unit_discount_amount" : 0,
"min_price" : 15.65,
"_id" : "sold_product_584021_20149",
"discount_amount" : 0,
"created_on" : "2016-12-25T21:59:02+00:00",
"product_name" : "Shorts - black",
"price" : 28.99,
"taxful_price" : 28.99,
"base_unit_price" : 28.99
}
],
"sku" : [
"ZO0489604896",
"ZO0185501855"
],
"taxful_total_price" : 53.98,
"taxless_total_price" : 53.98,
"total_quantity" : 2,
"total_unique_products" : 2,
"type" : "order",
"user" : "mary",
"geoip" : {
"country_iso_code" : "AE",
"location" : {
"lon" : 55.3,
"lat" : 25.3
},
"region_name" : "Dubai",
"continent_name" : "Asia",
"city_name" : "Dubai"
}
}
},
{
"_index" : "kibana_sample_data_ecommerce",
"_type" : "_doc",
"_id" : "U3YbP24B9uEN4vPiBjWP",
"_score" : 1.0,
"_source" : {
"category" : [
"Women's Shoes",
"Women's Clothing"
],
"currency" : "EUR",
"customer_first_name" : "Gwen",
"customer_full_name" : "Gwen Butler",
"customer_gender" : "FEMALE",
"customer_id" : 26,
"customer_last_name" : "Butler",
"customer_phone" : "",
"day_of_week" : "Sunday",
"day_of_week_i" : 6,
"email" : "[email protected]",
"manufacturer" : [
"Low Tide Media",
"Oceanavigations"
],
"order_date" : "2019-11-24T22:32:10+00:00",
"order_id" : 584058,
"products" : [
{
"base_price" : 99.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Low Tide Media",
"tax_amount" : 0,
"product_id" : 22794,
"category" : "Women's Shoes",
"sku" : "ZO0374603746",
"taxless_price" : 99.99,
"unit_discount_amount" : 0,
"min_price" : 46,
"_id" : "sold_product_584058_22794",
"discount_amount" : 0,
"created_on" : "2016-12-25T22:32:10+00:00",
"product_name" : "Boots - Midnight Blue",
"price" : 99.99,
"taxful_price" : 99.99,
"base_unit_price" : 99.99
},
{
"base_price" : 99.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Oceanavigations",
"tax_amount" : 0,
"product_id" : 23386,
"category" : "Women's Clothing",
"sku" : "ZO0272202722",
"taxless_price" : 99.99,
"unit_discount_amount" : 0,
"min_price" : 53.99,
"_id" : "sold_product_584058_23386",
"discount_amount" : 0,
"created_on" : "2016-12-25T22:32:10+00:00",
"product_name" : "Short coat - white/black",
"price" : 99.99,
"taxful_price" : 99.99,
"base_unit_price" : 99.99
}
],
"sku" : [
"ZO0374603746",
"ZO0272202722"
],
"taxful_total_price" : 199.98,
"taxless_total_price" : 199.98,
"total_quantity" : 2,
"total_unique_products" : 2,
"type" : "order",
"user" : "gwen",
"geoip" : {
"country_iso_code" : "US",
"location" : {
"lon" : -118.2,
"lat" : 34.1
},
"region_name" : "California",
"continent_name" : "North America",
"city_name" : "Los Angeles"
}
}
},
{
"_index" : "kibana_sample_data_ecommerce",
"_type" : "_doc",
"_id" : "VHYbP24B9uEN4vPiBjWP",
"_score" : 1.0,
"_source" : {
"category" : [
"Women's Shoes",
"Women's Clothing"
],
"currency" : "EUR",
"customer_first_name" : "Diane",
"customer_full_name" : "Diane Chandler",
"customer_gender" : "FEMALE",
"customer_id" : 22,
"customer_last_name" : "Chandler",
"customer_phone" : "",
"day_of_week" : "Sunday",
"day_of_week_i" : 6,
"email" : "[email protected]",
"manufacturer" : [
"Primemaster",
"Oceanavigations"
],
"order_date" : "2019-11-24T22:58:05+00:00",
"order_id" : 584093,
"products" : [
{
"base_price" : 74.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Primemaster",
"tax_amount" : 0,
"product_id" : 12304,
"category" : "Women's Shoes",
"sku" : "ZO0360303603",
"taxless_price" : 74.99,
"unit_discount_amount" : 0,
"min_price" : 34.5,
"_id" : "sold_product_584093_12304",
"discount_amount" : 0,
"created_on" : "2016-12-25T22:58:05+00:00",
"product_name" : "High heeled sandals - argento",
"price" : 74.99,
"taxful_price" : 74.99,
"base_unit_price" : 74.99
},
{
"base_price" : 99.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Oceanavigations",
"tax_amount" : 0,
"product_id" : 19587,
"category" : "Women's Clothing",
"sku" : "ZO0272002720",
"taxless_price" : 99.99,
"unit_discount_amount" : 0,
"min_price" : 47,
"_id" : "sold_product_584093_19587",
"discount_amount" : 0,
"created_on" : "2016-12-25T22:58:05+00:00",
"product_name" : "Classic coat - black",
"price" : 99.99,
"taxful_price" : 99.99,
"base_unit_price" : 99.99
}
],
"sku" : [
"ZO0360303603",
"ZO0272002720"
],
"taxful_total_price" : 174.98,
"taxless_total_price" : 174.98,
"total_quantity" : 2,
"total_unique_products" : 2,
"type" : "order",
"user" : "diane",
"geoip" : {
"country_iso_code" : "GB",
"location" : {
"lon" : -0.1,
"lat" : 51.5
},
"continent_name" : "Europe"
}
}
},
{
"_index" : "kibana_sample_data_ecommerce",
"_type" : "_doc",
"_id" : "VXYbP24B9uEN4vPiBjWP",
"_score" : 1.0,
"_source" : {
"category" : [
"Men's Clothing",
"Men's Accessories"
],
"currency" : "EUR",
"customer_first_name" : "Eddie",
"customer_full_name" : "Eddie Weber",
"customer_gender" : "MALE",
"customer_id" : 38,
"customer_last_name" : "Weber",
"customer_phone" : "",
"day_of_week" : "Monday",
"day_of_week_i" : 0,
"email" : "[email protected]",
"manufacturer" : [
"Elitelligence"
],
"order_date" : "2019-11-18T03:48:58+00:00",
"order_id" : 574916,
"products" : [
{
"base_price" : 59.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Elitelligence",
"tax_amount" : 0,
"product_id" : 11262,
"category" : "Men's Clothing",
"sku" : "ZO0542505425",
"taxless_price" : 59.99,
"unit_discount_amount" : 0,
"min_price" : 28.2,
"_id" : "sold_product_574916_11262",
"discount_amount" : 0,
"created_on" : "2016-12-19T03:48:58+00:00",
"product_name" : "Winter jacket - black",
"price" : 59.99,
"taxful_price" : 59.99,
"base_unit_price" : 59.99
},
{
"base_price" : 20.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Elitelligence",
"tax_amount" : 0,
"product_id" : 15713,
"category" : "Men's Accessories",
"sku" : "ZO0601306013",
"taxless_price" : 20.99,
"unit_discount_amount" : 0,
"min_price" : 10.7,
"_id" : "sold_product_574916_15713",
"discount_amount" : 0,
"created_on" : "2016-12-19T03:48:58+00:00",
"product_name" : "Watch - green",
"price" : 20.99,
"taxful_price" : 20.99,
"base_unit_price" : 20.99
}
],
"sku" : [
"ZO0542505425",
"ZO0601306013"
],
"taxful_total_price" : 80.98,
"taxless_total_price" : 80.98,
"total_quantity" : 2,
"total_unique_products" : 2,
"type" : "order",
"user" : "eddie",
"geoip" : {
"country_iso_code" : "EG",
"location" : {
"lon" : 31.3,
"lat" : 30.1
},
"region_name" : "Cairo Governorate",
"continent_name" : "Africa",
"city_name" : "Cairo"
}
}
},
{
"_index" : "kibana_sample_data_ecommerce",
"_type" : "_doc",
"_id" : "VnYbP24B9uEN4vPiBjWP",
"_score" : 1.0,
"_source" : {
"category" : [
"Women's Shoes",
"Women's Clothing"
],
"currency" : "EUR",
"customer_first_name" : "Diane",
"customer_full_name" : "Diane Goodwin",
"customer_gender" : "FEMALE",
"customer_id" : 22,
"customer_last_name" : "Goodwin",
"customer_phone" : "",
"day_of_week" : "Sunday",
"day_of_week_i" : 6,
"email" : "[email protected]",
"manufacturer" : [
"Low Tide Media",
"Pyramidustries"
],
"order_date" : "2019-11-17T21:44:38+00:00",
"order_id" : 574586,
"products" : [
{
"base_price" : 59.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Low Tide Media",
"tax_amount" : 0,
"product_id" : 5419,
"category" : "Women's Shoes",
"sku" : "ZO0376303763",
"taxless_price" : 59.99,
"unit_discount_amount" : 0,
"min_price" : 31.79,
"_id" : "sold_product_574586_5419",
"discount_amount" : 0,
"created_on" : "2016-12-18T21:44:38+00:00",
"product_name" : "Winter boots - brown",
"price" : 59.99,
"taxful_price" : 59.99,
"base_unit_price" : 59.99
},
{
"base_price" : 11.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Pyramidustries",
"tax_amount" : 0,
"product_id" : 19325,
"category" : "Women's Clothing",
"sku" : "ZO0212402124",
"taxless_price" : 11.99,
"unit_discount_amount" : 0,
"min_price" : 6.47,
"_id" : "sold_product_574586_19325",
"discount_amount" : 0,
"created_on" : "2016-12-18T21:44:38+00:00",
"product_name" : "Shorts - dark blue/pink/dark green",
"price" : 11.99,
"taxful_price" : 11.99,
"base_unit_price" : 11.99
}
],
"sku" : [
"ZO0376303763",
"ZO0212402124"
],
"taxful_total_price" : 71.98,
"taxless_total_price" : 71.98,
"total_quantity" : 2,
"total_unique_products" : 2,
"type" : "order",
"user" : "diane",
"geoip" : {
"country_iso_code" : "GB",
"location" : {
"lon" : -0.1,
"lat" : 51.5
},
"continent_name" : "Europe"
}
}
},
{
"_index" : "kibana_sample_data_ecommerce",
"_type" : "_doc",
"_id" : "V3YbP24B9uEN4vPiBjWP",
"_score" : 1.0,
"_source" : {
"category" : [
"Men's Clothing"
],
"currency" : "EUR",
"customer_first_name" : "Oliver",
"customer_full_name" : "Oliver Rios",
"customer_gender" : "MALE",
"customer_id" : 7,
"customer_last_name" : "Rios",
"customer_phone" : "",
"day_of_week" : "Monday",
"day_of_week_i" : 0,
"email" : "[email protected]",
"manufacturer" : [
"Low Tide Media",
"Elitelligence"
],
"order_date" : "2019-11-11T09:27:22+00:00",
"order_id" : 565855,
"products" : [
{
"base_price" : 20.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Low Tide Media",
"tax_amount" : 0,
"product_id" : 19919,
"category" : "Men's Clothing",
"sku" : "ZO0417504175",
"taxless_price" : 20.99,
"unit_discount_amount" : 0,
"min_price" : 9.87,
"_id" : "sold_product_565855_19919",
"discount_amount" : 0,
"created_on" : "2016-12-12T09:27:22+00:00",
"product_name" : "Shirt - dark blue white",
"price" : 20.99,
"taxful_price" : 20.99,
"base_unit_price" : 20.99
},
{
"base_price" : 24.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Elitelligence",
"tax_amount" : 0,
"product_id" : 24502,
"category" : "Men's Clothing",
"sku" : "ZO0535205352",
"taxless_price" : 24.99,
"unit_discount_amount" : 0,
"min_price" : 12.49,
"_id" : "sold_product_565855_24502",
"discount_amount" : 0,
"created_on" : "2016-12-12T09:27:22+00:00",
"product_name" : "Slim fit jeans - raw blue",
"price" : 24.99,
"taxful_price" : 24.99,
"base_unit_price" : 24.99
}
],
"sku" : [
"ZO0417504175",
"ZO0535205352"
],
"taxful_total_price" : 45.98,
"taxless_total_price" : 45.98,
"total_quantity" : 2,
"total_unique_products" : 2,
"type" : "order",
"user" : "oliver",
"geoip" : {
"country_iso_code" : "GB",
"location" : {
"lon" : -0.1,
"lat" : 51.5
},
"continent_name" : "Europe"
}
}
},
{
"_index" : "kibana_sample_data_ecommerce",
"_type" : "_doc",
"_id" : "WHYbP24B9uEN4vPiBjWQ",
"_score" : 1.0,
"_source" : {
"category" : [
"Men's Clothing",
"Men's Accessories",
"Men's Shoes"
],
"currency" : "EUR",
"customer_first_name" : "Abd",
"customer_full_name" : "Abd Sutton",
"customer_gender" : "MALE",
"customer_id" : 52,
"customer_last_name" : "Sutton",
"customer_phone" : "",
"day_of_week" : "Monday",
"day_of_week_i" : 0,
"email" : "[email protected]",
"manufacturer" : [
"Low Tide Media",
"Oceanavigations",
"Elitelligence"
],
"order_date" : "2019-11-25T02:19:41+00:00",
"order_id" : 723055,
"products" : [
{
"base_price" : 28.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Low Tide Media",
"tax_amount" : 0,
"product_id" : 11751,
"category" : "Men's Clothing",
"sku" : "ZO0423104231",
"taxless_price" : 28.99,
"unit_discount_amount" : 0,
"min_price" : 14.78,
"_id" : "sold_product_723055_11751",
"discount_amount" : 0,
"created_on" : "2016-12-26T02:19:41+00:00",
"product_name" : "Shorts - beige",
"price" : 28.99,
"taxful_price" : 28.99,
"base_unit_price" : 28.99
},
{
"base_price" : 41.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Oceanavigations",
"tax_amount" : 0,
"product_id" : 13452,
"category" : "Men's Accessories",
"sku" : "ZO0314203142",
"taxless_price" : 41.99,
"unit_discount_amount" : 0,
"min_price" : 20.58,
"_id" : "sold_product_723055_13452",
"discount_amount" : 0,
"created_on" : "2016-12-26T02:19:41+00:00",
"product_name" : "Weekend bag - black",
"price" : 41.99,
"taxful_price" : 41.99,
"base_unit_price" : 41.99
},
{
"base_price" : 59.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Low Tide Media",
"tax_amount" : 0,
"product_id" : 22434,
"category" : "Men's Shoes",
"sku" : "ZO0394403944",
"taxless_price" : 59.99,
"unit_discount_amount" : 0,
"min_price" : 30,
"_id" : "sold_product_723055_22434",
"discount_amount" : 0,
"created_on" : "2016-12-26T02:19:41+00:00",
"product_name" : "Casual lace-ups - cognac",
"price" : 59.99,
"taxful_price" : 59.99,
"base_unit_price" : 59.99
},
{
"base_price" : 7.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Elitelligence",
"tax_amount" : 0,
"product_id" : 7059,
"category" : "Men's Clothing",
"sku" : "ZO0561805618",
"taxless_price" : 7.99,
"unit_discount_amount" : 0,
"min_price" : 3.76,
"_id" : "sold_product_723055_7059",
"discount_amount" : 0,
"created_on" : "2016-12-26T02:19:41+00:00",
"product_name" : "Print T-shirt - off white/green",
"price" : 7.99,
"taxful_price" : 7.99,
"base_unit_price" : 7.99
}
],
"sku" : [
"ZO0423104231",
"ZO0314203142",
"ZO0394403944",
"ZO0561805618"
],
"taxful_total_price" : 138.96,
"taxless_total_price" : 138.96,
"total_quantity" : 4,
"total_unique_products" : 4,
"type" : "order",
"user" : "abd",
"geoip" : {
"country_iso_code" : "EG",
"location" : {
"lon" : 31.3,
"lat" : 30.1
},
"region_name" : "Cairo Governorate",
"continent_name" : "Africa",
"city_name" : "Cairo"
}
}
},
{
"_index" : "kibana_sample_data_ecommerce",
"_type" : "_doc",
"_id" : "WXYbP24B9uEN4vPiBjWQ",
"_score" : 1.0,
"_source" : {
"category" : [
"Women's Accessories",
"Women's Clothing"
],
"currency" : "EUR",
"customer_first_name" : "Wilhemina St.",
"customer_full_name" : "Wilhemina St. Tran",
"customer_gender" : "FEMALE",
"customer_id" : 17,
"customer_last_name" : "Tran",
"customer_phone" : "",
"day_of_week" : "Sunday",
"day_of_week_i" : 6,
"email" : "wilhemina [email protected]",
"manufacturer" : [
"Pyramidustries",
"Tigress Enterprises",
"Pyramidustries active",
"Oceanavigations"
],
"order_date" : "2019-11-17T00:59:02+00:00",
"order_id" : 727462,
"products" : [
{
"base_price" : 8.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Pyramidustries",
"tax_amount" : 0,
"product_id" : 12012,
"category" : "Women's Accessories",
"sku" : "ZO0186801868",
"taxless_price" : 8.99,
"unit_discount_amount" : 0,
"min_price" : 4.14,
"_id" : "sold_product_727462_12012",
"discount_amount" : 0,
"created_on" : "2016-12-18T00:59:02+00:00",
"product_name" : "Mittens - grey",
"price" : 8.99,
"taxful_price" : 8.99,
"base_unit_price" : 8.99
},
{
"base_price" : 20.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Tigress Enterprises",
"tax_amount" : 0,
"product_id" : 16471,
"category" : "Women's Clothing",
"sku" : "ZO0074100741",
"taxless_price" : 20.99,
"unit_discount_amount" : 0,
"min_price" : 9.66,
"_id" : "sold_product_727462_16471",
"discount_amount" : 0,
"created_on" : "2016-12-18T00:59:02+00:00",
"product_name" : "Vest - black/Chocolate",
"price" : 20.99,
"taxful_price" : 20.99,
"base_unit_price" : 20.99
},
{
"base_price" : 16.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Pyramidustries active",
"tax_amount" : 0,
"product_id" : 10554,
"category" : "Women's Clothing",
"sku" : "ZO0223202232",
"taxless_price" : 16.99,
"unit_discount_amount" : 0,
"min_price" : 7.82,
"_id" : "sold_product_727462_10554",
"discount_amount" : 0,
"created_on" : "2016-12-18T00:59:02+00:00",
"product_name" : "Tracksuit bottoms - Pale Violet Red",
"price" : 16.99,
"taxful_price" : 16.99,
"base_unit_price" : 16.99
},
{
"base_price" : 41.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Oceanavigations",
"tax_amount" : 0,
"product_id" : 22882,
"category" : "Women's Clothing",
"sku" : "ZO0267602676",
"taxless_price" : 41.99,
"unit_discount_amount" : 0,
"min_price" : 23.09,
"_id" : "sold_product_727462_22882",
"discount_amount" : 0,
"created_on" : "2016-12-18T00:59:02+00:00",
"product_name" : "Cardigan - black",
"price" : 41.99,
"taxful_price" : 41.99,
"base_unit_price" : 41.99
}
],
"sku" : [
"ZO0186801868",
"ZO0074100741",
"ZO0223202232",
"ZO0267602676"
],
"taxful_total_price" : 88.96,
"taxless_total_price" : 88.96,
"total_quantity" : 4,
"total_unique_products" : 4,
"type" : "order",
"user" : "wilhemina",
"geoip" : {
"country_iso_code" : "MC",
"location" : {
"lon" : 7.4,
"lat" : 43.7
},
"continent_name" : "Europe",
"city_name" : "Monte Carlo"
}
}
},
{
"_index" : "kibana_sample_data_ecommerce",
"_type" : "_doc",
"_id" : "WnYbP24B9uEN4vPiBjWQ",
"_score" : 1.0,
"_source" : {
"category" : [
"Women's Shoes",
"Women's Clothing"
],
"currency" : "EUR",
"customer_first_name" : "Rabbia Al",
"customer_full_name" : "Rabbia Al Baker",
"customer_gender" : "FEMALE",
"customer_id" : 5,
"customer_last_name" : "Baker",
"customer_phone" : "",
"day_of_week" : "Monday",
"day_of_week_i" : 0,
"email" : "rabbia [email protected]",
"manufacturer" : [
"Oceanavigations",
"Tigress Enterprises",
"Champion Arts",
"Pyramidustries"
],
"order_date" : "2019-11-25T03:41:46+00:00",
"order_id" : 727269,
"products" : [
{
"base_price" : 74.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Oceanavigations",
"tax_amount" : 0,
"product_id" : 22880,
"category" : "Women's Shoes",
"sku" : "ZO0249902499",
"taxless_price" : 74.99,
"unit_discount_amount" : 0,
"min_price" : 35.25,
"_id" : "sold_product_727269_22880",
"discount_amount" : 0,
"created_on" : "2016-12-26T03:41:46+00:00",
"product_name" : "Boots - black",
"price" : 74.99,
"taxful_price" : 74.99,
"base_unit_price" : 74.99
},
{
"base_price" : 32.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Tigress Enterprises",
"tax_amount" : 0,
"product_id" : 12484,
"category" : "Women's Clothing",
"sku" : "ZO0068400684",
"taxless_price" : 32.99,
"unit_discount_amount" : 0,
"min_price" : 17.48,
"_id" : "sold_product_727269_12484",
"discount_amount" : 0,
"created_on" : "2016-12-26T03:41:46+00:00",
"product_name" : "Cardigan - black/white",
"price" : 32.99,
"taxful_price" : 32.99,
"base_unit_price" : 32.99
},
{
"base_price" : 13.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Champion Arts",
"tax_amount" : 0,
"product_id" : 21362,
"category" : "Women's Clothing",
"sku" : "ZO0494704947",
"taxless_price" : 13.99,
"unit_discount_amount" : 0,
"min_price" : 6.58,
"_id" : "sold_product_727269_21362",
"discount_amount" : 0,
"created_on" : "2016-12-26T03:41:46+00:00",
"product_name" : "Long sleeved top - blue",
"price" : 13.99,
"taxful_price" : 13.99,
"base_unit_price" : 13.99
},
{
"base_price" : 49.99,
"discount_percentage" : 0,
"quantity" : 1,
"manufacturer" : "Pyramidustries",
"tax_amount" : 0,
"product_id" : 13854,
"category" : "Women's Shoes",
"sku" : "ZO0143401434",
"taxless_price" : 49.99,
"unit_discount_amount" : 0,
"min_price" : 25.49,
"_id" : "sold_product_727269_13854",
"discount_amount" : 0,
"created_on" : "2016-12-26T03:41:46+00:00",
"product_name" : "Lace-up boots - black",
"price" : 49.99,
"taxful_price" : 49.99,
"base_unit_price" : 49.99
}
],
"sku" : [
"ZO0249902499",
"ZO0068400684",
"ZO0494704947",
"ZO0143401434"
],
"taxful_total_price" : 171.96,
"taxless_total_price" : 171.96,
"total_quantity" : 4,
"total_unique_products" : 4,
"type" : "order",
"user" : "rabbia",
"geoip" : {
"country_iso_code" : "AE",
"location" : {
"lon" : 55.3,
"lat" : 25.3
},
"region_name" : "Dubai",
"continent_name" : "Asia",
"city_name" : "Dubai"
}
}
}
]
}
}
相关性的衡量
1 Precision（查准率）_尽可能返回较少的无关
2 Recall （查全率）_ 尽量返回较多的相关文档
3 Ranking—是否能够按照相关匹配度进行排序