ES建表

PUT http://121.46.197.112:9200/cty_test
Content-Type: application/json

{
  "settings": {
    "number_of_shards": 5,
    "number_of_replicas": 1,
    "analysis": {
      "analyzer": {
        "greek_lowercase_analyzer": {
          "filter": [
            "lowercase"
          ],
          "type": "custom",
          "tokenizer": "standard"
        }
      }
    }
  },
  "mappings": {
    "cty_test": {
      "properties": {
        "dupId": {
          "type": "text",
          "fields": {
            "keyword": {
              "ignore_above": 256,
              "type": "keyword"
            }
          }
        },
        "id": {
          "type": "text",
          "fields": {
            "keyword": {
              "ignore_above": 256,
              "type": "keyword"
            }
          }
        },
        "supplierId": {
          "type": "long"
        },
        "addTime": {
          "format": "yyyy-MM-dd HH:mm:ss",
          "type": "date"
        },
        "scCountry": {
          "type": "keyword"
        },
        "shipName": {
          "type": "text"
        },
        "manifestQuanityDouble": {
          "type": "float"
        },
        "importerName": {
          "analyzer": "greek_lowercase_analyzer",
          "type": "text",
          "fields": {
            "keyword": {
              "ignore_above": 256,
              "type": "keyword"
            }
          }
        },
        "tradeType": {
          "type": "integer"
        },
        "arriveDate": {
          "format": "yyyy-MM-dd",
          "type": "date"
        },
        "modeOfTransportation": {
          "type": "keyword"
        },
        "modeoftransPortation": {
          "type": "text",
          "fields": {
            "keyword": {
              "ignore_above": 256,
              "type": "keyword"
            }
          }
        },
        "weight": {
          "type": "double"
        }
      }
    }
  }
}

ES写入数据

POST http://121.46.197.112:9200/cty_test/cty_test
Content-Type: application/json

{
  "dupId": "34324",
  "id" : "545435",
  "supplierId" : 43636,
  "addTime" : "2021-02-05 08:08:08",
  "scCountry" : "rrr",
  "shipName" : "uuu",
  "manifestQuanityDouble" : 55.00,
  "importerName" : "ccd",
  "tradeType" : 43,
  "arriveDate" : "2018-09-03",
  "weight" : 33.0
}

查询某列不为空

POST looking_company_1/company/_search

{
  "query": {
    "bool": {
      "must": [
        {
          "exists": {
            "field": "youtube"
          }
        }
      ],
      "should": [
        {
          "match_all": {}
        }
      ]
    }
  },
  "from": 0,
  "size": 10,
  "sort": [],
  "aggs": {}
}

新建别名

POST http://elk-search.lcbint.cn:9200/_aliases
Content-Type: application/json

{
	 "actions": [
		{
			 "add": {
				 "index": "micro_indicator_event_mpviewscreen_pv",
				 "alias": "micro_indicator_activity_overview_view" 
			}
		},
		 {
			 "add": {
				 "index": "micro_indicator_order_payment_nums",
				 "alias": "micro_indicator_activity_overview_view" 
			}
		},
		 {
			 "add": {
				 "index": "micro_indicator_order_cancel_nums",
				 "alias": "micro_indicator_activity_overview_view" 
			}
		}
	]
}

清空表

POST http://121.46.197.112:9200/looking_company_20220318_test/company/_delete_by_query
Content-Type: application/json


{
  "query": {
    "match_all": {
    }
  }
}