Hive is fetching different results, if we query on a specific partition its giving correct results, but when we do the query on a specific range its giving incorrect results.
when we query on specific date range its fetching correct results
but when we do the query on specific range, its yielding incorrect results
date_dt BETWEEN DATE'2017-07-08' AND DATE'2018-07-07'
What version of hive are you using? Can you share the query along with DDL/DMLs? I would like to see if I am able to reproduce this.