how to add partitioned by column

[smartzjp <sm...@hotmail.com>]

I have created a table with " create table .... partitioned by (year int ,mont int)"now I want to add a day partition. how can i do it ?   TKS

Re: how to add partitioned by column

[Devopam Mittra <de...@gmail.com>]

1. Unless the table has huge size you may please try moving the data to a
temp table and then reloading it into a new table with the desired
partitioning.
2. If it's huge, then create a separate table with desired partition and
then load data from existing table for chunks of partitions from source
table.


Hope this helps

regards
Dev

On Tue, Mar 3, 2015 at 1:23 PM, smartzjp <sm...@hotmail.com> wrote:

> I have created a table with " create table .... partitioned by (year int
> ,mont int)"
> now I want to add a day partition. how can i do it ?   TKS
>



-- 
Devopam Mittra
Life and Relations are not binary