ElasticSearch常用DSL命令

1、查询索引字段的映射关系

GET /索引/_mapping

2、查询索引的分词器等设置

GET /索引/_settings

3、根据指定分词器分词

GET /索引/_analyze
{"analyzer" : "standard","text" : "层系"
}

4、term查询

POST /索引/_search
{"query": {"term": {"dbId": "101545"}}
}

5、match查询 

POST /tb/_search
{"query": {"match": {"dbId": "19841159f25845008fad2512aa91f48b"}}
}

 6、bool查询

        6.1 must组合

GET /tb/_search
{"query": {"bool": {"must": [{"terms": {"dbId": [287994]}},{"match": {"original": "层"}}]}}
}

must类似于mysql里面的and命令，上述命令相当于MySQL里面的 where dbId in(287994) and original like '%层%'。注意此处把match命令当成了mysql的like命令，其实这两个命令还是有明显区别的。

        6.2must与should组合

POST /tb/_search
{"query": {"bool": {"must": [{"term": {"dbId": {"value": "19841159f25845008fad2512aa91f48b"}}}],"should": [{"match": {"original": "边水"}}],"minimum_should_match": 1}}
}

上述命令类似于MySQL命令：where dbId = '19841159f25845008fad2512aa91f48b' and original like '%边水%'。如果上述命令不加上minimum_should_match: 1，则类似于MySQL命令：where dbId = '19841159f25845008fad2512aa91f48b'。

7、自定义脚本过滤

GET /tb/_search
{"query": {"bool": {"must": [{"terms": {"dbId": ["19841159f25845008fad2512aa91f48b"]}},{"match_phrase": {"original.standard": {"query": "层系"}}}],"filter": [{"script": {"script": {"lang": "painless","source": "String str = params.val;String strLower = params.valLower;String val = doc['original.keyword'].value;return str.contains(val) || strLower.contains(val.toLowerCase());","params": {"val": "侏罗层系主力区块年注采比变化","valLower": "侏罗层系主力区块年注采比变化"}}}}]}}
}