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-9999 and >cat Schema2.csv Id, Name, Address, Gender, Phone 13, Tom, address2, male, 888-888-8888 I put these two files into Hadoop and want to be able to query these 2 different schema's via Hive.. Do I need to create two tables in Hive to represent both schemas and use a join? Or is there a better way that can handle these two different schemas? Please reply back with any other specific questions, I realize this is somewhat open-ended.. thanks! -- -cd
