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