# // "reason": "Arrays (returned by \[ss\]) are not supported"

**URL:** <https://discuss.elastic.co/t/reason-arrays-returned-by-ss-are-not-supported/340136>\
**Category:** Elasticsearch\
**Created:** [August 4, 2023, 1:35pm UTC](https://discuss.elastic.co/t/reason-arrays-returned-by-ss-are-not-supported/340136 "2023-08-04T13:35:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![fangyan](https://avatars.discourse-cdn.com/v4/letter/f/3ab097/32.png) [@fangyan](https://discuss.elastic.co/u/fangyan)\
**Post date:** [August 4, 2023, 1:35pm UTC](https://discuss.elastic.co/t/reason-arrays-returned-by-ss-are-not-supported/340136/1 "2023-08-04T13:35:15Z")

</div>

Elasticsearch updated version to 8.9, using SQL function, found abnormal collection data reports. Has anyone encountered them?

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/5/05a3ea545b8edf86cacbedb490867c0aa91622cc.png)

---

<div class="post-metadata">

**Author:** ![Andrei\_Stefan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrei_stefan/32/47533_2.png) [@Andrei\_Stefan](https://discuss.elastic.co/u/Andrei_Stefan)\
**Post date:** [August 8, 2023, 6:40am UTC](https://discuss.elastic.co/t/reason-arrays-returned-by-ss-are-not-supported/340136/2 "2023-08-08T06:40:17Z")

</div>

I don't think this has anything to do with ES upgrade. This functionality exists in SQL since many major versions back.

This being said, you are getting that error because one of the fields used in your query (`ss`) has multiple values in it and ES SQL doesn't support multi-value fields by default. Please, see this link in our documentation for an workaround: [SQL Limitations | Elasticsearch Guide [8.9] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-limitations.html#_array_type_of_fields)

---

<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:** [August 8, 2023, 9:21am UTC](https://discuss.elastic.co/t/reason-arrays-returned-by-ss-are-not-supported/340136/3 "2023-08-08T09:21:00Z")

</div>

Please don't post images of text as they are hard to read, may not display correctly for everyone, and are not searchable.

Instead, paste the text and format it with `</>` icon or pairs of triple backticks (```), and check the preview window to make sure it's properly formatted before posting it. This makes it more likely that your question will receive a useful answer.

---

<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 5, 2023, 9:21am UTC](https://discuss.elastic.co/t/reason-arrays-returned-by-ss-are-not-supported/340136/4 "2023-09-05T09:21:42Z")

</div>

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