title: Is it possible to change partition metadata in HIVE?
body: <p>This is an extension of a previous question I asked: <a href="https://stackoverflow.com/questions/58240566/how-to-compare-two-columns-with-different-data-type-groups">How to compare two columns with different data type groups</a></p>
  
  <p>We are exploring the idea of changing the metadata on the table as opposed to performing a CAST operation on the data in SELECT statements. Changing the metadata in the MySQL metastore is easy enough. But, is it possible to have that metadata change applied to partitions (they are daily)? Otherwise, we might be stuck with current and future data being of type BIGINT while the historical is STRING.</p>
  
  <p>Question: Is it possible to change partition meta data in HIVE? If yes, how?</p>