# 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:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jimmy0](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jimmy0/32/136361_2.png) [@jimmy0](https://discuss.elastic.co/u/jimmy0)\
**Post date:** [October 31, 2024, 3:56am UTC](https://discuss.elastic.co/t/is-it-possible-to-using-id-in-elasticsearch-sql/369859/1 "2024-10-31T03:56:06Z")

</div>

When i use \_id in a elasticsearch sql，

```auto
GET /_sql
{
  "query": """
  select * from question where _id='RzSIwnABg0jflGUtAmBx'
  """
}

```

i get an error.

```auto
{
  "error": {
    "root_cause": [
      {
        "type": "verification_exception",
        "reason": "Found 1 problem\nline 2:32: Unknown column [_id]"
      }
    ],
    "type": "verification_exception",
    "reason": "Found 1 problem\nline 2:32: Unknown column [_id]"
  },
  "status": 400
}

```

Anyone can help？Thanks.

---

<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)

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [November 2, 2024, 4:12am UTC](https://discuss.elastic.co/t/is-it-possible-to-using-id-in-elasticsearch-sql/369859/3 "2024-11-02T04:12:11Z")

</div>

Note that it's possible though using ES|QL instead:

```auto
FROM question METADATA _id
| WHERE _id == "RzSIwnABg0jflGUtAmBx"
| LIMIT 1

```

---

<div class="post-metadata">

**Author:** ![jimmy0](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jimmy0/32/136361_2.png) [@jimmy0](https://discuss.elastic.co/u/jimmy0)\
**Post date:** [November 18, 2024, 1:16am UTC](https://discuss.elastic.co/t/is-it-possible-to-using-id-in-elasticsearch-sql/369859/4 "2024-11-18T01:16:01Z")

</div>

Thanks.  
Then I tried

```auto
POST /_sql
{
  "query": "SELECT * from question METADATA _id WHERE _id == 'RzSIwnABg0jflGUtAmBx' LIMIT 1"
}

```

I got the error:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/6/b6d046334772426bf91b252e44aa96557b6f3fee.png)

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [November 18, 2024, 1:35am UTC](https://discuss.elastic.co/t/is-it-possible-to-using-id-in-elasticsearch-sql/369859/5 "2024-11-18T01:35:31Z")

</div>

ES|QL is not SQL.