Should the SQL schema for HIVE be identical to the SQL schema for a relational database?

2013-04-08 Thread Matthieu Labour
Hi It would be terrific to get some advice on migrating a schema from RDMS to Hive. Should the SQL schema for HIVE be identical to the SQL schema for a Posgresql/mysql database? Specifically: I have an application that generates events that look like the following:

RE: Should the SQL schema for HIVE be identical to the SQL schema for a relational database?

2013-04-08 Thread Mike Liddell
Some general guidance would be to aim for minimal JOINs in your regular queries. Thus the biggest change from a normal-form RDBMS schema is to denormalize such that joins do not come in to play until a query has already performed data reduction via filtering or aggregation. This implies a star