https://community.cloudera.com/t5/Support-Questions/Partition-in-Hive-table/m-p/174647#M136910 <P>here is example to drop partition</P><PRE><CODE>ALTER TABLE mytable DROP IF EXISTS PARTITION(year = 2012, month = 12, day = 18); </CODE></PRE> Tue, 15 Nov 2016 14:25:22 GMT sunile_manjee 2016-11-15T14:25:22Z https://community.cloudera.com/t5/Support-Questions/Partition-in-Hive-table/m-p/174646#M136909 <P></P><P>I have table 'tbl_1' with below columns. I need to delete data for revenue column for current month and last month every time I run the script which is daily and reload current month and last month. I have created partition on activity_dt and kpi_nm. Kpi_nm for revenue is ‘revenue’. How can I delete my partition? I have below query which does not work. Do I have to create shell and pass parameters? I would like to avoid it.</P><P>Activity_dt, Kpi_nm, Total_revenue, Gross_adds</P><P>alter table da_devstg_tbls.offline_transactions drop if exists partition ((activity_dt between ADD_MONTHS((CURRENT_DATE - EXTRACT(DAY FROM CURRENT_DATE)+1),-1) AND (CURRENT_DATE-1)) , kpi_nm = 'revenue');</P> Tue, 15 Nov 2016 11:34:02 GMT https://community.cloudera.com/t5/Support-Questions/Partition-in-Hive-table/m-p/174646#M136909 rychitre 2016-11-15T11:34:02Z https://community.cloudera.com/t5/Support-Questions/Partition-in-Hive-table/m-p/174647#M136910 <P>here is example to drop partition</P><PRE><CODE>ALTER TABLE mytable DROP IF EXISTS PARTITION(year = 2012, month = 12, day = 18); </CODE></PRE> Tue, 15 Nov 2016 14:25:22 GMT https://community.cloudera.com/t5/Support-Questions/Partition-in-Hive-table/m-p/174647#M136910 sunile_manjee 2016-11-15T14:25:22Z