Hi, In pig, you can try
GROUP data BY (NAME, DATE , URL) The detail is here: http://pig.apache.org/docs/r0.10.0/basic.html#GROUP Best, CHyi-kwei On Sun, Oct 14, 2012 at 10:54 AM, yogesh dhari <[email protected]> wrote: > > Hi all, > > I have this file. I want this operation to perform in HIVE & PIG > > NAME DATE URL > HITCOUNT > timesascent.in 2008-08-27 > http://timesascent.in/index.aspx?page=tparchives 15 > timesascent.in 2008-08-27 > http://timesascent.in/index.aspx?page=article§id=1&contentid=200812182008121814134447219270b26 > 20 > timesascent.in 2008-08-27 http://timesascent.in/ 37 > timesascent.in 2008-08-27 > http://timesascent.in/section/39/Job%20Wise 14 > timesascent.in 2008-08-27 > http://timesascent.in/article/7/2011062120110621171709769aacc537/Work-environment--Employee-productivity.html > 20 > timesascent.in 2008-08-27 http://timesascent.in/ 17 > timesascent.in 2008-08-27 > http://timesascent.in/section/2/Interviews 15 > timesascent.in 2008-08-27 http://timesascent.in/ 17 > timesascent.in 2008-08-27 http://timesascent.in/ 27 > timesascent.in 2008-08-27 http://timesascent.in/ 37 > timesascent.in 2008-08-27 http://timesascent.in/ 27 > timesascent.in 2008-08-27 http://www.timesascent.in/ 16 > timesascent.in 2008-08-27 > http://timesascent.in/section/2/Interviews 14 > timesascent.in 2008-08-27 http://timesascent.in/ 14 > timesascent.in 2008-08-27 http://timesascent.in/ 22 > > > I want to add all HITCOUNT for the same NAME, DATE & URL > > like > > timesascent.in 2008-08-27 http://timesascent.in/ (addition of all > hitcount under same name, date, url (37+17+17+27+....)) > > Please suggest me is there any method to perform this query. > > > Thanks & Regards > Yogesh Kumar > > > >
