How to compare value in elasticsearch

quangvublog · July 14, 2019, 10:24am

Hello everyone!

I am having some problems in filtering metrics in elasticsearch.
For example: beside a Total field, I want to filter value in fail column.

function:Total AND fail>0

In the above example: fail>0 is wrong. How can I fixt it? Thanks !

Quang Vũ Blog
Địa chỉ: 432 Nguyễn Thị Minh Khai, Phường 5, Quận 3, Hồ Chí Minh
Phone: +84 977 689 733
Email: quangvublog@gmail.com
Website: https://blog.vu-review.com

dadoonet · July 14, 2019, 12:55pm

Try:

function:Total AND fail:[0 TO ]

might work.

quangvublog · July 14, 2019, 3:36pm

Thank you so much! I have tried it and I get this reponse "2 of 4 shards failed"

dadoonet · July 14, 2019, 4:24pm

Probably because one of the mapping is not correct but I can't really tell with so few information.

quangvublog · July 14, 2019, 4:43pm

This is a snapshot of kibana, you can see it easily

dadoonet · July 14, 2019, 5:01pm

I don't see anything wrong as you described previously. So unless you give all details I'm afraid I cannot help.

Christian_Dahlqvist · July 14, 2019, 5:11pm

Can you retrieve and show the mappings for the indices matching the index pattern?

system · August 11, 2019, 5:16pm

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.