I know that it is limitation in regular SQL in Kibana, but ESSQL is more like script than single query, so:
Is it possible in ESSQL to use select from select?.
For example, saving result from first select as table into variable "my_query":
|var_set name=my_query value={essql query={string SELECT host.name as n, system.diskio.name as s, last(system.diskio.io.time,\"@timestamp\") as v FROM \"<metricbeat-7.11.1-{now/d}>\"
where n is not null and s is not null group by n, s order by v desc}}
and now I want to use this table from variable "my_query" in another select:
Hi Pat, no this is not possible at the moment, ESSQL is an Elasticsearch SQL query, the current output is not chainable into another ESSQL query at the moment.
We are working on something similar but I don't have an ETA for that feature
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.