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