Hi CHyi-kwei, Thanks for help, I think I wasn't able to clarify my question
The query you wrote It will count the number of occurrence of same NAME, DATE and URL but won't add all hitcount under same name, date, url. I want result like this like : timesascent.in, 2008-08-27, http://timesascent.in/ (/*addition of all hitcount under same name, date, url (37+17+17+27+....)*/ 98 ) timesascent.in, 2008-08-27, http://timesascent.in/section/2/Interviews (/*addition of all hitcount under same name, date, url (15+14)*/ 29) . . . >From this file below 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 Please help and suggest how to write query for this in HIVE and PIG Thanks & Regards Yogesh Kumar Dhari > Date: Sun, 14 Oct 2012 11:31:00 -0400 > Subject: Re: NEED HELP in Hive Query > From: [email protected] > To: [email protected] > > 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 > > > > > > > >
