{"id":8740,"date":"2023-05-16T20:15:27","date_gmt":"2023-05-16T12:15:27","guid":{"rendered":"\/?p=8740"},"modified":"2023-05-16T20:15:27","modified_gmt":"2023-05-16T12:15:27","slug":"es-%e6%96%b0%e5%a2%9e%e5%ad%97%e6%ae%b5%e5%92%8c%e5%88%a0%e9%99%a4%e5%ad%97%e6%ae%b5","status":"publish","type":"post","link":"\/?p=8740","title":{"rendered":"ES \u65b0\u589e\u5b57\u6bb5\u548c\u5220\u9664\u5b57\u6bb5"},"content":{"rendered":"<h2>ES \u6307\u5b9a\u7d22\u5f15\u589e\u52a0\u5b57\u6bb5<\/h2>\n<h3>\u9996\u5148\u521b\u5efa\u4e00\u4e2a\u7d22\u5f15<\/h3>\n<pre><code class=\"language-python\">CopyPUT \/indexname  # indexname = zq_test\n\n{\n    &quot;mappings&quot;: {\n        &quot;properties&quot;: {\n            &quot;name&quot;: {\n                &quot;type&quot;: &quot;text&quot;,\n                &quot;fields&quot;: {\n                    &quot;keyword&quot;: {\n                        &quot;type&quot;: &quot;keyword&quot;,\n                        &quot;ignore_above&quot;: 256\n                    }\n                }\n            },\n            &quot;age&quot;: {\n                &quot;type&quot;: &quot;long&quot;,\n                &quot;index&quot;: true\n            },\n            &quot;gender&quot;: {\n                &quot;type&quot;: &quot;keyword&quot;\n            }\n        }\n    }\n}<\/code><\/pre>\n<h3>\u67e5\u770b\u521b\u5efa\u597d\u7684\u7d22\u5f15<\/h3>\n<pre><code class=\"language-python\">CopyGET \/zq_test\n\n{\n    &quot;zq_test&quot;: {\n        &quot;aliases&quot;: {},\n        &quot;mappings&quot;: {\n            &quot;properties&quot;: {\n                &quot;addr&quot;: {\n                    &quot;type&quot;: &quot;integer&quot;\n                },\n                &quot;age&quot;: {\n                    &quot;type&quot;: &quot;long&quot;\n                },\n                &quot;event_engine_count&quot;: {\n                    &quot;type&quot;: &quot;integer&quot;\n                },\n                &quot;gender&quot;: {\n                    &quot;type&quot;: &quot;keyword&quot;\n                },\n                &quot;name&quot;: {\n                    &quot;type&quot;: &quot;text&quot;,\n                    &quot;fields&quot;: {\n                        &quot;keyword&quot;: {\n                            &quot;type&quot;: &quot;keyword&quot;,\n                            &quot;ignore_above&quot;: 256\n                        }\n                    }\n                }\n            }\n        },\n        &quot;settings&quot;: {\n            &quot;index&quot;: {\n                &quot;creation_date&quot;: &quot;1623333220789&quot;,\n                &quot;number_of_shards&quot;: &quot;1&quot;,\n                &quot;number_of_replicas&quot;: &quot;1&quot;,\n                &quot;uuid&quot;: &quot;zWmXJeCSQsaI83JrJ3wJLA&quot;,\n                &quot;version&quot;: {\n                    &quot;created&quot;: &quot;7060099&quot;\n                },\n                &quot;provided_name&quot;: &quot;zq_test&quot;\n            }\n        }\n    }\n}<\/code><\/pre>\n<h3>\u589e\u52a0\u65b0\u7684\u5b57\u6bb5<\/h3>\n<pre><code class=\"language-python\">CopyPUT \/zq_test\/_mapping\n\n{\n    &quot;properties&quot;: {\n        &quot;hight&quot;: {\n            &quot;type&quot;: &quot;integer&quot;\n        }\n    }\n}<\/code><\/pre>\n<h3>\u518d\u6b21\u67e5\u770b\u7d22\u5f15<\/h3>\n<pre><code class=\"language-python\">CopyGET \/zq_test\n\n{\n    &quot;zq_test&quot;: {\n        &quot;aliases&quot;: {},\n        &quot;mappings&quot;: {\n            &quot;properties&quot;: {\n                &quot;addr&quot;: {\n                    &quot;type&quot;: &quot;integer&quot;\n                },\n                &quot;age&quot;: {\n                    &quot;type&quot;: &quot;long&quot;\n                },\n                &quot;event_engine_count&quot;: {\n                    &quot;type&quot;: &quot;integer&quot;\n                },\n                &quot;gender&quot;: {\n                    &quot;type&quot;: &quot;keyword&quot;\n                },\n                &quot;hight&quot;: {\n                    &quot;type&quot;: &quot;integer&quot;\n                },\n                &quot;name&quot;: {\n                    &quot;type&quot;: &quot;text&quot;,\n                    &quot;fields&quot;: {\n                        &quot;keyword&quot;: {\n                            &quot;type&quot;: &quot;keyword&quot;,\n                            &quot;ignore_above&quot;: 256\n                        }\n                    }\n                }\n            }\n        },\n        &quot;settings&quot;: {\n            &quot;index&quot;: {\n                &quot;creation_date&quot;: &quot;1623333220789&quot;,\n                &quot;number_of_shards&quot;: &quot;1&quot;,\n                &quot;number_of_replicas&quot;: &quot;1&quot;,\n                &quot;uuid&quot;: &quot;zWmXJeCSQsaI83JrJ3wJLA&quot;,\n                &quot;version&quot;: {\n                    &quot;created&quot;: &quot;7060099&quot;\n                },\n                &quot;provided_name&quot;: &quot;zq_test&quot;\n            }\n        }\n    }\n}<\/code><\/pre>\n<h3>\u5d4c\u5957\u8282\u70b9\u4e0b\u9762\u65b0\u589e\u5b57\u6bb5<\/h3>\n<pre><code class=\"language-python\">CopyPUT \/zq_test\/_mapping\n\n{\n    &quot;properties&quot;: {\n        &quot;school&quot;: {\n            &quot;type&quot;: &quot;keyword&quot;,\n            &quot;norms&quot;: false,\n            &quot;doc_values&quot;: false\n        },\n        &quot;teacher&quot;: {\n            &quot;type&quot;: &quot;nested&quot;,\n            &quot;properties&quot;: {\n                &quot;rightStatus&quot;: {\n                    &quot;type&quot;: &quot;keyword&quot;,\n                    &quot;norms&quot;: false,\n                    &quot;doc_values&quot;: false\n                },\n                &quot;rightCurrTime&quot;: {\n                    &quot;type&quot;: &quot;keyword&quot;,\n                    &quot;norms&quot;: false,\n                    &quot;doc_values&quot;: false\n                }\n            }\n        }\n    }\n}<\/code><\/pre>\n<h3>\u5bf9\u5e94\u65b0\u7684\u7d22\u5f15\u4fe1\u606f<\/h3>\n<pre><code class=\"language-python\">Copy\n{\n    &quot;zq_test&quot;: {\n        &quot;aliases&quot;: {},\n        &quot;mappings&quot;: {\n            &quot;properties&quot;: {\n                &quot;addr&quot;: {\n                    &quot;type&quot;: &quot;integer&quot;\n                },\n                &quot;age&quot;: {\n                    &quot;type&quot;: &quot;long&quot;\n                },\n                &quot;event_engine_count&quot;: {\n                    &quot;type&quot;: &quot;integer&quot;\n                },\n                &quot;gender&quot;: {\n                    &quot;type&quot;: &quot;keyword&quot;\n                },\n                &quot;hight&quot;: {\n                    &quot;type&quot;: &quot;integer&quot;\n                },\n                &quot;name&quot;: {\n                    &quot;type&quot;: &quot;text&quot;,\n                    &quot;fields&quot;: {\n                        &quot;keyword&quot;: {\n                            &quot;type&quot;: &quot;keyword&quot;,\n                            &quot;ignore_above&quot;: 256\n                        }\n                    }\n                },\n                &quot;school&quot;: {\n                    &quot;type&quot;: &quot;keyword&quot;,\n                    &quot;doc_values&quot;: false\n                },\n                &quot;teacher&quot;: {\n                    &quot;type&quot;: &quot;nested&quot;,\n                    &quot;properties&quot;: {\n                        &quot;rightCurrTime&quot;: {\n                            &quot;type&quot;: &quot;keyword&quot;,\n                            &quot;doc_values&quot;: false\n                        },\n                        &quot;rightStatus&quot;: {\n                            &quot;type&quot;: &quot;keyword&quot;,\n                            &quot;doc_values&quot;: false\n                        }\n                    }\n                }\n            }\n        },\n        &quot;settings&quot;: {\n            &quot;index&quot;: {\n                &quot;creation_date&quot;: &quot;1623333220789&quot;,\n                &quot;number_of_shards&quot;: &quot;1&quot;,\n                &quot;number_of_replicas&quot;: &quot;1&quot;,\n                &quot;uuid&quot;: &quot;zWmXJeCSQsaI83JrJ3wJLA&quot;,\n                &quot;version&quot;: {\n                    &quot;created&quot;: &quot;7060099&quot;\n                },\n                &quot;provided_name&quot;: &quot;zq_test&quot;\n            }\n        }\n    }\n}<\/code><\/pre>\n<h3>\u5bf9\u5e94 <code>python<\/code> \u65b9\u6cd5<\/h3>\n<pre><code class=\"language-python\">Copyfrom threading import BoundedSemaphore\nfrom elasticsearch import Elasticsearch\n\n# elasticsearch\u96c6\u7fa4\u670d\u52a1\u5668\u7684\u5730\u5740\n# \u521b\u5efaelasticsearch\u5ba2\u6237\u7aef\nes = Elasticsearch(\n    &quot;127.0.0.1:9200&quot;,\n    # # \u542f\u52a8\u524d\u55c5\u63a2es\u96c6\u7fa4\u670d\u52a1\u5668\n    # sniff_on_start=True,\n    # # es\u96c6\u7fa4\u670d\u52a1\u5668\u7ed3\u70b9\u8fde\u63a5\u5f02\u5e38\u65f6\u662f\u5426\u5237\u65b0es\u8282\u70b9\u4fe1\u606f\n    # sniff_on_connection_fail=True,\n    # # \u6bcf60\u79d2\u5237\u65b0\u8282\u70b9\u4fe1\u606f\n    # sniffer_timeout=60\n)\n\ndef add_field(index, body):\n    &quot;&quot;&quot;\u5c06\u73b0\u6709 index \u589e\u52a0\u4e00\u4e2a\u5b57\u6bb5\n\n    Args:\n        index (str): \u7d22\u5f15\u540d\u79f0\n        body (dict): \u67e5\u8be2\u4f53\u540c\u4e0a PUT \/zq_test\/_mapping\n    &quot;&quot;&quot;\n    return es.indices.put_mapping(index=index, body=body)<\/code><\/pre>\n<h2>ES \u5220\u9664\u5b57\u6bb5<\/h2>\n<p>ES \u5df2\u7ecf\u5efa\u7acb\u597d\u7684\u7d22\u5f15\u6570\u636e\uff0c\u65e0\u6cd5\u76f4\u63a5\u5220\u9664\u4e00\u4e2a\u5b57\u6bb5\u3002\u9664\u975e\u65b0\u5efa\u7d22\u5f15\u3002\u4f46\u662f\u6211\u4eec\u901a\u8fc7\u6587\u6863\u5220\u9664\u5b57\u6bb5\u3002\u901a\u8fc7\u811a\u672c\u66f4\u65b0\u7684\u65b9\u5f0f\uff0c\u5220\u9664\u8bbe\u8ba1\u6587\u6863\u4e2d\u7684\u5b57\u6bb5\u5185\u5bb9\uff0c\u8fbe\u5230\u8be5\u5b57\u6bb5\u6570\u636e\u4e3a <code>None<\/code> \u7684\u5f62\u5f0f<\/p>\n<h3>\u5220\u9664\u6307\u5b9a\u6587\u6863\u4e2d\u6240\u6709\u7684\u67d0\u4e00\u4e2a\u5b57\u6bb5\u6570\u636e<\/h3>\n<pre><code class=\"language-python\">Copybody = {\n        &quot;script&quot;: f&quot;ctx._source.remove(&#039;{field}&#039;)&quot;,\n        &quot;query&quot;: {\n            &quot;bool&quot;: {\n                &quot;must&quot;: [\n                    {\n                        &quot;exists&quot;: {\n                            &quot;field&quot;: field\n                        }\n                    }\n                ]\n            }\n        }\n    }\nes.update_by_query(index, body)<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>ES \u6307\u5b9a\u7d22\u5f15\u589e\u52a0\u5b57\u6bb5 \u9996\u5148\u521b\u5efa\u4e00\u4e2a\u7d22\u5f15 CopyPUT \/indexname # indexname = zq_test { &#038;quo   \u2026 &#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0},"categories":[95],"tags":[160],"_links":{"self":[{"href":"\/index.php?rest_route=\/wp\/v2\/posts\/8740"}],"collection":[{"href":"\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8740"}],"version-history":[{"count":1,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/8740\/revisions"}],"predecessor-version":[{"id":8741,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/8740\/revisions\/8741"}],"wp:attachment":[{"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8740"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8740"},{"taxonomy":"post_tag","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}