创建索引put
http://192.168.77.32:9200/sc_supplier_cmmdty
{
"settings": {
"index": {
"number_of_shards": "3",
"number_of_replicas": "2"
}
}
}
创建索引映射put
http://192.168.77.32:9200/sc_supplier_cmmdty/_mapping/
{
"properties": {
"categoryCode2": {
"fielddata": true,
"type": "text",
"fields": {
"keyword": {
"type": "text",
"analyzer": "ik_smart",
"search_analyzer": "ik_smart"
}
}
},
"merchantCode": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword"
}
}
},
"categoryCode1": {
"fielddata": true,
"type": "text",
"fields": {
"keyword": {
"type": "text",
"analyzer": "ik_smart",
"search_analyzer": "ik_smart"
}
}
},
"cmmdtyCode": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword"
}
}
},
"cmmdtyName": {
"type": "text",
"fields": {
"keyword": {
"type": "text",
"analyzer": "ik_smart",
"search_analyzer": "ik_smart"
}
}
},
"shelvesFlag": {
"type": "long"
},
"supplierCode": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword"
}
}
},
"barcodes": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword"
}
}
},
"categoryCode3": {
"fielddata": true,
"type": "text",
"fields": {
"keyword": {
"type": "text",
"analyzer": "ik_smart",
"search_analyzer": "ik_smart"
}
}
},
"categoryName3": {
"type": "text",
"fields": {
"keyword": {
"type": "text",
"analyzer": "ik_smart",
"search_analyzer": "ik_smart"
}
}
},
"categoryName1": {
"type": "text",
"fields": {
"keyword": {
"type": "text",
"analyzer": "ik_smart",
"search_analyzer": "ik_smart"
}
}
},
"categoryName2": {
"type": "text",
"fields": {
"keyword": {
"type": "text",
"analyzer": "ik_smart",
"search_analyzer": "ik_smart"
}
}
},
"createTime": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss||yyyy-MM-dd||epoch_millis",
"fields": {
"keyword": {
"type": "keyword"
}
}
}
}
}
刷新索引GET
http://192.168.88.71:9200/my_sc_merchant_cmmdty/_refresh
查询 GET
http://192.168.88.44:9200/sc_store_cmmdty/_search
{
"size": 10000,
"query": {
"bool": {
"must": [{
"term": {
"merchantCode": {
"value": "000007",
"boost": 1.0
}
}
}, {
"term": {
"storeCode": {
"value": "00019",
"boost": 1.0
}
}
}, {
"term": {
"cmmdtyCode": {
"value": "pc756937933755252742",
"boost": 1.0
}
}
}]
}
}
}
清空索引数据POST
http://192.168.88.44:9200/sc_supplier_cmmdty/_delete_by_query
{
"query": {
"bool": {
"must": [{
"match_all": {}
}],
"must_not": [],
"should": []
}
}
}