es的基本操作

字段操作

添加索引字段

PUT indexName/_mapping
{
  "properties": {
        "drugPerUseDose": {
            "type": "keyword"
        }
  }
}

es数据操作

es数据添加操作

POST indexName/_doc/1420933754859421648
{
          "address" : "竹园组",
          "adverseReactions" : "无",
          "id":1420933754859421648,
          "adverseReactionsState" : null
}

如果id在es中存在，则进行跟新操作

更新操作

单条语句修改

POST indexName/_doc/1419605086354669568/_update
{
    "doc" : {
        "followDate" : "2021-05-05"
    }
}

查询修改

#根据查询条件修改
POST indexName/_update_by_query
{
  "query": {
    "range": {
      "flag": {
        "lt": 1
      }
    }
  },
  "script": {
    "source": "ctx._source['flag']=1"
  }
}

修改整个索引字段值

POST indexName/_doc/_update_by
{
  "doc": {
    "diagResultCode": "inDiagName"
  }
}

删除操作

POST indexName/_delete_by_query
{
  "query": {
    "exists": {
       "field": "createTime"
    }
  }
}

查询操作

范围查询

GET indexName/_search
{
  "size": 50, 
  "_source": ["village","idNo","followUpClassification"], 
  "query": {
    "range" : {
          "followDate" : {
            "from" : "2021-01-01",
            "to" : "2021-07-20",
            "include_lower" : true,
            "include_upper" : true,
            "format" : "yyyy-MM-dd",
            "boost" : 1.0
          }
        }
  }
}

• size：查询展示的条数
• _sourre：需要展示的字段

查询字段存在值

GET indexName/_search
{
  "query": {
    "exists": {
      "field": "createTime"
    }
  }
}

分词查询

GET /indexName/_search
{
 "query": {
   "match": {
     "township": "大兴街道办事处"
   }
 } 
}

精确查询

GET indexName/_search
{
  "query": {
    "term": {
      "orgName": {
        "value": "131321313"
      }
    }
  }
}

数据库方式查询

POST /_sql?format=txt
{
  "query": """
  SELECT ageYear FROM "clinc_outpatient_summary"
  """
}

多条件查询

GET /lab_exam_report/_search
{
  "sort": [
    {
      "scheduleDate": {
        "order": "desc"
      }
    }
  ],
  "query": {
    "bool": {
      "must": [
        {
          "range": {
            "reportCreateDtime": {
              "format": "yyyy-MM-dd", 
              "gte": "2021-03-22",
              "lte": "2021-03-25"
            }
          }
        },
        {
          "match": {
            "FIELD": "TEXT"
          }
        }
      ]
    }
  }
}

sort ： 排序操作

分组聚合操作

GET indexName/_search
{
  "size": 0, 
  "_source": "bedUseRealCount", 
  "query": {
    "range": {
      "statsDate": {
        "format": "yyyy",
        "to": "2022",
        "from": "2015"
      }
    }
  },
  "aggs": {
    "dateGroup": {
      "date_histogram": {
        "field": "statsDate",
        "calendar_interval": "year",
        "format": "yyyy"
      },
      "aggs": {
        "sumBed": {
          "sum": {
            "field": "bedUseRealCount"
          }
        }
      }
    }
  }
}