Open ksco92 opened 1 year ago
I have 6 clusters, 3 in us-west-2 and 3 in us-east-1, I have upgraded them all to 2.5. While the connection is successful, the above errors still happen. I also noticed that the driver reports the version of the cluster as OS 7.10
@ksco92, I guess version 7.10 is returned, because compatibility mode is on. See pic below from AWS console, from create new cluster menu:
I can't reproduce your error, but I keep playing with DataGrip There are my Datasource settings:
Driver settings:
Note: I have to set env vars required for AWS authentication prior to running DataGrip:
Please, check your set up to ensure that nothing missed.
Just discovered that you're using JDBC driver v.1.0. Please, download and try most recent one from maven.
Hi! Can you please guide me through how you figured this out? I downloaded the driver specifically listed here:
https://opensearch.org/artifacts
And the AWS docs here say that driver version 1.1.0.1 goes with OS 2.5:
https://docs.aws.amazon.com/opensearch-service/latest/developerguide/sql-support.html
It even links to download that version directly:
https://artifacts.opensearch.org/opensearch-clients/jdbc/opensearch-sql-jdbc-1.1.0.1.jar
Does this mean that the version in maven is different and that docs should be corrected?
Unfortunately, artifacts page still contains older version of JDBC. I'll update it soon. Sorry about that. Maven stores most recent version.
I still seem to be having something weird going on:
Am I missing something embarrassing here?
I also do have valid creds.
Driver file on Maven has no embedded dependencies (no shadow jar) and it is supposed that application would download them automatically. opensearch-sql-jdbc-1.2.0.0.zip Try renaming this file to jar and using it.
I didn't noticed where I got my jar from, but it has embedded all dependencies in (shadow jar).
@
JDBC driver 1.2, OpenSearch 2.5
@
DataGrid enforces driver to use fetchSize
> 0
@
All requests to SQL plugin are paginated queries
@
Queries fall back to the legacy engine in the plugin
@
Legacy engine doesn't support queries without FROM
clause. Pagination in general has also limited support.
fetchSize
if givenHi, just tried latest version opensearch-sql-jdbc-shadow-1.4.0.1.jar downloaded from
https://artifacts.opensearch.org/opensearch-clients/jdbc/opensearch-sql-jdbc-shadow-1.4.0.1.jar
and when try select nested object got an error
<failed to load> org.opensearch.jdbc.StructImpl
What is the bug? After setting up the JDBC driver in DataGrip I get inconsistent errors. See reproduction steps for details.
How can one reproduce the bug? Steps to reproduce the behavior:
org.opensearch.jdbc.Driver
auth
:AWS_SIGV4
region
: The region the cluster is onThis is where the behaviors begin:
Where
hosts_rodrigof_metadata_hosts_2023-04-11
is an index andhosts_rodrigof_metadata_hosts
is an alias. However, using the Elasticsearch plugin, I can successfully run queries via HTTP:Something I have noticed is that the use of
*
doesn't work, for example:select * from my_index
Fails with
java.sql.SQLException
, but:select col1 from my_index
Does work.
What is the expected behavior? Queries should run as expected when using the JDBC driver.
What is your host/environment?