kinaba中操作es语法

1. 删除es中索引数据

POST /mblog_info/_delete_by_query
{
  "query": {
    "match_all": {}
  }
}

2.查询es中索引的数据

GET _search
{
  "query": {
    "match": {
      "_index":"short_video_info"
    }
  }
}

3.查询所有索引

GET _cat/indices

4、多条件查询

GET /appdata_info/_search
{
  "query": {
    "bool": {
      "must": [
        { "match": { "account": "广西云" }},
        { "match": { "pubdate": "2022-12-28" } }  
      ]
    }
  }
}

5、添加字段

PUT /appdata_info/appdata_info/_mapping
{
    "properties": {
      "collect_count" : {
            "type" : "integer",
            "store" : true
          }
    }
}

PUT /wechat_info/_doc/_mapping?include_type_name=true 
{
   "properties": {
      "zaikan_count" : {
      "type" : "integer"
    }
  }
}
 

6、别名

1、添加别名

POST _aliases
{
  "actions": [
    {
      "add": {
        "index": "testindex-old",
        "alias": "testindex-new"
      }
    }
  ]
}

2、删除别名

POST /_aliases
{
  "actions": [
    {
      "remove": {
        "index": "appdata_info_2023_05",
        "alias": "appdata_info"
      }
    }
  ]
}

7、对时间过滤

GET /art_info/_search
{
  "query": {
    "bool": {
      "must": [
        { "match": { "account": "2981511859544399" }},
        { "match": { "channel_type": "7" } }  
      ], 
      
         "filter": {
                "range": {
                    "insert_time": {
                        "gte":"2023-04-25 00:00:00", 
                        "time_zone":"+08:00",
                        "format":"yyyy-MM-dd HH:mm:ss"
                    }
                }
         }
    }
  }
}

8、新建mapping

PUT /appdata
{
  "mappings": {
    "dynamic": "false",
    "properties": {
      "account": {
        "type": "keyword",
        "store": true
      },
      "uuid": {
        "type": "keyword",
        "store": true
      },
      "title": {
        "type": "text",
        "store": true
      },
      "polarity": {
        "type": "integer",
        "store": true
      },
      "entity_address": {
        "type": "keyword",
        "store": true
      },
      "entity_people": {
        "type": "keyword",
        "store": true
      },
      "entity_org": {
        "type": "keyword",
        "store": true
      },
      "videos_array": {
        "type": "keyword",
        "store": true
      },
      "pictures": {
        "type": "text",
        "store": true
      },

      "insert_time": {
        "type": "date",
        "store": true,
        "format": "yyyy-MM-dd HH:mm:ss"
      },
      "es_updatetime": {
        "type": "date",
        "store": true,
        "format": "yyyy-MM-dd HH:mm:ss"
      },
      "pubdate": {
        "type": "date",
        "store": true,
        "format": "yyyy-MM-dd"
      },
      "pubtime": {
        "type": "date",
        "store": true,
        "format": "yyyy-MM-dd HH:mm:ss"
      },
      "source_url": {
        "type": "keyword",
        "store": true
      },
      "country_longitude_latitude": {
        "type": "geo_point",
        "store": true
      },
      "city_longitude_latitude": {
        "type": "geo_point",
        "store": true
      }
    }
  }
}

或是

POST appdata/appdata/_mapping
{
  "appdata": {
    "dynamic": "false",
        "properties" : {
          "account" : {
            "type" : "keyword",
            "store" : true
          },
          "art_id" : {
            "type" : "keyword",
            "store" : true
          },
          "article_type" : {
            "type" : "integer",
            "store" : true
          },
          "channel_type" : {
            "type" : "integer",
            "store" : true
          },
          "city" : {
            "type" : "keyword",
            "store" : true
          },
          "cluster_head_uuid" : {
            "type" : "keyword",
            "store" : true
          },
          "cmt_count" : {
            "type" : "integer",
            "store" : true
          },
          "content" : {
            "type" : "text",
            "store" : true
          },
          "county" : {
            "type" : "keyword",
            "store" : true
          },

          "insert_time" : {
            "type" : "date",
            "store" : true,
            "format" : "yyyy-MM-dd HH:mm:ss"
          },
          "inter_count" : {
            "type" : "integer",
            "store" : true
          },
          "is_revoke" : {
            "type" : "integer",
            "store" : true
          },
          "is_sensitive" : {
            "type" : "integer",
            "store" : true
          },
          "media_level" : {
            "type" : "integer",
            "store" : true
          },
          "media_level_name" : {
            "type" : "keyword",
            "store" : true
          },
          "new_trans_count" : {
            "type" : "integer",
            "store" : true
          },
          "new_trans_media_count" : {
            "type" : "integer",
            "store" : true
          },
          "pictures" : {
            "type" : "text",
            "store" : true
          },
          "pid" : {
            "type" : "keyword",
            "store" : true
          },
          "polarity" : {
            "type" : "integer",
            "store" : true
          },
          "province" : {
            "type" : "keyword",
            "store" : true
          },
          "pubdate" : {
            "type" : "date",
            "store" : true,
            "format" : "yyyy-MM-dd"
          },
          "pubtime" : {
            "type" : "date",
            "store" : true,
            "format" : "yyyy-MM-dd HH:mm:ss"
          },
          "read_count" : {
            "type" : "integer",
            "store" : true
          },
          "revoke_time" : {
            "type" : "date",
            "store" : true,
            "format" : "yyyy-MM-dd HH:mm:ss"
          },
          "rtt_count" : {
            "type" : "integer",
            "store" : true
          },
          "source_account" : {
            "type" : "keyword",
            "store" : true
          },
          "source_art_id" : {
            "type" : "keyword",
            "store" : true
          },
          "source_channel_type" : {
            "type" : "integer",
            "store" : true
          },
          "source_pubdate" : {
            "type" : "date",
            "store" : true,
            "format" : "yyyy-MM-dd"
          },
          "source_pubtime" : {
            "type" : "date",
            "store" : true,
            "format" : "yyyy-MM-dd HH:mm:ss"
          },
          "source_title" : {
            "type" : "keyword",
            "store" : true
          },
          "title" : {
            "type" : "keyword",
            "store" : true
          },
          "trans_count" : {
            "type" : "integer",
            "store" : true
          },
          "trans_user_name" : {
            "type" : "keyword",
            "store" : true
          },
          "up_count" : {
            "type" : "integer",
            "store" : true
          },
          "update_time" : {
            "type" : "date",
            "store" : true,
            "format" : "yyyy-MM-dd HH:mm:ss"
          },
          "url" : {
            "type" : "keyword",
            "store" : true
          },
          "uuid" : {
            "type" : "keyword",
            "store" : true
          }
        }
  }
}

9、新建索引

PUT appdata_info?pretty
{}

10 、修改文档中的字段数值

POST baidu_info/baidu_info/6d468b6380ff20937fc3233b01de696b/_update
{
    "doc":{
        "up_count":20,
        "read_count" : 300

    }
}