Inconsistent results from Hive Query of ES table

Elastic Stack Elasticsearch
1

Hi,

I created an external table of an ES index in Hive and configured a query using es.query. The number of records returned through the hive query is less then that of a direct query using ES. How do we get the Hive query to return all results from the index?

Thank You.

Rgds
SL

2

Errors in fields mappings resulted in the inconsistency