RE: NEED HELP in Hive Query

2012-10-14 Thread yogesh dhari
distinct C; Dump D; Thanks & Regards Yogesh Kumar Dhari From: j...@omernik.com Date: Sun, 14 Oct 2012 12:29:23 -0500 Subject: Re: NEED HELP in Hive Query To: user@hive.apache.org select NAME, DATE, URL, SUM(HITCOUNT) as HITCOUNT from yourtable group by NAME, DATE, URL That's the HIVE an

Re: NEED HELP in Hive Query

2012-10-14 Thread John Omernik
select NAME, DATE, URL, SUM(HITCOUNT) as HITCOUNT from yourtable group by NAME, DATE, URL That's the HIVE answer. Not sure the PIG answer. On Sun, Oct 14, 2012 at 9:54 AM, yogesh dhari wrote: > Hi all, > > I have this file. I want this operation to perform in *HIVE & PIG* > > NAME