mysql river 增量查询

mysql river 增量查询

	select id as _id,keyboard,title,ftitle,smalltext from ecms_news where lastdotime > UNIX_TIMESTAMP(now())-100
	
	curl -XPOST http://127.0.0.1:9200/groups/_mapping -d'
	{
		"groups": {
			"properties": {
				"status": {
					"type": "integer"
				},
				"name": {
					"type": "multi_field",
					"fields": {
						"name": {
							"type": "string",
							"store": "yes",
							"index": "analyzed",
							"indexAnalyzer": "ik",
							"searchAnalyzer": "ik"
						},
						"name_en": {
							"type": "string",
							"store": "yes",
							"index": "analyzed",
							"indexAnalyzer": "pinyin_analyzer",
							"searchAnalyzer": "pinyin_analyzer"
						}
					}
				},
				"desc": {
					"type": "string",
					"store": "yes",
					"index": "analyzed",
					"indexAnalyzer": "ik",
					"searchAnalyzer": "ik"
				}
			}
		}
	}'