title: how to delete data from a delta file in databricks?
body: <p>I want to delete data from a delta file in databricks.
  Im using these commands<br />
  Ex:</p>
  <pre><code>PR=spark.read.format('delta').options(header=True).load('/mnt/landing/Base_Tables/EventHistory/')
  PR.write.format(&quot;delta&quot;).mode('overwrite').saveAsTable('PR')
  spark.sql('delete from PR where PR_Number=4600')
  </code></pre>
  <p>This is deleting data from the table but not from the actual delta file. And i want to delete the data in the file without using merge operation, because the join condition is not matching. Can anyone please help me in resolving this issue.</p>
  <p>Thanks</p>