hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <>
Subject Re: counting number of pageviews and unique pageviews
Date Mon, 11 Jun 2012 12:49:18 GMT
If you want to write back these results to some rdbms then you can use

if you want to save the results to some file, then just redirect the output
of query to somefile

can you tell how are you executing the hive query from your code? that will
be helpful to answer your question

On Mon, Jun 11, 2012 at 6:15 PM, Cam Bazz <> wrote:

> Hello,
> I have finally wrote a program to upload my data to amazon s3, start a
> cluster on amazon emr, and recover my partitions, and can issue simple
> queries on hive.
> now I would like to:
> select count(*),itemSid from items group by itemSid <- gives me how
> many times an item as viewed
> and another query to extract unique views that i dont know how to yet.
> how do I store the outputs of these queries,
> such as:
> itemSid, pageViews, uniquePageViews
> 1            10             8
> commonsense tells me, store the results of query A, then query B, and
> then combine them in a table?
> is that correct, and if so, how can i accomplish this?
> Best Regards,
> C.B.

Nitin Pawar

View raw message