Elasticsearch custom query for getting elements of particular range?

Question

I'm new to Elasticsearch so, here is my doubt:

I have large data inserted into Elastic search. The data that I have inserted contains an attribute of marks of each subject, is it possible to write an Elasticsearch query to find the number of students who has their marks in the inputted range.

Example:

|studentname | maths | computers |
++++++++++++++++++++++++++++++++++
|s1          |78     |90         |
==================================
|s2          |56     |75         |
==================================
|s3          |45     |50         |
==================================

Assuming the data that is present in the ES in a tabular manner, is it possible to

1.Find the list of students who has scored more than 50 marks in computers.

2.Find the list of students who has scored more than 60 marks in both subjects.

Vijay · Accepted Answer · 2017-04-12 11:35:09Z

1

Use range query :-

{  
   "query":{"bool":{"must":{"range":{computers:{gte: 50} }}}}
}

Check this link

edited Apr 12, 2017 at 11:35

answered Apr 12, 2017 at 11:22

Vijay

5,0781 gold badge35 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Abhishek Ekaanth Over a year ago

can you be a bit more elaborate? About method type and URL request ?

Vijay Over a year ago

Here computer type should be long or integer .URL - index/type/_search

Vijay Over a year ago

elastic.co/guide/en/elasticsearch/reference/current/…

Abhishek Ekaanth Over a year ago

do you have any idea how to make this request in java? or where can I go and read about it?

Vijay Over a year ago

Check this link ,elastic.co/guide/en/elasticsearch/client/java-api/1.4/…

|

Collectives™ on Stack Overflow

Elasticsearch custom query for getting elements of particular range?

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related