Range query not giving right result for lte

soumyas · June 9, 2021, 3:20pm

The result includes 23/03 in the result and miss to show 17/04. Where in data is present in the system. Any help is appreciated.

    "range" : {
      "timestamp" : {
        "from" : "2021-03-23",
        "to" : "2021-04-17",
        "include_lower":true,
        "include_upper":true,
        "boost":1.0
      }
    }

dadoonet · June 9, 2021, 4:02pm

I think that 2021-04-17 is actually parsed as 2021-04-17T00:00:00.
When you include it, it does not mean that any second after 00:00:00 will be matching.

You should either do:

    "range" : {
      "timestamp" : {
        "from" : "2021-03-23",
        "to" : "2021-04-17T23:59:59.999",
        "include_lower":true,
        "include_upper":true,
        "boost":1.0
      }
    }

But I definitely prefer:

    "range" : {
      "timestamp" : {
        "from" : "2021-03-23",
        "to" : "2021-04-18"
      }
    }

soumyas · June 10, 2021, 8:17am

Can you suggest how do we implement in Java using QueryBuilders.rangeQuery.

soumyas · June 10, 2021, 8:18am

Thanks @dadoonet
I will try with the suggested change.

dadoonet · June 10, 2021, 8:45am

Here is one:

github.com

dadoonet/elasticsearch-java-client-demo/blob/937685b0c9639cb336134e59aea3a710d7654f1e/src/test/java/fr/pilato/test/elasticsearch/hlclient/EsClientTest.java#L394-L408

    
      
          @Test
          void rangeQuery() throws IOException {
              try {
                  client.indices().delete(new DeleteIndexRequest("rangequery"), RequestOptions.DEFAULT);
              } catch (ElasticsearchStatusException ignored) { }
              client.index(new IndexRequest("rangequery").id("1").source("{\"foo\":1}", XContentType.JSON), RequestOptions.DEFAULT);
              client.index(new IndexRequest("rangequery").id("2").source("{\"foo\":2}", XContentType.JSON), RequestOptions.DEFAULT);
              client.indices().refresh(new RefreshRequest("rangequery"), RequestOptions.DEFAULT);
              SearchResponse response = client.search(new SearchRequest("rangequery").source(new SearchSourceBuilder()
                      .query(QueryBuilders.rangeQuery("foo").from(0).to(1))
              ), RequestOptions.DEFAULT);
              for (SearchHit hit : response.getHits()) {
                  logger.info("hit _id = {}, _source = {}", hit.getId(), hit.getSourceAsString());
              }
          }

system · July 8, 2021, 8:45am

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.