Query sem dados

Elastic Stack Kibana
1

Is there a way to do some elasticquery and if it didn't work, it returns something default?

2

I'm not totally sure what you mean. Which product are you using? Are you wanting to do a custom Elasticsearch query?

3

I will give an example

SELECT p1,p2,p3 FROM "teste-2021.3*"

image
image743×439 15.3 KB

if this happens i would like to have some standard data type: p1 = 0, p2 = 0 and p3 = 0, but as there is no data, even if I do this in the query itself with 'case' it does not solve

4

You should check the rowcount after receiving the data. If it is 0 set the defaults.
This example shows how to do it

5

Thanks, I'm checking, and I already realized that he still brings information even without outputs, however I am very new in elastic and I still couldn't, please if possible I could make an example on top of the one I sent.