Sorry for jumping in here…but could one of you be kind enough to point me to where I can get smarter on employing multiple partitions? Specifically, I’m not looking for SQL guidance,
· Column layout (do the partition column(s) have to be in any particular place in the DDL…like being the last few columns?) · File layout (how do I lay out a file folder structure in the Hive in order to accommodate multiple partitions?) TIA, __Birm Ricardo Birmele, CISSP Senior Security Technologist Microsoft IT Security Operations • | •••• | • [Microsoft Logo] From: Mohammad Tariq [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, Mohammad Tariq cloudfront.blogspot.com<http://cloudfront.blogspot.com> On Tue, Jun 3, 2014 at 2:52 AM, Ashish Garg <gargcreation1...@gmail.com<mailto:gargcreation1...@gmail.com>> wrote: No, you can't add other partition column. you have to work with your current partitions. Best Regards. [https://mail.google.com/mail/u/0/images/cleardot.gif] On Mon, Jun 2, 2014 at 5:22 PM, Ashish Garg <gargcreation1...@gmail.com<mailto:gargcreation1...@gmail.com>> 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 PM, Mohammad Tariq <donta...@gmail.com<mailto:donta...@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.thong...@uni.no<mailto:patcharee.thong...@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.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
