https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-DropPartitions
Alan. On Sat, Jun 16, 2018 at 8:03 PM Mahender Sarangam < mahender.bigd...@outlook.com> wrote: > Hi All, > > What is right syntax for dropping the partitions. Alter table drop if > exists partition(date >'date1'),partition(date <'date2') or Alter table > drop if exists partition(date >'date1', date <'date2') ? > > > Mahens > >