Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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.

Bertrand

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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB