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 select query with limit

hive select query with limit

I am trying to fetch results data stored in hive orc table , but when I run the query it gives results fast but When I run the with limit clause it is taking too much of time .

select * from tablename where year="2019" and month="jan-mar" ;

- Runs perfectly within 30-40secs

select * from tablename limit 10;

- Gets stuck

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