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