# Kibana essql - select from select

**URL:** <https://discuss.elastic.co/t/kibana-essql-select-from-select/277044>\
**Category:** Kibana\
**Created:** [June 25, 2021, 10:44am UTC](https://discuss.elastic.co/t/kibana-essql-select-from-select/277044 "2021-06-25T10:44:25Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![xquest](https://avatars.discourse-cdn.com/v4/letter/x/ce73a5/32.png) [@xquest](https://discuss.elastic.co/u/xquest)\
**Post date:** [June 25, 2021, 10:44am UTC](https://discuss.elastic.co/t/kibana-essql-select-from-select/277044/1 "2021-06-25T10:44:26Z")

</div>

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":

```auto
|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:

```auto
| essql query="SELECT xxx from my_query"

```

Is it possible?, if yes, please help me.

Thank You,  
Pat

---

<div class="post-metadata">

**Author:** ![markov00](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/markov00/32/33316_2.png) [@markov00](https://discuss.elastic.co/u/markov00)\
**Post date:** [July 22, 2021, 9:59am UTC](https://discuss.elastic.co/t/kibana-essql-select-from-select/277044/2 "2021-07-22T09:59:04Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![markov00](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/markov00/32/33316_2.png) [@markov00](https://discuss.elastic.co/u/markov00)\
**Post date:** [July 22, 2021, 9:59am UTC](https://discuss.elastic.co/t/kibana-essql-select-from-select/277044/3 "2021-07-22T09:59:51Z")

</div>

If not too complex, you an always use the canvas expression language to modify change the returned table, see: [Canvas function reference | Kibana Guide [master] | Elastic](https://www.elastic.co/guide/en/kibana/master/canvas-function-reference.html)

---

<div class="post-metadata">

**Author:** ![xquest](https://avatars.discourse-cdn.com/v4/letter/x/ce73a5/32.png) [@xquest](https://discuss.elastic.co/u/xquest)\
**Post date:** [August 17, 2021, 7:00am UTC](https://discuss.elastic.co/t/kibana-essql-select-from-select/277044/4 "2021-08-17T07:00:47Z")

</div>

Thank You for Your answer. I am waiting for new features 😉  
Have a nice day.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 14, 2021, 7:01am UTC](https://discuss.elastic.co/t/kibana-essql-select-from-select/277044/5 "2021-09-14T07:01:24Z")

</div>

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