RE: What's the right data storage/representation?

2012-05-15 Thread Jon Palmer
ld be writing a ETL process to maintain the Hive table based on the current status of the application db table .. Shrikanth On May 15, 2012, at 9:41 AM, Owen O'Malley wrote: > On Tue, May 15, 2012 at 5:11 AM, Jon Palmer wrote: >> I can see a few potential solutions: >> >

What's the right data storage/representation?

2012-05-15 Thread Jon Palmer
All, I'm a relative newcomer to Hadoop/Hive. We have a very standard setup of multiple webapp servers backed by a mySql database. We are evaluating Hive as a high scale solution for our relatively sophisticated reporting and analytics needs. However, it's not clear what the best practices are a