ES-SQL UNION alternative [Was: Sql query canvas]

Elastic Stack Elasticsearch
1

Hello,,

I need to implement this query in the canvas but it is not working. is there another way to get the same result?

  • SELECT SUM(amount) **
    *FROM (SELECT AMOUNT as amount FROM "payment-index "*
  • UNION **
    *SELECT PaindAmount as amount FROM "ssk-index ")*

thanks,

2

Hi, could you provide a bit more info into what's not working exactly and how does your data look like?

3

I have two different indices with two different fields, i want to add them together and view it in the dashboard, i tried to it by dashboard but it is not possible.. now i am trying to use canvas to make this

4

And what is the error that you're getting with the current query?

5

image

image
image1042×608 62.5 KB

this is what i get when i run the query

6

I think UNION is not supported by the ES SQL, according to the docs here.

7

what can i use instead of union?

8

I will transfer this question to ES forum, as they might be able to help further. In the meantime, this is an issue to help you track support for UNION.