Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Re: count(*) vs count(1) in hive

Copy link to this message
Re: count(*) vs count(1) in hive
count(1) is the old one
count(*) is the new one

see https://issues.apache.org/jira/browse/HIVE-287

I guess when you can use the newer, you should use it.


On Tue, Aug 14, 2012 at 11:33 PM, Raihan Jamal <[EMAIL PROTECTED]>wrote:

> Is there any difference between count(*) and count(1) in Hive. And which
> one should we use in general and why?
> Given that I am on Hive 0.6 version.
> *Raihan Jamal*

Bertrand Dechoux