Re: Implementing a star schema (facts & dimension model)

2012-10-22 Thread Shreepadma Venugopalan
I guess. Joins work well in hive. > Regards > Bejoy KS > > Sent from handheld, please excuse typos. > -- > *From: * Austin Chungath > *Date: *Mon, 22 Oct 2012 16:47:04 +0530 > *To: * > *ReplyTo: * user@hive.apache.org > *Subject: *Impl

Re: Implementing a star schema (facts & dimension model)

2012-10-22 Thread Manish Bhoge
Manish. Sent from my BlackBerry, pls excuse typo -Original Message- From: Austin Chungath Date: Mon, 22 Oct 2012 16:47:04 To: Reply-To: user@hive.apache.org Subject: Implementing a star schema (facts & dimension model) Hi, I am new to data warehousing in hadoop. This might be a t

Re: Implementing a star schema (facts & dimension model)

2012-10-22 Thread Bejoy KS
denormalization much I guess. Joins work well in hive. Regards Bejoy KS Sent from handheld, please excuse typos. -Original Message- From: Austin Chungath Date: Mon, 22 Oct 2012 16:47:04 To: Reply-To: user@hive.apache.org Subject: Implementing a star schema (facts & dimension model) Hi

Implementing a star schema (facts & dimension model)

2012-10-22 Thread Austin Chungath
Hi, I am new to data warehousing in hadoop. This might be a trivial question but I was unable to find any answers in the mailing list. My questions are: A person has an existing data warehouse that uses a star schema (implemented in a mysql database).How to migrate it to Hadoop? I can use sqoop to