SQL语句示例
select * from table where t_id in (1,2,3,4)
对应es查询语句
GET /index/type/_search
{
"query": {
"terms": {
"t_id": [
1,2,3,4 ]
}
}
}
对应Java API
SearchRequestBuilder searchRequestBuilder =
client.prepareSearch(index).setTypes(type).setSearchType(SearchType.QUERY_THEN_FETCH);
...
searchRequestBuilder.setQuery(QueryBuilders.termsQuery("t_id", idList));// in语句
java API pom配置
<dependency>
<groupId>org.elasticsearch.client</groupId>
<artifactId>transport</artifactId>
<version>5.4.1</version>
</dependency>
<dependency>
<groupId>org.elasticsearch</groupId>
<artifactId>elasticsearch</artifactId>
<version>5.4.1</version>
</dependency>
jdk信息
java version "1.8.0_111"
Java(TM) SE Runtime Environment (build 1.8.0_111-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.111-b14, mixed mode)