Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive fetching different results

Hive fetching different results

New Contributor

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

 date_dt (DATE'2018-03-31',DATE'2018-05-19',DATE'2018-04-28',DATE'2018-03-17')

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'
3 REPLIES 3

Re: Hive fetching different results

can you try running MSCK REPAIR TABLE TABLENAME and re-execute your query.

Highlighted

Re: Hive fetching different results

New Contributor

@kgautam we already tried running MSCK repair and analyze table before posting this issue here, thanks.

Re: Hive fetching different results

New Contributor

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.

Don't have an account?
Coming from Hortonworks? Activate your account here