Hi Team, I am trying to connect to ElasticSearch via Drill. Came across this <https://issues.apache.org/jira/browse/DRILL-3637>, but the work seems to be in progress. So i tried using JDBC storage plugin for ElasticSearch, and used sql4es jar <https://github.com/Anchormen/sql4es> for the same. But to no avail. I keep getting the error: Please retry: error (unable to create/ update storage) Following is the configuration i used: { "type": "jdbc", "driver": "nl.anchormen.sql4es.jdbc.ESDriver", "url": "jdbc:sql4es://localhost:9200/48FxIll?cluster.name=elasticsearch", "username": "", "password": "", "enabled": true } and a few permutations of the same like for example changing url to just : jdbc:sql4es://localhost:9200 etc. I am pretty sure i don't need credentials, for i have not installed the X-Pack extension for ElasticSearch. But i am unaware if still some default thing needs to be used. Can somebody please guide me in this regard?
Thanks, Charuta