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

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

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

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.

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