You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Ryan LeCompte <le...@gmail.com> on 2010/03/16 17:26:49 UTC

Possible to add a new partition column?

Does the latest version of Hive allow us to add a new partition column  
to an existing table with data?

Thanks,
Ryan

Re: Possible to add a new partition column?

Posted by Edward Capriolo <ed...@gmail.com>.

On Tue, Mar 16, 2010 at 12:26 PM, Ryan LeCompte <le...@gmail.com> wrote:

> Does the latest version of Hive allow us to add a new partition column to
> an existing table with data?
>
> Thanks,
> Ryan
>
>
>
Ryan,

No direct way to do this. One option is to import the data into a new table.
Possibly you can use the hive Multi-Table-Insert

http://wiki.apache.org/hadoop/Hive/GettingStarted#MULTITABLE_INSERT

With this you can select data from the old tables directly into new tables.

Regards,
Edward