I'm trying to query elasticsearch hive table from SQL Workbench.
I'm using Elastic: 6.2.X version.
I've uploaded both elasticsearch-hadoop & elasticsearch-hadoop-hive jars but, it didn't work.
Here is the error:
Error while compiling statement: FAILED: RuntimeException org.apache.hadoop.hive.ql.metadata.HiveException: Error in loading storage handler.org.elasticsearch.hadoop.hive.EsStorageHandler [SQL State=42000, DB Errorcode=40000]