I use Hortonworks and I created a single-node cluster, I installed elasticsearch and kibana (6.2.3).
I downloaded the jar file elasticsearch-hadoop-6.2.3.jar and added it in hive-site.xml file with the property name hive.aux.jars.path.
I have database named hosix.
I created an external table like this :
CREATE EXTERNAL TABLE test (...)
STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler'
TBLPROPERTIES('es.resource' = 'hosix/test');
But when I want to select or loaded this table (select or insert queries) It shows me the following error :