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

2013-04-08 Thread Mike Liddell
amenable to this. -mike. From: Matthieu Labour [mailto:matth...@actionx.com] Sent: Monday, April 08, 2013 3:50 PM To: user@hive.apache.org Subject: Should the SQL schema for HIVE be identical to the SQL schema for a relational database? Hi It would be terrific to get some advice on migrating a

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: {"ts":N+1,"userId":"123","ev