Re: Need help with query

2016-09-12 Thread Lefty Leverenz
at will be the perfect > solution to your requirement in my opinion. > Regards > Dev > > On 13 Sep 2016 12:49 am, "Igor Kravzov" wrote: > >> Hi, >> >> I have a query like this one >> >> alter table my_table >> add if not exists partitio

Re: Need help with query

2016-09-12 Thread Devopam Mittra
Kindly learn dynamic partition from cwiki. That will be the perfect solution to your requirement in my opinion. Regards Dev On 13 Sep 2016 12:49 am, "Igor Kravzov" wrote: > Hi, > > I have a query like this one > > alter table my_table > add if not exists partition

Need help with query

2016-09-12 Thread Igor Kravzov
Hi, I have a query like this one alter table my_table add if not exists partition (mmdd=20160912) location '/mylocation/20160912'; Is it possible to make so I don't have to change date every day? Something with CURRENT_DATE;? Thanks in advance.