OpenSearch Dateset: ELASTICSEARCH_CURSOR_NOT_ENABLED error

Question and answer
#1

Hi - How do I fix ELASTICSEARCH_CURSOR_NOT_ENABLED error? My goal is to refresh my dashboard every 60 seconds. These steps will reproduce the error:

  1. Create a new OpenSearch cluster. I selected Elasticsearch 7.10 since the OpenSearch versions are not supported.
  2. Configure OpenSearch: Authorizing connections to Amazon OpenSearch Service - Amazon QuickSight using Kibana
  3. Create a new OpenSearch Data Source
  4. Edit/Preview Data
  5. Set Query mode to SPICE
  6. Save and Publish

I’ve tried opendistro.sql.cursor.enabled (Settings - Open Distro Documentation) but I’m getting this error: Your request: ‘/_cluster/settings’ payload is not allowed.

Thanks

Troy

#3

we will take a look and get back to you. Meanwhile, can you tell us where exactly you are seeing this error message?