Questions tagged [amazon-opensearch]

242 questions
1
vote
0 answers

Using AWS OpenSearch Service with QuickSight

I have a cluster in AWS OpsenService runnin ElasticSearch 7. I have created a connection to Quicksight from which I can see the indexes, so all good so far. However, I'm getting this: I get it, QS does not support the type TEXT. However as per…
rodrigocf
  • 1,951
  • 13
  • 39
  • 62
1
vote
1 answer

How to serialize Fields response to object type from Elasticsearch.Net client GET doc request

When I use the Elasticsearch.Net client to do a Get document request, I am setting _source to false and specifying the stored fields I want to return. I do not want the _source because there are large contents and even if I exclude them, the server…
Gabe
  • 122
  • 5
1
vote
0 answers

Connecting requests from Internet to AWS VPC Opensearch domain

I am trying to understand on how i can connect requests coming from Internet to AWS Opensearch(v 1.2) cluster behind a VPC. I was looking at the options for SSHT, VPN Connectivity and Reverse Proxy where we are kind of more inclined towards the…
1
vote
0 answers

AWS Open Search keyword aggregation result issue with matching wild card search

I have setup indexed data on open search , here is some sample data [{ "_index" : "news-2022-05-25", "_type" : "_doc", "_id" : "49629288243749591350894282888456290133282338307278110722.0", "_score" :…
1
vote
2 answers

aws open search not able to insert data

i have given all the required permission from the aws. this error occurs when i tried to create an index. Error response: ResponseError: security_exception: [security_exception] Reason: no permissions for [indices:admin/create] and User…
0
votes
0 answers

Opensearch KNN query by Id or field value

There are plenty of example of how to use Opensearch to query by a vector field using Vector Index. I am looking to using KNN, but I need to query: Match item for a unique filed attribute (ItemId, str) For that item, run KNN search for Embeddings…
Aramakus
  • 1,910
  • 2
  • 11
  • 22
0
votes
0 answers

How to use k8s secrets for BasicAuth in OpenSearch Datascource in Grafana Helm chart Values file?

I’m trying to integrate AWS OpenSearch with self managed Grafana deployed via Helm charts for tracking application metrics. I created k8s generic secret and I want to use those secrets for openSearch datasource auth but I’m not sure how to use k8s…
0
votes
0 answers

Create scripted field on index in OpenSearch service using curl

I have a very large index in OpenSearch service and when trying to create a new scripted field on it from the UI, the request never have chance to finish as I always get disconnected from network before it does. So I was thinking to spin up an EC2…
Libor
  • 79
  • 2
  • 10
0
votes
0 answers

Timeout connecting to Elastic Search, both ES and Lambda are in the same VPC AWS

Timeout connecting to Elastic Search, both ES and Lambda are in the same VPC. The lambda role allows it to access all "es:*" and the VPC allows any resource to access as well. The security group both are attached to allow all traffic…
0
votes
1 answer

How to manage index state in Amazon OpenSearch Serverless?

We are moving from traditional self managed OpenSearch cluster to Amazon OpenSearch Serverless. Index is created daily with date pattern, and I want to add policy to delete index after few days. I used IndexManagement/StateManagementPolicies before…
Gautam
  • 51
  • 8
0
votes
0 answers

AWS: From IoT Core via Rule to OpenSearch

Main issue: Data is not written to OpenSearch I have data coming in on IoT Core, I can see the data on the MQTT Test Client I have a rule: SELECT * FROM test, My data already have a timestamp formatted correctly The rule have permission: …
0
votes
0 answers

AWS OpenSearch: Is it possible to combine normal query with SQL?

I'm in a project were we (as the title suggests) are using AWS OpenSearch to fetch data. We have a pretty extensive OpenSearch query and a lot of regular filtering (painless scripts, aggregations etc.) which always need to be used when we query. We…
0
votes
0 answers

Connecting Opensearch with MySQL - MySQL Data Source for Opensearch Indexes

I need to establish a connection between Opensearch and a data source like MySQL to enable the recreation of indexes in Opensearch using SQL queries to a database, similar to how SOLR does it. Is it feasible to accomplish this task? Currently, I'm…
Teo
  • 11
  • 2
0
votes
0 answers

Aws Opensearch return 403 forbidden error

I am getting the below error when i run the below program public class IndexDocument { private static final String host = "search-mythird-sp3y4ptm4wutec5ijq5e4cpqae.eu-north- private static Region region = Region.EU_NORTH_1; static { …
0
votes
0 answers

Anonymous User access to Amazon opensearch Dashboard

I have created a public facing Opensearch domain. When i created this domain, I was able to access and open the dashboard and also execute commands using the Dev tools. I used the Master user name and password to authenticate. However now when i try…
Gaurav Parashar
  • 1,347
  • 2
  • 19
  • 21