hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Amey Barve <ameybarv...@gmail.com>
Subject select count(*) from table;
Date Tue, 22 Mar 2016 07:14:08 GMT
select count(*) from table;

How does hive evaluate count(*) on a table?

Does it return count by actually querying table, or directly return count
by consulting some statistics locally.

For Hive's Text format it takes few seconds while Hive's Orc format takes
fraction of seconds.

Regards,
Amey

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message