Hi all, Admit we have lot of documents with _id (String) setted by ourself and a field with the same value of the _id as Long. I want to run a filtered query on a list of Long , so I have 2 options : Option 1: add a must IdsQuery with my list of ids converted as String Option 2: add a must Ter…

Hi, If you are using Elasticsearch 2.x, this should not make any difference since both data types are backed by the similar data structure, the inverted index. In ES 5.0 (which uses Lucene 6) this might have changed since Lucene 6 introduced the " dimensional points " feature to represent numeric val…

Filtered by IdsQuery vs by TermsQuery

Elastic Stack Elasticsearch

cbuescher (Christoph) November 18, 2016, 3:11pm 2

In a filter context they are both rewritten to a lucene TermsQuery, so it shouldn't make any difference.

Topic		Replies	Views
In case of Massive number of Filter items, which is faster? Filter by _id or Filter by a long field..? Elasticsearch	6	925	July 6, 2017
Which of these will be fastest way of querying my data Elasticsearch	1	378	July 6, 2017
Is it ok to make an idsQuery with lots (10k+) of ids on ES 5.x? Elasticsearch	2	738	March 6, 2017
Term filter: integer vs string? Elasticsearch	2	2678	July 6, 2017
Ids query is faster very much than ids filter ,why? Elasticsearch	5	1214	July 5, 2017

Filtered by IdsQuery vs by TermsQuery

Related topics