hive elasticsearch external table creation
'es.index.auto.create' default to true
just add this
CREATE TABLE test (day STRING, idCust STRING)STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler'TBLPROPERTIES('es.resource' = 'test/test','es.mapping.names' = 'day:@timestamp','es.nodes' = 'localhost', **'es.index.auto.create' = 'true','es.index.read.missing.as.empty'='yes'**);
i think it may solve the problem