Thanks Sajid and Alan . I got right syntax. thanks for right pointer. ________________________________ From: Alan Gates <alanfga...@gmail.com> Sent: Tuesday, June 19, 2018 12:26 AM To: user@hive.apache.org 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 <mahender.bigd...@outlook.com<mailto: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