Re: Storing data in TSV with changing headers

2012-11-30 Thread Mark Grover
Hi Marc, While what Dean said is true for different schemas in general, there is a way to do it all in the same table if the schema changes to the TSV file are just additions of new tab-separated columns at the very end of each row and no existing columns are being deleted. Let's say your TSV file

Re: Storing data in TSV with changing headers

2012-11-30 Thread Dean Wampler
You'll have to define separate tables for the different schemas. You can "unify" them in a query with the union feature. You should also remove the header lines in the files, if you still have them, because Hive does not ignore them, but treats them as "data". dean On Fri, Nov 30, 2012 at 2:59 AM