Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

select count query taking more time

avatar
Expert Contributor

Doing select count on table having 3 lac/more records takes more than 5 mins. Is there any tuning document for hive we can refer to optimize query performance ?

11 REPLIES 11

avatar
Rising Star

@Ashnee Sharma

Can you please set hive.support.concurrency=false and

then try to run select count(*) from rasdb.test;

avatar

@srinivasa rao

I have tried with following properties

  1. set hive.compute.query.using.stats=true;
  2. set hive.stats.fetch.column.stats=true;
  3. set hive.stats.fetch.partition.stats=true;
  4. set hive.fetch.task.conversion=more;
  5. set hive.support.concurrency=false

it is taking 3 min. for count.