Elastic Search Does not overwrite data from Hive overwrite insert statement

Elastic Stack Elasticsearch
1

Trying to do insert overwrite es_table from select *;
Does not overwrites the data in es_tables, instead count on es_tables doubles;

My data does not have a unique column, so used two column as mapping.id, then while trying to insert data into es_table, it is throwing following error.

Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing row

Tried following ways:
'es.mapping.id'='field1(string column), field2(stringcolumn)'

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.