# Is it possible to using \_id in elasticsearch sql

**URL:** <https://discuss.elastic.co/t/is-it-possible-to-using-id-in-elasticsearch-sql/369859>\
**Category:** Elasticsearch\
**Tags:** elastic-stack-sql\
**Created:** [October 31, 2024, 3:56am UTC](https://discuss.elastic.co/t/is-it-possible-to-using-id-in-elasticsearch-sql/369859 "2024-10-31T03:56:06Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![RabBit\_BR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rabbit_br/32/82261_2.png) [@RabBit\_BR](https://discuss.elastic.co/u/RabBit_BR)\
**Post date:** [November 2, 2024, 12:05am UTC](https://discuss.elastic.co/t/is-it-possible-to-using-id-in-elasticsearch-sql/369859/2 "2024-11-02T00:05:17Z")

</div>

Hi @jimmy0

It seems to me that it is not possible to use \_id because it is not a column.

Look this answer: [Is there a way to access internal \_id and \_type fields in ES SQL query (XPack)? - #2 by Andrei\_Stefan](https://discuss.elastic.co/t/is-there-a-way-to-access-internal-id-and-type-fields-in-es-sql-query-xpack/174894/2)

---

_[View the full topic](https://discuss.elastic.co/t/is-it-possible-to-using-id-in-elasticsearch-sql/369859)._