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 >>>> >>> >>> >>> >> >
