Hi Team,

I would like to get the exact result of an SQL query

select sum(Amount) from Emp group by (Name).... Here If I take an example

like

id Name amount

1 A1 100

2 A2 200

3 A3 300

4 A1 200

5 A2 300

So for the above query the result will be Sum(Amount) by grouping the names

A1, A2, A3 and for A1--> sum(100+200=300), A2-->sum(200+300=500),

A3-->sum(300)...

For this query I have used the following equivalent query using

Aggregations as shown below:

GET ABCD/_search

{

"size": 0,

"aggs": {

"group_trans": {

"terms": {

"field": "trans"

},

"aggs": {

"sum_ordamt":{

"sum":{

"field":"ordamt"

}

}

}

}

}

}

Am getting the result as:

"aggregations": {

"group_trans": {

"doc_count_error_upper_bound": 81,

"sum_other_doc_count": 1371988,

"buckets": [

{

"key": "7ce2d738-5549-4da2-aed0-db939f3a9188",

"doc_count": 282,

"sum_ordamt": {

"value": 0

}

},

{

"key": "8f4b187a-f321-4d25-bbc0-a9e78f5810b8",

"doc_count": 230,

"sum_ordamt": {

"value": 0

}

},

{

"key": "ca54db4c-620b-4650-bef6-350e83a0ca2c",

"doc_count": 170,

"sum_ordamt": {

"value": 0

}

}

.

.

.

]

}

}

} .........................Here Am getting sum

value==0, May I know is there any way to Make a query relevant to the SQL

query given above for to give the sum depending on the group by names...

--

You received this message because you are subscribed to the Google Groups "elasticsearch" group.

To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/ab20bcf5-d573-431b-bb9e-7c1207109988%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.