Re: Change in serdeproperties does not update existing partitions

2011-09-14 Thread Ashutosh Chauhan
Hey Maxime, Looks like there is some confusion here. You need not to recreate partition any time you update something about the table. If you e.g. are adding new columns, you can just do alter table add column and then alter table add partition.. you need not to do anything about existing part

Re: Change in serdeproperties does not update existing partitions

2011-09-13 Thread Maxime Brugidou
Thanks Ashutosh for your answer. I actually use external tables so that i don't drop my partitions data. This is still an odd behavior to me and I don't get why someone would expect it. Whenever I need to add a column to a table (my table here represent a log, and it is common to add fields to log

Re: Change in serdeproperties does not update existing partitions

2011-09-13 Thread Ashutosh Chauhan
Hey Maxime, Yeah, thats intended behavior. After you do alter on table, all subsequent actions on table and partitions will inherit from it. If you want to modify properties of already existing partitions, you should be able to do something like 'alter table test_table partition (day='2011-09-02')

Change in serdeproperties does not update existing partitions

2011-09-13 Thread Maxime Brugidou
Hello, I am using Hive 0.7 from cloudera cdh3u0 and I encounter a strange behavior when I update the serdeproperties of a table (for example for the RegexSerDe). If you have a simple partitioned table like create external table test_table ( id int) partitioned by (day string) row format serd