ES项目查询示例
GET /standard/_search
{
"query":{
"bool":{
"filter":
{
"nested":{
"path":"FengPi",
"query":{
"bool":{
"must":[
{
"match":{
"FengPi.nameCN":"鞋"
}
}
]
}
}
}
}
}
},
"_source":"FengPi"
}
GET /standard/_search
{
"query": {
"nested": {
"path": "ZhengWen",
"query": {
"bool": {
"must_not": [
{
"match": {
"ZhengWen.公式.keyword": ""
}
}
]
}
}
}
},
"_source": "ZhengWen"
}
Get /standard/_doc/4
Get /standard/_search
get /standard/_mapping
put /standard/_mapping
{
"dynamic": "false",
"properties": {
"FengPi": {
"type": "nested",
"properties": {
"Safety": {
"type": "long"
},
"_custom_generated_pk": {
"type": "boolean"
},
"_partial": {
"type": "boolean"
},
"_saved_in_db": {
"type": "boolean"
},
"degreeOfConsistencyIdentification": {
"type": "text",
"analyzer": "ik_max_word",
"search_analyzer": "ik_max_word",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"equateid": {
"type": "text","analyzer": "ik_max_word",
"search_analyzer": "ik_max_word",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"fileCode": {
"type": "text",
"analyzer": "ik_max_word",
"search_analyzer": "ik_max_word",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"file_name": {
"type": "text",
"analyzer": "ik_max_word",
"search_analyzer": "ik_max_word",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"hasAQ": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"hasCCS": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"hasGBW_CCS": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"hasIS": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"hasNo": {
"type": "text",
"analyzer": "ik_max_word",
"search_analyzer": "ik_max_word",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"hasSN": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"implementationDate": {
"type": "date",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"index": {
"type": "long"
},
"levelsOrCategories": {
"type": "text",
"analyzer": "ik_max_word",
"search_analyzer": "ik_max_word",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"maintainerNO": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"nameCN": {
"type": "text",
"analyzer": "ik_max_word",
"search_analyzer": "ik_max_word",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"nameEN": {
"type": "text",
"analyzer": "ik_max_word",
"search_analyzer": "ik_max_word",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"path": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"releaseDate": {
"type": "date"
},
"releaseYear": {
"type": "long"
},
"replacedNO": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"standardCode": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"updated": {
"type": "date"
},
"发布机构": {
"type": "text",
"analyzer": "ik_max_word",
"search_analyzer": "ik_max_word",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"强制或推荐": {
"type": "text",
"analyzer": "ik_max_word",
"search_analyzer": "ik_max_word",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"有效性": {
"type": "text",
"analyzer": "ik_max_word",
"search_analyzer": "ik_max_word",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"适用专业": {
"type": "text",
"analyzer": "ik_max_word",
"search_analyzer": "ik_max_word",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"适用范围": {
"type": "text",
"analyzer": "ik_max_word",
"search_analyzer": "ik_max_word",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
}
}
},
"Index": {
"type": "long"
},
"Mulu": {
"type": "text"
},
"TiaoWen": {
"type": "nested",
"properties": {
"公式": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"列项退格": {
"type": "long"
},
"子集编号": {
"type": "long"
},
"富文本": {
"type": "text"
},
"强条": {
"type": "boolean"
},
"样式标签": {
"type": "text"
},
"父级编号": {
"type": "long"
},
"纯文本": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
},
"analyzer": "ik_max_word",
"search_analyzer": "ik_max_word"
},
"隐藏标记": {
"type": "boolean"
}
}
},
"Title": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
},
"analyzer": "ik_max_word",
"search_analyzer": "ik_max_word"
},
"ZhengWen": {
"type": "nested",
"properties": {
"公式": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"列项退格": {
"type": "long"
},
"子集编号": {
"type": "long"
},
"富文本": {
"type": "text"
},
"强条": {
"type": "boolean"
},
"显示条文": {
"type": "long"
},
"样式标签": {
"type": "text"
},
"父级编号": {
"type": "long"
},
"纯文本": {
"type": "text",
"analyzer": "ik_max_word",
"search_analyzer": "ik_max_word",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"隐藏标记": {
"type": "boolean"
}
}
}
}
}
# 更新Nested嵌套数据中的字段,如果是集合,取到集合字段,遍历集合,判断符合条件的项后,更改该项的字段
post /standard/_update/4
{
"script" : {
"source": """
ctx._source.FengPi=params.fengpi
""",
"lang": "painless",
"params": {
"fengpi": {
"_partial": false,
"_saved_in_db": true,
"_custom_generated_pk": false,
"发布机构": "国家安全生产监督管理总局",
"hasNo": "AQ/T 6108-2008",
"强制或推荐": "推荐性标准",
"updated": "2022-06-02",
"nameEN": "Selection , use,and maintenance of safety,protective and occupational footwear",
"path": "CCS/C/C73/AQ-T 6108-2008_安全鞋、防护鞋和职业鞋的选择、使用和维护.pdf",
"hasAQ": "25469-2009",
"nameCN": "安全鞋、防护鞋和职业鞋的选择、使用和维护",
"releaseDate": "2019-11-01",
"levelsOrCategories": "中华人民共和国安全生产行业标准",
"equateid": "",
"releaseYear": 2008,
"适用范围": "行业标准",
"implementationDate": "2001-01-01",
"hasSN": "6108",
"有效性": "现行",
"hasCCS": "C 73",
"hasGBW_CCS": "C73",
"maintainerNO": "GT0734",
"适用专业": "安全",
"file_name": "20221204070435_fca98b52-29d7-4ce2-9328-f568aa151d1aAQT 6108-2008 安全鞋、防护鞋和职业鞋的选择、使用和维护",
"standardCode": "AQ/T",
"replacedNO": "",
"hasIS": "ICS 13.340.50",
"fileCode": "AQ",
"Safety": 1,
"index": 4,
"degreeOfConsistencyIdentification": """(ISO/TR 18690:2006,Guidance for the selection,use,
and maintenance of safety, protective and occupational footwear,MOD)"""
}
}
}
}
get /standard/_search
{
"query":{
"bool": {
"must": [
{"match": {
"Index": 4
}}
]
}
},
"_source":["FengPi.fileCode"]
}
POST _analyze
{
"analyzer":"ik_max_word",
"text":"AQ/T 6108-2008 安全鞋、防护鞋和职业鞋的选择、使用和维护"
}
get /standard/_search
{
"query":{
"bool": {
"must": [
{
"match_phrase":{
"Title": "安全鞋"
}
},
{
"nested":{
"path":"FengPi",
"query":{
"bool":{
"must":[
{
"terms":{
"FengPi.有效性":["现行"]
}
}
,
{
"terms":{
"FengPi.适用专业":["安全"]
}
}
],
"filter": [
{
"range":{
"FengPi.implementationDate":{
"gte": "2000-12-11",
"lt": "2022-12-11"
}
}
}
]
}
}
}
}
]
}
},
"highlight": {
"pre_tags": [
"<span style='color:red'>"
],
"post_tags": [
"</span>"
],
"require_field_match": "false",
"fields": {
"*": {}
}
}
}
get /standardterm/_search
get /standardterm/_search
{
"query": {
"term": {
"standardterm.keyword": ""
}
}
}
PUT standardterm/_settings?preserve_existing=true
{
"index.max_result_window" : "10000000"
}
get /standard/_search
{
"query":{
"bool": {
"should": [
{"match":
{
"Title":"建筑结构荷载规范"
}
},
{
"nested":{
"path":"ZhengWen",
"query":{
"match": {
"ZhengWen.纯文本": "建筑结构荷载规范"
}
},
"inner_hits": {
"size": 1,
"_source": ["ZhengWen.纯文本"] // 嵌套文档中显示字段
}
}
},
{
"nested":{
"path":"TiaoWen",
"query":{
"match": {
"TiaoWen.纯文本": "建筑结构荷载规范"
}
},
"inner_hits": {
"size": 1,
"_source": ["TiaoWen.纯文本"] // 嵌套文档中显示字段
}
}
}
]
}
},
"_source":["xx"] // 控制原文档显示字段,xx匹配不到则都不显示
}
get /standard/_search
{
"query": {
"match": {
"Index": 4
}
},
"_source": [
"FengPi",
"ZhengWen"
]
}
get /standard/_search
{
"query":{
"bool": {
"must": [
{"match":
{
"Index":"0"
}
},
{
"nested":{
"path":"FengPi",
"query":{
"match": {
"FengPi.file_name.keyword": "202303095628_d2e8ac9a-5460-4e63-84f2-2cd216dee3c1JGJ 120-2012 建筑基坑支护技术规程(1)(1)"
}
}
}
}
]
}
},
"_source":["TiaoWen","ZhengWen","Mulu"] // 控制原文档显示字段,xx匹配不到则都不显示
}
get /standard/_search
{
"query":{
"bool": {
"must": [
{
"match":
{
"Index":"852"
}
}
]
}
},
"_source":["FengPi","TiaoWen","ZhengWen","Mulu"] // 控制原文档显示字段,xx匹配不到则都不显示
}
// 搜索title中包含建筑的, 且FengPi.file_name=""的数据
POST /standard/_search
{
"query": {
"bool": {
"must": [
{
"match": {
"Title": "建筑"
}
},
{
"nested": {
"path": "FengPi",
"query": {
"bool": {
"must_not": {
"match": {
"FengPi.file_name.keyword": ""
}
}
}
}
}
}
]
}
}
}
// 搜索title中包含建筑的, 且不包含ZhengWen的数据
POST /standard/_search
{
"query": {
"bool": {
"must": [
{
"match": {
"Title": "建筑"
}
},
{
"nested": {
"path": "ZhengWen",
"query": {
"bool": {
"must": {
"exists": {
"field": "ZhengWen"
}
}
}
}
}
}
]
}
}
}
本博客所有文章除特别声明外，均采用 CC BY-NC-SA 4.0 许可协议。转载请注明来自 流年 丶！
