Sorry for answering in a hurry. By "yes" I meant adding new partition value and not the partition column.
@Ashish : Thanks for the correction. *Warm regards,* *Mohammad Tariq* *cloudfront.blogspot.com <http://cloudfront.blogspot.com>* On Tue, Jun 3, 2014 at 2:52 AM, Ashish Garg <gargcreation1...@gmail.com> wrote: > No, you can't add other partition column. you have to work with your > current partitions. > Best Regards. > > > On Mon, Jun 2, 2014 at 5:22 PM, Ashish Garg <gargcreation1...@gmail.com> > wrote: > >> No, you can add other partition column. you have to work with your >> current partitions. >> Best Regards. >> >> >> On Mon, Jun 2, 2014 at 5:17 PM, Mohammad Tariq <donta...@gmail.com> >> wrote: >> >>> Yes. >>> >>> *Warm regards,* >>> *Mohammad Tariq* >>> *cloudfront.blogspot.com <http://cloudfront.blogspot.com>* >>> >>> >>> On Tue, Jun 3, 2014 at 2:08 AM, Patcharee Thongtra < >>> patcharee.thong...@uni.no> wrote: >>> >>>> Hi, >>>> >>>> Can I add a partition column? >>>> >>>> Patcharee >>>> >>>> >>>> On 06/02/2014 10:25 PM, Mohammad Tariq wrote: >>>> >>>> Hi Patcharee, >>>> >>>> You can definitely add new columns. This is how it is done : >>>> >>>> *ALTER TABLE table_name ADD|REPLACE COLUMNS (col_name data_type >>>> [COMMENT col_comment], ...)* >>>> >>>> For more info on Hive DDL you can visit this link >>>> <https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL>. >>>> >>>> *Warm regards,* >>>> *Mohammad Tariq* >>>> *cloudfront.blogspot.com <http://cloudfront.blogspot.com>* >>>> >>>> >>>> On Tue, Jun 3, 2014 at 1:36 AM, Patcharee Thongtra < >>>> patcharee.thong...@uni.no> wrote: >>>> >>>>> Hi, >>>>> >>>>> I have a table named fino31 with the following schema >>>>> >>>>> hive> describe fino31; >>>>> OK >>>>> date timestamp >>>>> zone int >>>>> z int >>>>> u float >>>>> v float >>>>> th float >>>>> qv float >>>>> ph float >>>>> >>>>> # Partition Information >>>>> # col_name data_type comment >>>>> >>>>> zone int >>>>> z int >>>>> u float >>>>> v float >>>>> th float >>>>> qv float >>>>> ph float >>>>> >>>>> Is it possible to alter this table later by adding more columns? >>>>> >>>>> Patcharee >>>>> >>>> >>>> >>>> >>> >> >
