opensearch-project / opensearch-project/sql-jdbc
[BUG] Connect DBVisualizer to OpenSearch
Nobody has claimed this yet.
- Dominant language
- Java
- Stars
- 28
- Forks
- 39
- PR merge metrics
- No merged PRs in 30d
Description
Describe the bug
In Dbvisualizer 23.1 cant see geo datatype data from opensearch connection
To Reproduce
- Go to dbvisiualizer
- Click on add driver
- add jdbc driver
- make connection
- open sql worksheet
SELECT
*
FROM
opensearch_dashboards_sample_data_flights;
Columns OriginLocation and DestLocation are null , all others are filled
Expected behavior
no errors all columns shown
Plugins
Screenshots
Host/Environment (please complete the following information):
- OS: Windows 11
Additional context
Docker developer container - dev tools works fine..
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the JDBC connection from DbVisualizer 23.1 against the OpenSearch flights sample data and run the reported SELECT query. Compare the returned OriginLocation and DestLocation values with the other columns and the expected geo datatype behavior; done means both geo columns are returned instead of null without errors.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100