hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Patcharee Thongtra <Patcharee.Thong...@uni.no>
Subject Re: alter table add more columns
Date Mon, 02 Jun 2014 20:38:58 GMT
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 <mailto: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