//1.基本命令
//刪除索引
delete /test
/創(chuàng)建索引/
put /test
{
"settings":{
"number_of_shards":1,
"number_of_replicas":1
}
}
delete /employee
put /employee
{
"settings":{
"number_of_shards":1,
"number_of_replicas":1
}
}
/沒有則創(chuàng)建 有則修改/
put /employee/_doc/1
{
"name":"湯姆",
"age":30
}
/指定字段修改/
post /employee/_doc/6/_update
{
"doc":{
"age":"3"
}
}
/創(chuàng)建/
post /employee/_doc/6/_create/
{
"name":"兄長(zhǎng)",
"age":1
}
/獲取索引記錄/
get /employee/_doc/2
/刪除文檔/
delete /employee/_doc/2
/查詢?nèi)?/em>/
get /employee/_doc/_search
//使用結(jié)構(gòu)化的方式創(chuàng)建索引
put /employee
{
"settings":{
"number_of_shards":1,
"number_of_replicas":1
},
"mappings":{
"_doc":{
"properties":{
"name":{"type":"text"},
"age":{"type":"integer"}
}
}
}
}
}
//不帶條件查詢所有記錄
get /employee/_doc/_search
{
"query":{
"match_all":{}
}
}
//分頁(yè)查詢
get /employee/_doc/_search
{
"query":{
"match_all":{}
},
"from":0,
"size":30
}
//帶關(guān)鍵字查詢
get /employee/_doc/_search
{
"query":{
"match":{"name":"兄長(zhǎng)"}
}
}
//帶排序查詢
get /employee/_doc/_search
{
"query":{
"match":{"name":"兄長(zhǎng)"}
},
"sort":[
{"age":{"order":"desc"}}
]
}
//帶filter 不打分_source都是0.0
get /employee/_doc/_search
{
"query":{
"bool":{
"filter":[
{"term":{"age":30}}
]}
}
}
get /employee/_doc/_search
{
"query":{
"bool":{
"filter":[
{"match":{"name":"兄"}}
]}
}
}
//帶聚合
get /employee/_doc/_search
{
"query":{
"match":{"name":"兄"}
},
"sort":[
{"age":{"order":"desc"}}
],
"aggs":{
"group_by_age":{
"terms":{"field":"age"}
}
}
}
//2.高級(jí)查詢
//新建一個(gè)索引
put /movie/_doc/1
{
"name": "Eating an apple a day & keeps the doctor away"
}
get /movie/_doc/_search
{
"query":{
"match":{
"name":"eat"
}
}
}
//使用analyze api查看分詞狀態(tài)
get /movie/_analyze
{
"field":"name",
"text": "Eating an apple a day & keeps the doctor away"
}
delete /movie
//使用結(jié)構(gòu)化方式創(chuàng)建索引 英文分詞
put /movie
{
"settings":{
"number_of_shards":1,
"number_of_replicas":1
},
"mappings":{
"_doc":{
"properties":{
"name":{"type":"text","analyzer":"english"}
}
}
}
}
//3.類型
//text : 被分析索引的字符串類型
//keyword：不能被分析只能精確匹配的字符串類型
//date：日期類型厘熟，可以配合format一起使用
//數(shù)字類型：long蹭睡、integer傀蓉、short捐韩、double等
//boolean：true false
//array：["one","two"]
//object:json 嵌套
//ip類型
//geo_point:地理位置
//4.tmdb
put /movie
{
"settings":{
"number_of_shards":1,
"number_of_replicas":1
},
"mappings":{
"_doc":{
"properties":{
"title":{"type":"text","analyzer":"english"},
"tagline":{"type":"text","analyzer":"english"},
"release_date":{"type":"date","format":"8yyyy/MM/dd||yyyy/MM/d||yyyy/M/dd||yyyy/M/d"},
"popularity":{"type":"double"},
"overview":{"type":"text","analyzer":"english"},
"cast":{
"type":"object",
"properties":{
"character":{"type":"text", "analyzer":"standard"},
"name":{"type":"text", "analyzer":"standard"}
}
}
}
}
}
}
get /movie/_analyze
{
"field":"title",
"text":"basketball with cartoom aliens"
}
//搜索內(nèi)容 match
get /movie/_doc/_search
{
"query":{
"match":{"title":"steve zissou"}
}
}
//搜索內(nèi)容 term 不進(jìn)行分詞分析直接去索引查詢
get /movie/_doc/_search
{
"query":{
"term":{"title":"steve zissou"}
}
}
//分詞后的and和or的邏輯
get /movie/_doc/_search
{
"query":{
"match":{"title":"basketball with cartoom aliens"}
}
}
//改成and
get /movie/_search
{
"query":{
"match":{
"title":{
"query":"basketball love aliens",
"operator":"and"
}
}
}
}
//最小匹配項(xiàng)
get /movie/_search
{
"query":{
"match":{
"title":{
"query":"basketball love aliens",
"operator":"or",
"minimum_should_match": 2
}
}
}
}
//短語(yǔ)查詢 查詢不做分析分詞
get /movie/_search
{
"query":{
"match_phrase":{"title":"steve zissou"}
}
}
多字段查詢
get /movie/_search
{
"query":{
"multi_match":{
"query":"basketball with cartoom aliens",
"fields":["title", "overview"]
}
}
}
評(píng)分分析
get /movie/_search
{
"explain":true,
"query":{
"multi_match":{
"query":"basketball with cartoom aliens",
"fields":["title", "overview"],
"tie_breaker": 0.3
}
}
}
優(yōu)化多詞查詢
get /movie/_doc/_search
{
"query":{
"multi_match": {
"query":"basketball with cartoom aliens",
"fields":["title^10", "overview"],
"tie_breaker": 0.3
}
}
}
不同的multi_query其實(shí)是有不同的type
best_fields:默認(rèn)的得分方式，取最高的分?jǐn)?shù)作為對(duì)應(yīng)文檔的對(duì)應(yīng)分?jǐn)?shù)
most_fields:考慮絕大多數(shù)（所有的）文檔的字段得分相加箩艺，獲得我們想要的結(jié)果
cross_fields ：已分詞為單位計(jì)算總分 適用于詞導(dǎo)向的場(chǎng)景
get /movie/_doc/_search
{
"explain":true,
"query":{
"multi_match": {
"query":"steve zissou",
"fields":["title^10", "overview"],
"type": "best_fields"
}
}
}
get /movie/_doc/_search
{
"explain":true,
"query":{
"multi_match": {
"query":"steve zissou",
"fields":["title^10", "overview^0.3"],
"type": "most_fields"
}
}
}
get /movie/_doc/_search
{
"explain":true,
"query":{
"multi_match": {
"query":"basketball with cartoom aliens",
"fields":["title^10", "overview^0.3"],
"type": "cross_fields"
}
}
}
bool 查詢
must not 必須都是false
must 必須都是true
should 其中有一個(gè)為true即可 為true的越多則得分越高
get /movie/_doc/_search
{
"query":{
"bool":{
"should":[
{"match": {"title":"basketball with cartoom aliens"}},
{"match": {"overview":"basketball with cartoom aliens"}}
]
}
}
}
query string
方便的利用 and or not
get /movie/_doc/_search
{
"query":{
"query_string": {
"fields": ["title"],
"query": "steve OR jobs"
}
}
}
filter 過濾查詢
get /movie/_search
{
"query":{
"bool":{
"filter":{
"term":{"title":"steve"}
}
}
}
}
多條件過濾
get /movie/_search
{
"query":{
"bool":{
"filter":[
{"term":{"title":"steve"}},
{"term":{"cast.name":"gaspard"}},
{"range":{"release_date":{"lte":"2015/01/01"}}},
{"range":{"popularity":{"gte":"25"}}}
]
}
},
"sort":[
{"popularity":{"order":"desc"}}
]
}
帶match打分的filter
get /movie/_search
{
"query":{
"bool":{
"should":[
{"match":{"title":"life"}},
{"multi_match": {
"query":"basketball with cartoom aliens",
"fields":["title^10", "overview^0.3"],
"type": "cross_fields"
}
}
],
"filter":[
{"range":{"release_date":{"lte":"2020/01/01"}}},
{"range":{"popularity":{"gte":"0"}}}
]
}
}
}
自定義score計(jì)算
get /movie/_search
{
"explain":true,
"query":{
"function_score": {
"query": {
"multi_match": {
"query": "steve job",
"fields": ["title", "overview"],
"type":"most_fields"
}
},
"functions": [
{
"field_value_factor": {
"field": "popularity", //對(duì)應(yīng)要處理的字段
"modifier": "log2p",
"factor": 10
}
},
{
"field_value_factor": {
"field": "popularity", //對(duì)應(yīng)要處理的字段
"modifier": "log2p",
"factor": 5
}
}
],
"score_mode":"sum",
"boost_mode":"sum"
}
}
}
測(cè)試ik分詞器
get _analyze
{
"analyzer":"ik_smart",
"text":"中華人民共和國(guó)國(guó)歌"
}
最大化分詞
get _analyze
{
"analyzer":"ik_max_word",
"text":"中華人民共和國(guó)國(guó)歌"
}
get _analyze
{
"analyzer":"english",
"text":"basketball with cartoom aliens"
}
analyzer 指定的是構(gòu)建索引的時(shí)候的分詞
search_analyzer 指定的是搜索關(guān)鍵字時(shí)候的分詞
最佳實(shí)踐： 構(gòu)建索引的時(shí)候使用max_word窜醉，但是查詢的時(shí)候使用smartword
使用距離排序
get /shop/_search
{
"query":{
"match":{"name":"凱越"}
},
"_source":*,
"script_fields":{ //es 腳本
"distance": {
"script":{
"source": "haversin(lat,lon,doc['location'].lat,doc['location'].lon)",
"lang":"expression",
"params":{"lat":23.11,"lon":127.12}
}
}
},
"sort":[
{
"_geo_distance": { //距離計(jì)算排序
"location": {
"lat":23.11,
"lon":127.12
},
"order":"asc",
"unit":"km",
"distance_type":"arc"
}
}
]
}
使用function_score解決排序模板
get /shop/_search
{
"_source":*,
"script_fields":{ //es 腳本
"distance": {
"script":{
"source": "haversin(lat,lon,doc['location'].lat,doc['location'].lon)",
"lang":"expression",
"params":{"lat":23.11,"lon":127.12}
}
}
},
"query":{
"function_score": {
"query": {
"bool":{
"must": [
{ "match":{"name":"凱越"}},
{"term":{"seller_disabled_flag":0}}
]
}
},
"functions": [
{
"gauss":{
"location":{
"origin":"23.11,127.12",
"offset":"0km",
"scale":"100km",
"decay":0.5
}
},
"weight": 9
},
{
"field_value_factor": {
"field": "remark_score"
},
"weight": 0.2,
},
{
"field_value_factor": {
"field": "seller_remark_score"
},
"weight": 0.1
},
{
"filter": {
"term": { "name": "*" }
},
"weight": 1
}
]
}
}
}
//創(chuàng)建
put /employee2
{
"settings":{
"number_of_shards":1,
"number_of_replicas":1
},
"mappings":{
"_doc":{
"properties":{
"name":{"type":"text"},
"age":{"type":"integer"}
}
}
}
}
}
//添加字段
put /employee2/_mapping/_doc
{
"properties": {
"auditStatus": {
"type": "integer"
}
}
}
//查詢
{"_source":"*",
"script_fields":{
"distance":{
"script":{
"source": "haversin(lat,lon,doc['location'].lat,doc['location'].lon)",
"lang": "expression",
"params":{"lat":39.995125, "lon":116.474152}
}
}
},
"query": {
"function_score": {
"query":{
"bool":{
"should":[
{"match_all":{}}
],
"filter":[{"terms":{"status":[3]}},{"range":{"editTime":{"lte":"2021-12-01 09:33:53"}}}],
"minimum_should_match":1
}
},
"functions":[{"gauss":{"location":{"offset":"0km","origin":"39.995125,116.474152","scale":"500km","decay":0.5}},"weight":0},{"field_value_factor":{"field":"id","modifier":"log2p","factor":2},"weight":0},{"field_value_factor":{"field":"praiseNum","modifier":"log2p","factor":2},"weight":0},{"field_value_factor":{"field":"commentNum","modifier":"log2p","factor":2},"weight":0},{"field_value_factor":{"field":"rewardNum","modifier":"log2p","factor":2},"weight":0},{"field_value_factor":{"field":"reward","modifier":"log2p","factor":2},"weight":0},{"filter":{"match":{"categoryName":"情感"}},"weight":0},{"filter":{"term":{"topStatus":1}},"weight":50000000}],
"score_mode": "sum",
"boost_mode": "sum"
}
},
"sort": [
{
"_score":{
"order": "desc"
},
"updateTimestamp" :{
"order": "desc"
} }
],
"from":0,"size": 10}
