hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashish Garg <gargcreation1...@gmail.com>
Subject Re: alter table add more columns
Date Mon, 02 Jun 2014 21:22:08 GMT
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 <dontariq@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.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