Thanks Sajid and Alan . I got right syntax. thanks for right pointer. ________________________________ From: Alan Gates <[email protected]> Sent: Tuesday, June 19, 2018 12:26 AM To: [email protected] Subject: Re: drop partitions
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-DropPartitions Alan. On Sat, Jun 16, 2018 at 8:03 PM Mahender Sarangam <[email protected]<mailto:[email protected]>> 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
