Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (nike.apache.org: domain of cambazz@gmail.com designates
 209.85.210.48 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAORpBsjpn=PFh8W+TLxjbNL+W2m9C=gD7sNvRvRk+tSDLmsrfQ@mail.gmail.com>
References: 
 <CAEXpzt08JGG5ioRD2dXSY_YJ0=Di6gazT8zv1Fy5hvkpTmNfhA@mail.gmail.com>
	<CAORpBsjpn=PFh8W+TLxjbNL+W2m9C=gD7sNvRvRk+tSDLmsrfQ@mail.gmail.com>
Date: Mon, 11 Jun 2012 15:53:46 +0300
Message-ID: 
 <CAEXpzt2f+JKnUCS+sSEEn0J=isPBAZmZQz=tuOC7dAvuEDio2g@mail.gmail.com>
Subject: Re: counting number of pageviews and unique pageviews
From: Cam Bazz <cambazz@gmail.com>
To: user@hive.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hello Nitin,

yes, i want to write these results back to some rdbms, postgres, and i
had written some sort of merge program to handle text data into
postgres, but I will look at sqoop.

Currently there is no program, but I will either write a script, or one in =
java.

I will be making number of queries about the same item, and then have
to combine those results in a table like

itemSid, measurementA, measurementB ...

I am concerned about combining those results, basically from hive queries i=
 get:

for query A:
itemSid, measurementA

for query B:
itemSid, measurementB

...

etc.

Best.
C.B.


On Mon, Jun 11, 2012 at 3:49 PM, Nitin Pawar <nitinpawar432@gmail.com> wrot=
e:
> If you want to write back these results to some rdbms then you can use
> sqoop
>
> if you want to save the results to some file, then just redirect the outp=
ut
> of query to somefile
>
> can you tell how are you executing the hive query from your code? that wi=
ll
> be helpful to answer your question
>
>
> On Mon, Jun 11, 2012 at 6:15 PM, Cam Bazz <cambazz@gmail.com> 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 =A0 =A0 =A0 =A0 =A0 =A010 =A0 =A0 =A0 =A0 =A0 =A0 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
>