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

asmaalqasem4 · December 1, 2021, 7:58am

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,

majagrubic · December 1, 2021, 9:58am

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

asmaalqasem4 · December 1, 2021, 10:12am

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

majagrubic · December 1, 2021, 10:15am

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

asmaalqasem4 · December 1, 2021, 10:53am

this is what i get when i run the query

majagrubic · December 1, 2021, 1:21pm

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

asmaalqasem4 · December 1, 2021, 1:34pm

what can i use instead of union?

majagrubic · December 1, 2021, 4:44pm

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.

system · December 29, 2021, 4:44pm

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