es 搜索功能简介

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":"eddie@underwood-family.zzz","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":"eddie@weber-family.zzz","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":"eddie@gregory-family.zzz","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":"eddie@wolfe-family.zzz","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":"eddie@simpson-family.zzz","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":"eddie@riley-family.zzz","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":"eddie@graham-family.zzz","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":"eddie@clayton-family.zzz","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":"eddie@riley-family.zzz","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":"eddie@garza-family.zzz","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":"eddie@underwood-family.zzz","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":"mary@bailey-family.zzz","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":"gwen@butler-family.zzz","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":"diane@chandler-family.zzz","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":"eddie@weber-family.zzz","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":"diane@goodwin-family.zzz","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":"oliver@rios-family.zzz","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":"abd@sutton-family.zzz","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 st.@tran-family.zzz","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 al@baker-family.zzz","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 上查询

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

364

365

366

367

368

369

370

371

372

373

374

375

376

377

378

379

380

381

382

383

384

385

386

387

388

389

390

391

392

393

394

395

396

397

398

399

400

401

402

403

404

405

406

407

408

409

410

411

412

413

414

415

416

417

418

419

420

421

422

423

424

425

426

427

428

429

430

431

432

433

434

435

436

437

438

439

440

441

442

443

444

445

446

447

448

449

450

451

452

453

454

455

456

457

458

459

460

461

462

463

464

465

466

467

468

469

470

471

472

473

474

475

476

477

478

479

480

481

482

483

484

485

486

487

488

489

490

491

492

493

494

495

496

497

498

499

500

501

502

503

504

505

506

507

508

509

510

511

512

513

514

515

516

517

518

519

520

521

522

523

524

525

526

527

528

529

530

531

532

533

534

535

536

537

538

539

540

541

542

543

544

545

546

547

548

549

550

551

552

553

554

555

556

557

558

559

560

561

562

563

564

565

566

567

568

569

570

571

572

573

574

575

576

577

578

579

580

581

582

583

584

585

586

587

588

589

590

591

592

593

594

595

596

597

598

599

600

601

602

603

604

605

606

607

608

609

610

611

612

613

614

615

616

617

618

619

620

621

622

623

624

625

626

627

628

629

630

631

632

633

634

635

636

637

638

639

640

641

642

643

644

645

646

647

648

649

650

651

652

653

654

655

656

657

658

659

660

661

662

663

664

665

666

667

668

669

670

671

672

673

674

675

676

677

678

679

680

681

682

683

684

685

686

687

688

689

690

691

692

693

694

695

696

697

698

699

700

701

702

703

704

705

706

707

708

709

710

711

712

713

714

715

716

717

718

719

720

721

722

723

724

725

726

727

728

729

730

731

732

733

734

735

736

737

738

739

740

741

742

743

744

745

746

747

748

749

750

751

752

753

754

755

756

757

758

759

760

761

762

763

764

765

766

767

768

769

770

771

772

773

774

775

776

777

778

779

780

781

782

783

784

785

786

787

788

789

790

791

792

793

794

795

796

797

798

799

800

801

802

803

804

805

806

807

808

809

810

811

812

813

814

815

816

817

818

819

820

821

822

823

824

825

826

827

828

829

830

831

832

833

834

835

836

837

838

839

840

841

842

843

844

845

846

847

848

849

850

851

852

853

854

855

856

857

858

859

860

861

862

863

864

865

866

867

868

869

870

871

872

873

874

875

876

877

878

879

880

881

882

883

884

885

886

887

888

889

890

891

892

893

894

895

896

897

898

899

900

901

902

903

904

905

906

907

908

909

910

911

912

913

914

915

916

917

918

919

920

921

922

923

924

925

926

927

928

929

930

931

932

933

934

935

936

937

938

939

940

941

942

943

944

945

946

947

948

949

950

951

952

953

954

955

956

957

958

959

960

961

962

963

964

965

966

967

968

969

970

971

972

973

974

975

976

977

978

979

980

981

982

983

984

985

986

987

988

989

990

991

992

993

994

995

996

997

998

999

1000

1001

1002

1003

1004

1005

1006

1007

1008

1009

1010

1011

1012

1013

1014

1015

1016

1017

1018

1019

1020

1021

1022

1023

1024

1025

1026

1027

1028

1029

1030

1031

1032

1033

1034

1035

1036

1037

1038

1039

1040

1041

1042

1043

1044

1045

1046

1047

1048

1049

1050

1051

1052

1053

1054

1055

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" : "eddie@underwood-family.zzz",
          "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" : "mary@bailey-family.zzz",
          "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" : "gwen@butler-family.zzz",
          "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" : "diane@chandler-family.zzz",
          "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" : "eddie@weber-family.zzz",
          "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" : "diane@goodwin-family.zzz",
          "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" : "oliver@rios-family.zzz",
          "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" : "abd@sutton-family.zzz",
          "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 st.@tran-family.zzz",
          "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 al@baker-family.zzz",
          "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"
          }
        }
      }
    ]
  }
}