Elasticsearch sql is not working for some index

[sunitha.eswaraiah (Sunitha)]

Hi,

I'm unable to apply sql query on one index and i get this error,

{
  "error": {
    "root_cause": [
      {
        "type": "unsupported_operation_exception",
        "reason": null
      }
    ],
    "type": "unsupported_operation_exception",
    "reason": null
  },
  "status": 500
}

However, i can run sql queries on other indexes i have and it works perfectly fine. I'm not sure why one specific index is not working.

Any advice please?

Thanks,
Sunitha

[Andrei_Stefan]

@sunitha.eswaraiah are there any flattened field types in that index?
Would be useful to know the query that fails and, also, the full stack trace from logs.

A wild guess that it's about this PR: https://github.com/elastic/elasticsearch/pull/50823 but before knowing for sure, I need answers to above questions. Thanks.

[sunitha.eswaraiah (Sunitha)]

Hi @Andrei_Stefan

Thanks for the solution. I had search_as_you_type datatype in the mapping.
I reindexed removing the search_as_you_type and i'm able to apply SQL on the index.

Thanks you