酒店api

  1. GET /hotel_price/_search
  2. {
  3.   "query": {
  4.     "match_all": {
  5.     }
  6.   }
  7.     ,
  8.     "from":1,
  9.     "size":10
  11. }
  13. GET _cat/indices?v
  15. GET /hotel_price/_mget
  16. {
  17.   "ids":["2_6073_2021-05-24","2_6086_2021-08-05"]
  18. }
  20.  # 获取mapping关系
  21. GET /hotel_price/_mapping
  24. GET /hotel_price/_search/
  25. {
  26.   "query": {
  27.     "bool": {
  28.       "must": [
  29.         {
  30.           "query_string": {
  31.             "default_field": "hotel_name",
  32.             "query": "如家"
  33.           }
  34.         }
  35.       ],
  36.       "filter": {
  37.         "range": {
  38.           "@timestamp": {
  39.             "gte": "now-30d/d",
  40.             "lte": "now/d"
  41.           }
  42.         }
  43.       }
  44.     }
  45.   },
  46.   "size": 20
  47. }
  50. GET /hotel_price/_search
  51. {
  52.    "query": {
  53.     "bool": {
  54.       "must": [
  55.         {
  56.           "match": {
  57.             "hotel_name": "汉庭"
  58.           }
  59.         }
  60.       ],
  61.       "filter": {
  62.         "range": {
  63.           "@timestamp": {
  64.             "gte": "now-30d/d",
  65.             "lte": "now/d"
  66.           }
  67.         }
  68.       }
  69.     }
  70.   },
  71.   "size": 10,
  72.   "sort": [
  73.     {
  74.       "_id": {
  75.         "order": "desc"
  76.       }
  77.     }
  78.   ],
  79.   "highlight": {
  80.     "fields": {
  81.       "hotel_name":{
  82.         "pre_tags": ["<emm>"],
  83.         "post_tags": ["</emm>"]
  84.       }
  85.     }
  86.   }
  88. }
  91. ### 更新图片 旧值更新为新值
  92. POST hotel_price_2021.08.05/_update_by_query
  93. {
  94.   "script": {
  95.     "source": "ctx._source['coverimage_href']='https://pavo.elongstatic.com/i/Hotel870_470/nw_WANm5wXZHq.jpg';ctx._source['coverimage_href']='http://pavo.elongstatic.com/i/API350_350/42cbd6ae3e1524071e82d3ccc22a9a39.jpg'" 
  96.   },
  97.   "query": {
  98.     "bool": {
  99.       "must": [
  100.         {
  101.           "term": {
  102.             "mapping_id": {
  103.               "value": "1839"
  104.             } 
  105.           }
  106.         }, {
  107.           "term": {
  108.             "prov_code": {
  109.               "value": "1"
  110.             }
  111.           }
  112.         }
  113.       ] 
  114.     }
  115.   }
  116. }
  118. get _template/hotel_price_template
  120. get hotel_price_2021.08.05/_count
  121. {
  122.   "query":{
  123.     "match_all" : {}
  124.   }
  125. }
  127. POST hotel_price_2021.04.14/_update_by_query
  128. {
  129.   "script": {
  130.     "source": "ctx._source['agreement']='[{\"CompanyId\":\"1fbce0d1-d25a-cbd7-1929-08d763a92d4e\",\"AgreementCode\":\"slys_xy\"}]';ctx._source['has_agreement']='1'" 
  131.   },
  132.   "query":{
  133.   "bool" : {
  134.     "must" : [
  135.       {
  136.         "term" : {
  137.           "prov_code" : {
  138.             "value" : "2"
  139.           }
  140.         }
  141.       }
  142.     ],
  143.     "filter" : [
  144.       {
  145.         "term" : {
  146.           "hotel_id" : {
  147.             "value" : "859"
  148.           }
  149.         }        
  150.       }
  151.     ]}
  152.   }  
  153. }
  155. POST hotel_price_2021.04.14/_update_by_query
  156. {
  157.   "script": {
  158.     "source": "ctx._source['agreement']='[]';ctx._source['has_agreement']='1'" 
  159.   },
  160.   "query":{
  161.     "match": {
  162.       "hotel_id":"859"
  163.     }
  164.   } 
  165. }
  167. get hotel_price/_search
  168. {
  169.   "query":{
  170.   "bool" : {
  171.     "must" : [
  172.       {
  173.         "term" : {
  174.           "prov_code" : {
  175.             "value" : "1"
  176.           }
  177.         }
  178.       }
  179.     ],
  180.     "filter" : [
  181.       {
  182.         "term" : {
  183.           "hotel_id" : {
  184.             "value" : "19188"
  185.           }
  186.         }        
  187.       }
  188.     ]}
  189.   },
  190.   "collapse": {
  191.     "field": "hotel_id"
  192.   }
  193. }
  195. get _cat/count?v&pretty
  197. #delete hotel_price_2021.05.08
  199. get hotel_price_2021.06.15/_search
  200. {
  201.   "query":{
  202.     "match": {
  203.       "hotel_name":"重庆格林"
  204.     }
  205.   }
  206. }
  208. get hotel_price_2021.08.05/_search
  209. {
  210.   "query":{
  211.     "match": {
  212.       "hotel_name":"君庭"
  213.     }
  214.   }
  215. }
  217. get hotel_price_2021.08.05/_count
  218. {
  219.   "query":{
  220.     "match_all" : {}
  221.   }
  222. }
  225. get hotel_price/_search
  226. {
  227.   "query":{
  228.     "match": {
  229.       "hotel_id":"6583"
  230.     }
  231.   }
  232. }
  234. get hotel_price/_search
  235. {
  236.   "query":{
  237.     "match": {
  238.       "hotel_id":"6583"
  239.     }
  240.   }
  241. }
  243. POST /_aliases
  244. {
  245.     "actions" : [
  246.         { "remove" : { "index" : "hotel_price_2021.06.15", "alias" : "hotel_price" } }
  247.         { "add" : { "index" : "hotel_price_2021.08.05", "alias" : "hotel_price" } }
  248.     ]
  249. }
  253. GET hotel_price/_search
  254. {
  255.   "query": {
  256.     "bool": {
  257.       "must": [
  258.         {
  259.           "term": {
  260.             "city_id": {
  261.               "value": "34",
  262.               "boost": 1
  263.             }
  264.           }
  265.         }
  266.       ],
  267.       "filter": [
  268.         {
  269.           "match_phrase": {
  270.               "hotel_name": {
  271.                 "query": "君亭",
  272.                 "slop": 4,
  273.                 "zero_terms_query": "NONE",
  274.                 "boost": 1
  275.               }
  276.             }
  277.         },
  278.         {
  279.           "range": {
  280.             "price": {
  281.               "from": "0",
  282.               "to": "99999",
  283.               "include_lower": true,
  284.               "include_upper": true,
  285.               "boost": 1
  286.             }
  287.           }
  288.         },
  289.         {
  290.           "range": {
  291.             "biz_date": {
  292.               "from": "2021-08-09",
  293.               "to": "2021-08-11",
  294.               "include_lower": true,
  295.               "include_upper": true,
  296.               "boost": 1
  297.             }
  298.           }
  299.         },
  300.         {
  301.           "bool": {
  302.             "should": [
  303.               {
  304.                 "term": {
  305.                   "star_rate": {
  306.                     "value": "0",
  307.                     "boost": 1
  308.                   }
  309.                 }
  310.               },
  311.               {
  312.                 "term": {
  313.                   "star_rate": {
  314.                     "value": "1",
  315.                     "boost": 1
  316.                   }
  317.                 }
  318.               },
  319.               {
  320.                 "term": {
  321.                   "star_rate": {
  322.                     "value": "2",
  323.                     "boost": 1
  324.                   }
  325.                 }
  326.               },
  327.               {
  328.                 "term": {
  329.                   "star_rate": {
  330.                     "value": "3",
  331.                     "boost": 1
  332.                   }
  333.                 }
  334.               },
  335.               {
  336.                 "term": {
  337.                   "star_rate": {
  338.                     "value": "4",
  339.                     "boost": 1
  340.                   }
  341.                 }
  342.               },
  343.               {
  344.                 "term": {
  345.                   "star_rate": {
  346.                     "value": "5",
  347.                     "boost": 1
  348.                   }
  349.                 }
  350.               }
  351.             ],
  352.             "adjust_pure_negative": true,
  353.             "boost": 1
  354.           }
  355.         },
  356.         {
  357.           "bool": {
  358.             "adjust_pure_negative": true,
  359.             "boost": 1
  360.           }
  361.         }
  362.       ],
  363.       "adjust_pure_negative": true,
  364.       "boost": 1
  365.     }
  366.   }
  367. }

