# Issue with Elasticsearch 1.7.0 queries with Java 8 Update 66 on Mac **URL:** \ **Category:** Elasticsearch\ **Created:** [March 3, 2016, 7:33am UTC](https://discuss.elastic.co/t/issue-with-elasticsearch-1-7-0-queries-with-java-8-update-66-on-mac/43343 "2016-03-03T07:33:31Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![himanshu.sati](https://avatars.discourse-cdn.com/v4/letter/h/c77e96/32.png) [@himanshu.sati](https://discuss.elastic.co/u/himanshu.sati)\ **Post date:** [March 3, 2016, 7:33am UTC](https://discuss.elastic.co/t/issue-with-elasticsearch-1-7-0-queries-with-java-8-update-66-on-mac/43343/1 "2016-03-03T07:33:31Z")
I have a use case where i am trying to fetch some data from elasticsearch in sorted order , below is the java code to do so. QueryBuilder queryBuilder = QueryBuilders.boolQuery().must(QueryBuilders.matchQuery("id", id)).must(QueryBuilders.matchQuery("status", status)).must(QueryBuilders.rangeQuery("requestedTimestamp").gte(d.getTime())); Iterable values = userOnlineOtpRepository.search(queryBuilder, new PageRequest(0, CommonConstants.ES\_PAGINATION\_LIMIT, new Sort(new Sort.Order(Sort.Direction.DESC, "requestedTimestamp")))); This query always throws error , but works if i remove the portion which sorts the data i.e new Sort(new Sort.Order(Sort.Direction.DESC, "requestedTimestamp")). My Elasticsearch is running on local mac machine with Java 8 Update 66. Is it the Java version which is causing error ? ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [March 3, 2016, 7:34am UTC](https://discuss.elastic.co/t/issue-with-elasticsearch-1-7-0-queries-with-java-8-update-66-on-mac/43343/2 "2016-03-03T07:34:09Z")
Providing the error you got would be helpful 🙂 ---
**Author:** ![himanshu.sati](https://avatars.discourse-cdn.com/v4/letter/h/c77e96/32.png) [@himanshu.sati](https://discuss.elastic.co/u/himanshu.sati)\ **Post date:** [March 3, 2016, 8:18am UTC](https://discuss.elastic.co/t/issue-with-elasticsearch-1-7-0-queries-with-java-8-update-66-on-mac/43343/3 "2016-03-03T08:18:26Z")
This is the error log.. Failed to execute phase [dfs], all shards failed; shardFailures {[Yb2FXnm2QimOmPqUgbbLJg][otpindex][0]: SearchParseException[[otpindex][0]: query[+userId:5456765189 +requestedTimestamp:[1456992127734 TO \*]],from[0],size[1]: Parse Failure [Failed to parse source [{"from":0,"size":1,"query":{"bool":{"must":[{"match":{"userId":{"query":"5456765189","type":"boolean"}}},{"range":{"requestedTimestamp":{"from":1456992127734,"to":null,"include\_lower":true,"include\_upper":true}}}]}},"sort":[{"requestedTimestamp":{"order":"desc"}}]}]]]; nested: SearchParseException[[otpindex][0]: query[+userId:5456765189 +requestedTimestamp:[1456992127734 TO \*]],from[0],size[1]: Parse Failure [No mapping found for [requestedTimestamp] in order to sort on]]; }{[Yb2FXnm2QimOmPqUgbbLJg][otpindex][1]: SearchParseException[[otpindex][1]: query[+userId:5456765189 +requestedTimestamp:[1456992127734 TO \*]],from[0],size[1]: Parse Failure [Failed to parse source [{"from":0,"size":1,"query":{"bool":{"must":[{"match":{"userId":{"query":"5456765189","type":"boolean"}}},{"range":{"requestedTimestamp":{"from":1456992127734,"to":null,"include\_lower":true,"include\_upper":true}}}]}},"sort":[{"requestedTimestamp":{"order":"desc"}}]}]]]; nested: SearchParseException[[otpindex][1]: query[+userId:5456765189 +requestedTimestamp:[1456992127734 TO \*]],from[0],size[1]: Parse Failure [No mapping found for [requestedTimestamp] in order to sort on]]; }{[Yb2FXnm2QimOmPqUgbbLJg][otpindex][2]: SearchParseException[[otpindex][2]: query[+userId:5456765189 +requestedTimestamp:[1456992127734 TO \*]],from[0],size[1]: Parse Failure [Failed to parse source [{"from":0,"size":1,"query":{"bool":{"must":[{"match":{"userId":{"query":"5456765189","type":"boolean"}}},{"range":{"requestedTimestamp":{"from":1456992127734,"to":null,"include\_lower":true,"include\_upper":true}}}]}},"sort":[{"requestedTimestamp":{"order":"desc"}}]}]]]; nested: SearchParseException[[otpindex][2]: query[+userId:5456765189 +requestedTimestamp:[1456992127734 TO \*]],from[0],size[1]: _**Parse Failure [No mapping found for [requestedTimestamp] in order to sort on]]**;_ } Already an entry exist which contains a mapping for requestedTimestamp. ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [March 3, 2016, 9:27am UTC](https://discuss.elastic.co/t/issue-with-elasticsearch-1-7-0-queries-with-java-8-update-66-on-mac/43343/4 "2016-03-03T09:27:04Z")
What does the mapping look like then? ---
**Author:** ![himanshu.sati](https://avatars.discourse-cdn.com/v4/letter/h/c77e96/32.png) [@himanshu.sati](https://discuss.elastic.co/u/himanshu.sati)\ **Post date:** [March 3, 2016, 10:06am UTC](https://discuss.elastic.co/t/issue-with-elasticsearch-1-7-0-queries-with-java-8-update-66-on-mac/43343/5 "2016-03-03T10:06:53Z")
localhost:9200 **GET /otpindex/\_mapping** { "otpindex": { "mappings": { "UserOnlineOtp": { "properties": { "clientId": { "type": "string" }, "id": { "type": "string", "index": "not\_analyzed" }, "otp": { "type": "string" }, "phone": { "type": "string" }, **"requestedTimestamp": {** **"type": "long"** **}** , "status": { "type": "string" }, "userId": { "type": "long" } } } } } } Above is the search result from Sense. It has got mapping field for "requestedTimestamp" , but it still throws error while sorting on this field. Above stuff works fine if the Java version is 7 . ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [March 4, 2016, 12:49am UTC](https://discuss.elastic.co/t/issue-with-elasticsearch-1-7-0-queries-with-java-8-update-66-on-mac/43343/6 "2016-03-04T00:49:49Z")
Right, but it's mapped a timestamp as a long, not an actual date. I think you need to fix your mappings. ---
**Author:** ![himanshu.sati](https://avatars.discourse-cdn.com/v4/letter/h/c77e96/32.png) [@himanshu.sati](https://discuss.elastic.co/u/himanshu.sati)\ **Post date:** [March 8, 2016, 12:09pm UTC](https://discuss.elastic.co/t/issue-with-elasticsearch-1-7-0-queries-with-java-8-update-66-on-mac/43343/7 "2016-03-08T12:09:06Z")
We are facing same issue if we use **"userId": {"type": "long"}** as the sort parameter in ES query. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 5, 2017, 11:10pm UTC](https://discuss.elastic.co/t/issue-with-elasticsearch-1-7-0-queries-with-java-8-update-66-on-mac/43343/8 "2017-07-05T23:10:24Z")