title: Can we have a where clause for delete from <tab> partition <part.>?
body: <p>I have a table partitioned based on time stamp (like <code>partition1</code> will have 9 months old data, <code>partition2</code> have 6 months old data, <code>partition3</code> have 3 months old data and so on)</p>
  
  <p>I need to delete data based on a condition on a specific partition.</p>
  
  <pre><code>delete from table1 partition partition3
  where group id in ( select * from table1 where group_code='pilot'); 
  </code></pre>
  
  <p>Is this operation will delete only from <code>partiton3</code>?</p>