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 >
