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" <[email protected]> wrote: > Hi, > > I have a query like this one > > alter table my_table > add if not exists partition (yyyymmdd=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. >
