opensearch-project / opensearch-project/sql-jdbc
OpenSearch JDBC driver - Error parsing root / intermediate nodes of the JSON - Compatibility with Tableau
Nobody has claimed this yet.
- Dominant language
- Java
- Stars
- 28
- Forks
- 39
- PR merge metrics
- No merged PRs in 30d
Description
Is Opensearch 1.2.4 along with JDBC driver 1.1.0.1 compatible for retrieving and analysing data in Tableau?
I tried this JDBC driver in DbVisualizer and there are errors parsing columns of type OBJET, Unknown Type (2.002), these are the root / intermediate nodes of the fetched JSON records, that prevents the rest of the columns to show correctly. This does not happen, it woks properly, in an ElasticSearch with license and Elastic JDBC driver.
My guess is that the problem lies in the JDBC side, OpenSearch JDBC driver is missing something to properly parse fetched JSON records, relative to root / intermediate nodes. Maybe ElasticSearch JDBC Driver is ignoring them and only parses final nodes to columns.
View image:
Opensearch [Opensearch 1.2.4 + Opensearch JDBC Driver 1.1.0.1]:
Elastic [ElasticSearch JDBC Driver + ElasticSearch with license]
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
No source files or tests are named. Start by reproducing the parsing errors with OpenSearch 1.2.4, JDBC driver 1.1.0.1, and the reported Tableau or DbVisualizer workflow, then trace how root and intermediate JSON objects are exposed as columns; done means those fields no longer prevent the remaining columns from displaying.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100