Re: using hive with multiple schemas

2013-08-21 Thread Sanjay Subramanian
names_detail nd ON n.fullname = nd.fullname AND n.phone = nd.phone This query is not tested so please make tweaks as appropriate to make it work. Hope this helps Good luck sanjay From: Chris Driscol Reply-To: "user@hive.apache.org" Date: Wednesday, Augus

Re: using hive with multiple schemas

2013-08-21 Thread Stephen Sprague
yeah. database design is always subjective so everybody has an opinion about it. but if you're just starting out i would recommend you kinda follow the rules as you would in a traditional relational database system. so two different datasets would mean two different tables in both Hive and an Rdb d

using hive with multiple schemas

2013-08-21 Thread Chris Driscol
Hi - I just started to get my feet wet with Hive and have a question that I have not been able to find an answer to.. Suppose I have 2 CSV files: >cat Schema1.csv Name, Address, Phone Chris, address1, 999-999- and >cat Schema2.csv Id, Name, Address, Gender, Phone 13, Tom, address2, male, 888-