Support Questions

Find answers, ask questions, and share your expertise

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.