Re: alter table add more columns

[Patcharee Thongtra]

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