[Select count(*) from table] How to get no. of rows without MapReduce job?



How we can get number of rows in Hive without MapReduce job ?

“Select count(*) from table” should straight away give number of records.


There need to be some processing happening on the data. You cannot avoid the processing. Alternative ways to perform processing

  • Tez
  • Spark engine
  • Impala
  • Presto