Opendistro jdbc issue

Plugins SQL
1

Hi Team,
I am trying to import elasticsearch index in a third party aplication as sql table using jdbc driver by giving below connection url but only columns are imported.Data(records) are not imported and not visible .
conn_url = “jdbc:elasticsearch://https://127.0.0.1:9200?trustSelfSigned=true”
table = “sarvindex”
username = “admin”
password = “admin”

Can you Please advice this below connection url is correct or not as in your documentation there are many key values are suggested in connection url like below.Am i missing anything here.

    jdbc:elasticsearch://[scheme://][host][:port][/context-path]?[property-key=value]&[property-key2=value2]..&[property-keyN=valueN]

Thanks
Sarvendra

2

@opendistro Team …Please help to reply on this.

3

Can anyone Please suggest on this?

4

take the https:// out and use this query string:

?useSSL=true&trustSelfSigned=true&hostnameVerification=false