电商搜索

  1. GET /goods/_search
  2. {
  3.   "query": {
  4.     "bool": {
  5.       "must": [
  6.         {
  7.           "match": {
  8.             "title": {
  9.               "query": "手机",
  10.               "operator": "and"
  11.             }
  12.           }
  13.         }
  14.       ],
  15.       "filter": [
  16.         {
  17.           "nested": {
  18.             "path": "attrs",
  19.             "query": {
  20.               "bool": {
  21.                 "must": [
  22.                   {
  23.                     "term": {
  24.                       "attrs.attrId": {
  25.                         "value": "9"
  26.                       }
  27.                     }
  28.                   },
  29.                   {
  30.                     "terms": {
  31.                       "attrs.attrValue": ["5","6","7"]
  32.                     }
  33.                   }
  34.                 ]
  35.               }
  36.             }
  37.           }
  38.         },
  39.         {
  40.           "nested": {
  41.             "path": "attrs",
  42.             "query": {
  43.               "bool": {
  44.                 "must": [
  45.                   {
  46.                     "term": {
  47.                       "attrs.attrId": {
  48.                         "value": "4"
  49.                       }
  50.                     }
  51.                   },
  52.                   {
  53.                     "terms": {
  54.                       "attrs.attrValue": ["8G", "12G"]
  55.                     }
  56.                   }
  57.                 ]
  58.               }
  59.             }
  60.           }
  61.         },
  62.         {
  63.           "terms": {
  64.             "brandId": [1,2,3]
  65.           }
  66.         },
  67.         {
  68.           "terms": {
  69.             "categoryId": [225]
  70.           }
  71.         },
  72.         {
  73.           "range": {
  74.             "price": {
  75.               "gte": 0,
  76.               "lte": 10000
  77.             }
  78.           }
  79.         }
  80.       ]
  81.     }
  82.   },
  83.   "from": 0,
  84.   "size": 10,
  85.   "highlight": {
  86.     "fields": {
  87.       "name": {}
  88.     },
  89.     "pre_tags": "<b style='color:red'>",
  90.     "post_tags": "</b>"
  91.   },
  92.   "sort": [
  93.     {
  94.       "price": {
  95.         "order": "desc"
  96.       }
  97.     }
  98.   ],
  99.   "aggs": {
  101.     "brandIdAgg": {
  102.       "terms": {
  103.         "field": "brandId"
  104.       },
  105.       "aggs": {
  106.         "brandNameAgg": {
  107.           "terms": {
  108.             "field": "brandName"
  109.           }
  110.         }
  111.       }
  112.     },
  113.     "categoryIdAgg": {
  114.       "terms": {
  115.         "field": "categoryId"
  116.       },
  117.       "aggs": {
  118.         "categoryNameAgg": {
  119.           "terms": {
  120.             "field": "categoryName"
  121.           }
  122.         }
  123.       }
  124.     }
  125.   }
  126. }