Re: ALTER TABLE CHANGE COLUMN issue

2013-01-30 Thread Nitin Pawar
;>------ >> *From:* Dean Wampler >> *To:* user@hive.apache.org >> *Cc:* hardik doshi >> *Sent:* Wednesday, January 30, 2013 5:51 AM >> *Subject:* Re: ALTER TABLE CHANGE COLUMN issue >> >> Right, the very important thing to

Re: ALTER TABLE CHANGE COLUMN issue

2013-01-30 Thread Mark Grover
after changing the > column type, it works. But it does not work > on old partition for some weird reasons. > > Any ideas? > > -Hardik. > > >-- > *From:* Dean Wampler > *To:* user@hive.apache.org > *Cc:* hardik doshi > *Sent:*

Re: ALTER TABLE CHANGE COLUMN issue

2013-01-30 Thread hardik doshi
for some weird reasons. Any ideas? -Hardik. From: Dean Wampler To: user@hive.apache.org Cc: hardik doshi Sent: Wednesday, January 30, 2013 5:51 AM Subject: Re: ALTER TABLE CHANGE COLUMN issue Right, the very important thing to remember about ALTER TABL

Re: ALTER TABLE CHANGE COLUMN issue

2013-01-30 Thread Dean Wampler
Right, the very important thing to remember about ALTER TABLE is that it only changes metadata about your table. It doesn't modify the data in any way. You have to do that yourself. On Wed, Jan 30, 2013 at 2:17 AM, Nitin Pawar wrote: > after u did alter table, did you add any new data to table wi

Re: ALTER TABLE CHANGE COLUMN issue

2013-01-30 Thread Nitin Pawar
after u did alter table, did you add any new data to table with new schema? for the old data already present in data, if you add anything new in columns it will be null value On Wed, Jan 30, 2013 at 1:44 PM, hardik doshi wrote: > Hi, > > I am running into an issue where ALTER TABLE CHANGE COLU

ALTER TABLE CHANGE COLUMN issue

2013-01-30 Thread hardik doshi
Hi, I am running into an issue where ALTER TABLE CHANGE COLUMN does not seem to be working. I have a table with a column data type looking like array> and I am trying to it change to array> based on the underlying data schema change. The alter command succeeds and subsequent describe call sho