I'm trying to create a range query in ES. Here's my Java example: QueryBuilder qb = QueryBuilders.rangeQUery("updateTime") .from(fromDate) .to(toDate) WHen I print it out, it looks like this: { "range" : { "updateTime" : { "from" : "2016-03-18-T15:00:00.000Z", "to" : "2016-03-28-T15:00:00.…

Looks like I'm getting a NumberFormatException fo{for input string: "2016-03-18T15:00:00.000Z" at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction.onFirstPhaseResult(TransportSearchTypeAction.java:228) org.elasticsearch.action.seasrch.type.TransportSearchTypeAction$Ba…

But you said Null Pointer, right? This is not the same error here. For what is worth, the string you passed is definitely not a number.

Yes, I was wrong on the error. What value can I use for a range query .from and .to if I want to do a range query using dates ?

If you reproduce with a full script your error, then we can probably help you. Here I have no idea about the mapping, the data... I suppose that updateTime is not a date??? But unsure

Works well on my end: DELETE test PUT test/doc/1 { "updateTime": "2016-03-18T15:00:00" } GET test/_search { "query": { "range": { "updateTime": { "gte": "2016-03-18T15:00:00.000Z", "lte": "2017-01-01T00:00:00.000Z" } } } } Gives: { "took": 8, "timed_o…

I'm doing this in Java. How do I setup the rangeQuery using dates in java ?

As you did. It looks correct to me (but the spaces). I told you already. I think your mapping is incorrect.

Date Range Query Java

Elastic Stack Elasticsearch

ajmariella March 29, 2016, 11:15am 7

updateTime is a date. I tried to setup the range query using:
QueryBuilder qb = QueryBuilders.rangeQuery("updateTime"
.gte("now - 2d/d")
.lte("now/d")

But I still get a NumberFormatException
How can I use "now" as a date format ?
What format should I use in the RangeQuery ?

Topic		Replies	Views
RangeQuery for Date Elasticsearch	3	18846	January 2, 2018
rangeQuery for Date with java Elasticsearch	0	677	December 4, 2019
Range query with dates not working any more with ES 5.0.0 using Java API Elasticsearch	2	2638	November 8, 2016
Elastic search range query not working Elasticsearch	1	1690	September 17, 2019
Time range search fails Elasticsearch	7	700	October 4, 2013

Date Range Query Java

Related topics