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
