Hello,
My thoughts are rather straightforward: it is best not to think of hive
as a data warehouse at all. period.
It is better to think of it as SQL to MapReduce translation layer with some
meta data to help guide the process.
With this in mind, and if you really have lots of data, what you
Hello
Try to keep set of records which you need for particular analysis in same
table. Generally we use Pig to feed data to hive tables and we have
arranged our tables such that all the data which is to required for
particular report is right present in that table. This helps to improve
hive perfo
the main benefit of using Hive against Hbase as Hbase also recommends
> Highly de normalized BigTable.
> >
> >
> > Thanks,
> > Kuldeep
> > -Original Message-
> > From: Edward Capriolo [mailto:edlinuxg...@gmail.com]
> > Sent: 10 May 2012 19:24
> &
t; -Original Message-
> From: Edward Capriolo [mailto:edlinuxg...@gmail.com]
> Sent: 10 May 2012 19:24
> To: user@hive.apache.org
> Subject: Re: Dimensional Data Model on Hive
>
> On Thu, May 10, 2012 at 9:26 AM, Kuldeep Chitrakar
> wrote:
>> Hi
>>
>>
&
:24
To: user@hive.apache.org
Subject: Re: Dimensional Data Model on Hive
On Thu, May 10, 2012 at 9:26 AM, Kuldeep Chitrakar
wrote:
> Hi
>
>
>
> I have data warehouse implementation for Click Stream data analysis on
> RDBMS. Its a start schema (Dimensions and Facts).
>
>
>
On Thu, May 10, 2012 at 9:26 AM, Kuldeep Chitrakar
wrote:
> Hi
>
>
>
> I have data warehouse implementation for Click Stream data analysis on
> RDBMS. Its a start schema (Dimensions and Facts).
>
>
>
> Now if i want to move to Hive, Do i need to create same data model as
> Dimensions and facts and
