title: Add Column to Table with Default Value
body: <p>I'm trying to add a column to a table (ideally without using a dataframe) with a default value of 'MONTHLY'</p>
  
  <pre><code>ALTER TABLE aa_monthly ADD COLUMNS (Monthly_or_Weekly_Indicator string NOT NULL FIRST DEFAULT ('MONTHLY'))
  </code></pre>
  
  <p>This gives me an error of:</p>
  
  <blockquote>
    <p>Error in SQL statement: ParseException:  mismatched input 'DEFAULT'
    expecting ')'(line 1, pos 88)</p>
  </blockquote>
  
  <p>I get the same error regardless of whether or not I have <code>FIRST</code> in the sql statement.</p>
  
  <p>I've looked <a href="https://stackoverflow.com/questions/31807768/in-sql-how-to-add-values-after-add-a-new-column-in-the-existing-table">here</a> and <a href="https://docs.databricks.com/user-guide/tables.html#update-a-table" rel="nofollow noreferrer">here</a></p>