title: Amazon Athena ALTER TABLE ADD PARTITION query not working
body: <p>I am trying to use SQLWorkBenchJ to add partition to my table in Amazon Athena. The query works fine when run in the Athena Query Editor. It does not work when I run it using SQLWorkbench</p>
  
  <pre><code>ALTER TABLE "AwsDataCatalog".mydb.mytable ADD IF NOT EXISTS 
  PARTITION (folder = '10036', full = 'fullvalue') LOCATION 's3://my-s3-folder/10036/fullvalue/';
  </code></pre>
  
  <p>Note: I have also tried using ALTER EXTERNAL_TABLE </p>
  
  <p>sqlworkbench just returns:</p>
  
  <p>An error occurred when executing the SQL command:</p>
  
  <blockquote>
    <p>ALTER TABLE "AwsDataCatalog".mydb.mytable ADD PARTITION (folder = '10036', full >= 'fullvalue') LOCATION 's3://my-s3-folder...<br>
    Failed to run query<br>
    1 statement failed.</p>
  </blockquote>
  
  <p>running in query editor</p>
  
  <pre><code>ALTER TABLE mydb.mytable ADD PARTITION (folder = '10039', full = 'fullvalue') &gt;LOCATION 's3://my-s3-folder/10039/fullvalue/';
  </code></pre>
  
  <blockquote>
    <p>Query successful.</p>
  </blockquote>
  
  <p>any body know how to make this work so I can batch some add partition queries together? </p>