RE: alter table add more columns

2014-06-03 Thread Ricardo Birmele
[mailto:donta...@gmail.com] Sent: Monday, 2 June, 2014 14:31 To: user Subject: Re: alter table add more columns Sorry for answering in a hurry. By "yes" I meant adding new partition value and not the partition column. @Ashish : Thanks for the correction. Warm regards, Moha

Re: alter table add more columns

2014-06-02 Thread Mohammad Tariq
Sorry for answering in a hurry. By "yes" I meant adding new partition value and not the partition column. @Ashish : Thanks for the correction. *Warm regards,* *Mohammad Tariq* *cloudfront.blogspot.com * On Tue, Jun 3, 2014 at 2:52 AM, Ashish Garg wrote: > No, y

Re: alter table add more columns

2014-06-02 Thread Ashish Garg
No, you can't add other partition column. you have to work with your current partitions. Best Regards. On Mon, Jun 2, 2014 at 5:22 PM, Ashish Garg wrote: > 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

Re: alter table add more columns

2014-06-02 Thread Ashish Garg
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 wrote: > Yes. > > *Warm regards,* > *Mohammad Tariq* > *cloudfront.blogspot.com * > > > On Tue, Jun 3, 2014 at 2:08

Re: alter table add more columns

2014-06-02 Thread Mohammad Tariq
Yes. *Warm regards,* *Mohammad Tariq* *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: > >

Re: alter table add more columns

2014-06-02 Thread 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 c

Re: alter table add more columns

2014-06-02 Thread Mohammad Tariq
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 . *Warm