hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mohammad Tariq <donta...@gmail.com>
Subject Re: alter table add more columns
Date Mon, 02 Jun 2014 21:17:20 GMT
Yes.

*Warm regards,*
*Mohammad Tariq*
*cloudfront.blogspot.com <http://cloudfront.blogspot.com>*


On Tue, Jun 3, 2014 at 2:08 AM, Patcharee Thongtra <
Patcharee.Thongtra@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.Thongtra@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
>>
>
>
>

Mime
View raw message