[OpenSearch] OpenSearch Query Workbench Return 0 with Sum() or Count() Aggregation Query
0
Hi, We are try to run some Aggregation Query ( SUM or COUNT ) in OpenSearch Query Workbench. When we run the following simple query:
Select resource.amount.value FROM <index_>*
WHERE record_type = "<target_type>"
AND creation_time >= '2024-05-01 03:30:00'
We are able to get the result in a column with non-zero numbers:
However when we run query with sum(resource.amount.value), we get 0:
Why the sum() query return 0 even it is able to get each value?
1 Answer
- Newest
- Most votes
- Most comments
0
Hello,
Thank you for asking your question.
I would request you to please reach out to the AWS Premium Support team via a support case along with your domain arn and other details such as index mapping, index name and some sample data. So that the team can replicate this behavior at their end and resolve the issue for you.
We apologize for the inconvenience caused due to this.
Relevant content
AWS OFFICIALUpdated 3 years ago- AWS OFFICIALUpdated 7 months ago
- AWS OFFICIALUpdated 9 months ago
- AWS OFFICIALUpdated a year ago
FYI, we use static mapping on our OpenSearch. And
resource.amount.valueis not inculcated in the mapping. However, if the query is able to get each value, then sum() should be working as well.