title: Hive External Table - Drop Partition
body: <p>Facing a weird issue. <code>Alter table</code> command to drop partition works well for &gt; or &lt; or &gt;= or &lt;= signs but not for = check.</p>
  <p>Working command:</p>
  <pre><code>ALTER TABLE XYZ DROP PARTITION(bizdate&gt;'20231230');
  </code></pre>
  <p>Command that's not working and throwing an error stating that partition does not exist:</p>
  <pre><code>ALTER TABLE XYZ DROP PARTITION(bizdate='20231230');
  </code></pre>
  <p>When I do <code>show partitions</code>, I can see '20231230' partition.</p>
  <p>Note: <code>bizdate</code> is a <code>varchar(10)</code></p>