类似于这样的求交集
select user_id from myindex where date >="2018-01-01 00:00:00" and date < "2018-01-01 00:01:00" and user_id in(select user_id from myindex where date >="2018-01-01 00:01:00" and date < "2018-01-01 00:02:00")
用elasticsearch 该怎么写呢
select user_id from myindex where date >="2018-01-01 00:00:00" and date < "2018-01-01 00:01:00" and user_id in(select user_id from myindex where date >="2018-01-01 00:01:00" and date < "2018-01-01 00:02:00")
用elasticsearch 该怎么写呢
2 个回复
shiyuan
赞同来自:
lengchanguo - 得一爸
赞同来自:
"type": "search_phase_execution_exception",
"reason": "all shards failed",
"phase": "query",
"grouped": true,
"failed_shards": [
{
"shard": 0,
"index": "lbs_20190410",
"node": "Uj-ZStATT9y66mIBIHbpKA",
"reason": {
"type": "i_o_exception",
"reason": "can not write type [class java.util.HashSet]"
}
}
]
您遇到过吗?
文档上写只支持primitive types,String,Map,Array四种类型,不是这样吗