title: Is it possible to change a column name in Spark SQL in Hive?
body: <p>I'm trying to rename a column (date type), but wasn't sure if the syntax was wrong or if this just isn't possible in Spark SQL:</p>
  
  <pre><code>ALTER TABLE user.temp_medicalclaims 
  CHANGE vendor_test_id date_service DATE
  </code></pre>
  
  <p>brings up this error:</p>
  
  <blockquote>
    <p>org.apache.spark.sql.AnalysisException: ALTER TABLE CHANGE COLUMN is
    not supported for changing column 'vendor_test_id' with type
    'DateType' to 'date_service' with type 'DateType';</p>
  </blockquote>