hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yogesh dhari <yogeshdh...@live.com>
Subject NEED HELP in Hive Query
Date Sun, 14 Oct 2012 14:54:20 GMT

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&sectid=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



 		 	   		  
Mime
View raw message