es添加索引命令行和浏览器添加索引--图文详解

以你之姓@ 2023-10-13 21:57 8阅读 0赞

一、添加索引

创建索引

curl -X PUT "localhost:9200/my-index-00001?pretty"

![297ed1a9983e4265b6f6a68efb97dc01.png][]

获取索引

curl -X GET "localhost:9200/my-index-000001?pretty"

获取全部的索引

curl -X GET "http://localhost:9200/_cat/indices?v"

获取索引映射

curl -X GET "localhost:9200/my-index-000001/_mapping?pretty"

删除索引

curl -X DELETE "localhost:9200/my-index-000001?pretty"

![3feba73d2d054dcfb2e529f81350eebf.png][]添加映射：

浏览器里执行

PUT /my-index-000001/_mapping
    {
      "properties": {
         "id": {
              "type": "text",
              "fields": {
                "keyword": {
                  "type": "keyword",
                  "ignore_above": 256
                }
              }
            }
      }
    }

![4dd13cfe667f47cf948bcd0e380f6aac.png][]命令行执行

curl -XPUT "http://localhost:9200/my-index-000001/_mapping" -H 'Content-Type: application/json' -d'{  "properties": {     "id": {          "type": "text",          "fields": {            "keyword": {              "type": "keyword",              "ignore_above": 256            }          }        }  }}'

![b3ca6ca9412b44a3bcb6ea4658ef728e.png][]

重启客户端（这里用的是canal客户端，同步的mysql数据库）

![f8051195b23541cea53cdfb8f380750c.png][]

导入数据

curl -X POST  http://127.0.0.1:8081/etl/es7/mytest_user.yml

这是我的安装目录：![14ddccb9398340c3aca31c3a0cad08a5.png][]

配置： /www/canal/adapter/conf/es7/mytest\_user.yml

dataSourceKey: defaultDS
    destination: example
    groupId: g1
    esMapping:
      _index: my-index-000001
      _id: _id
    #  upsert: true
    #  pk: id
      sql: "select a.id as _id,a.id from t_data_order202306 a"
    #  objFields:
    #    _labels: array:;
      etlCondition: "where a.id>={}"
      commitBatch: 3000

![89e87d3d11b24572b90ebe9c05db7c40.png][]

查询数据

浏览器查询：

GET /my-index-000001/_search
    {
      "query": {
        "match": {
          "id": "0000391d-7907-4491-907f-9ebe9d71ab3f"
        }
      }
    }

![c8cf3074c80843419c3d6dfb6c52eb1b.png][]

命令行查询：

curl -XGET "http://localhost:9200/my-index-000001/_search" -H 'Content-Type: application/json' -d'{  "query": {    "match": {      "id": "0000391d-7907-4491-907f-9ebe9d71ab3f"    }  }}'

![6d4c78f888cd4ca987458b136ddfdf34.png][]

[297ed1a9983e4265b6f6a68efb97dc01.png]: https://img-blog.csdnimg.cn/297ed1a9983e4265b6f6a68efb97dc01.png
[3feba73d2d054dcfb2e529f81350eebf.png]: https://img-blog.csdnimg.cn/3feba73d2d054dcfb2e529f81350eebf.png
[4dd13cfe667f47cf948bcd0e380f6aac.png]: https://img-blog.csdnimg.cn/4dd13cfe667f47cf948bcd0e380f6aac.png
[b3ca6ca9412b44a3bcb6ea4658ef728e.png]: https://img-blog.csdnimg.cn/b3ca6ca9412b44a3bcb6ea4658ef728e.png
[f8051195b23541cea53cdfb8f380750c.png]: https://img-blog.csdnimg.cn/f8051195b23541cea53cdfb8f380750c.png
[14ddccb9398340c3aca31c3a0cad08a5.png]: https://img-blog.csdnimg.cn/14ddccb9398340c3aca31c3a0cad08a5.png
[89e87d3d11b24572b90ebe9c05db7c40.png]: https://img-blog.csdnimg.cn/89e87d3d11b24572b90ebe9c05db7c40.png
[c8cf3074c80843419c3d6dfb6c52eb1b.png]: https://img-blog.csdnimg.cn/c8cf3074c80843419c3d6dfb6c52eb1b.png
[6d4c78f888cd4ca987458b136ddfdf34.png]: https://img-blog.csdnimg.cn/6d4c78f888cd4ca987458b136ddfdf34.png