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,

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

asmaalqasem4 (asma) December 1, 2021, 1:34pm 7

what can i use instead of union?

Topic		Replies	Views
Canvas joining data from two different index/data view into one to show in dropdown Elasticsearch	1	38	September 26, 2024
[Kibana canvas] group multiple columns into one column with sql Kibana	2	785	September 5, 2019
Query with union and group in elasticsearch Elasticsearch	1	926	October 25, 2017
Union query Elasticsearch	2	2755	March 6, 2020
Perform Union on Two Sorted Queries Elasticsearch	1	401	July 6, 2017

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

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

Related topics