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:
- Create a new OpenSearch cluster. I selected Elasticsearch 7.10 since the OpenSearch versions are not supported.
- Configure OpenSearch: Authorizing connections to Amazon OpenSearch Service - Amazon QuickSight using Kibana
- Create a new OpenSearch Data Source
- Edit/Preview Data
- Set Query mode to SPICE
- 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.