Hello fellow Dremio users,
I wanted to share an issue I encountered while trying to connect Dremio with Amazon OpenSearch Service and see if anyone has experienced a similar problem or found a solution. Specifically, I can establish a connection successfully, but I’m encountering a 404 error when attempting to query the index content.
Here are some details about my setup:
- Dremio version: 23.0.1
- Amazon OpenSearch Service version: 2.5.0
- Connector used: Amazon OpenSearch Service Source
The problem arises when I try to execute a query on the index content within Dremio. Instead of returning the expected results, I receive a 404 error response. I have double-checked the index name, the query syntax, and the permissions, but everything seems to be configured correctly.
I have already attempted the following troubleshooting steps without success:
- Verified the connection settings: I have confirmed that the connection details in Dremio are accurate, including the host, port, and access credentials.
- Checked index availability: I ensured that the index I’m querying is present and available in Amazon OpenSearch Service.
- Examined query syntax: I reviewed the query syntax for any potential mistakes or discrepancies, but it appears to be correct.
- Reviewed access permissions: I verified that the user credentials being used to connect Dremio to OpenSearch Service have sufficient permissions to query the index content.
Despite these efforts, the 404 error persists, preventing me from retrieving the desired data. I have searched extensively for similar issues or any documentation addressing this problem, but I haven’t found a definitive solution.
If anyone has encountered this issue before or has any insights on how to resolve it, I would greatly appreciate your assistance. Your input could be valuable not only to me but also to other community members who might face a similar challenge in the future.
Please feel free to share any suggestions, workarounds, or potential solutions that you have come across. Any advice, links to relevant resources, or personal experiences would be immensely helpful.
Thank you in advance for your time and assistance. I look forward to your responses!
Best regards, samuel2pb