OpenSearch JDBC driver - Error parsing root / intermediate nodes of the JSON - Compatibility with Tableau

Plugins SQL
,
1

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]

image
image802×476 16.6 KB

2

@anirudha Might know a little more about this.

Also, you might want to throw an issue on the SQL repo where the JDBC driver source is housed.

1 Like
3

Done! Thanks @searchymcsearchface !

@anirudha Any idea? Many thanks in advance!!