By using AWS re:Post, you agree to the Terms of Use
/Connecting OpenSearch to QuickSight/

Connecting OpenSearch to QuickSight

0

I'm trying to connect AWS OpenSearch to QuickSight and export data to SPICE, but I get ELASTICSEARCH_CURSOR_NOT_ENABLED exception.

I was not able to find how to enable cursor for opensearch distro 1.1

  • region:eu-west-1
  • timestamp:1649003264494
  • requestId:95b8a137-9839-453c-affc-f50c0e32ae4e
  • sourceErrorCode:ELASTICSEARCH_CURSOR_NOT_ENABLED
  • sourceErrorMessage:The domain monei-prod has not enabled cursor.
3 Answers
0

Hi - I believe this is due to "The ElasticSearch/OpenSearch domain doesn't have SQL cursors enabled ("opendistro.sql.cursor.enabled" : "true")." (1). The Cursor is one of the settings you can configure on your cluster (2). You can enable it using Kibana or CLI as well.

(1) https://docs.aws.amazon.com/quicksight/latest/user/errors-skipped-rows-during-import.html

(2) https://opendistro.github.io/for-elasticsearch-docs/docs/sql/settings/

EXPERT
answered 2 months ago
0

I don't understand how this can be the accepted answer, that setting is removed from OpenSearch since version 1.0. https://github.com/opensearch-project/sql/pull/75

It is not working in OpenSearch v1.2 either.

answered 19 days ago
0

I've been able to enable cursors using an undocumented feature: sending the settings to the query endpoint instead of the _cluster/settings:

PUT _opendistro/_sql/settings
{
  "persistent" : {
    "opendistro.sql.cursor.enabled" : true
  }
}
{
  "acknowledged" : true,
  "persistent" : {
    "opendistro" : {
      "sql" : {
        "cursor" : {
          "enabled" : "true"
        }
      }
    }
  },
  "transient" : { }
}

works.

After this it is possible to ingest data to SPICE from QS.

answered 19 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions