title: HIVE: How create a table with all columns in another table EXCEPT one of them?
body: <p>When I need to change a column into a partition (<a href="https://stackoverflow.com/questions/12584143/convert-normal-column-as-partition-column-in-hive">convert normal column as partition column in hive</a>), I want to create a new table to copy all columns except one. I currently have >50 columns in the original table. Is there any clean way of doing that?</p>
  
  <p>Something like: </p>
  
  <p><code>CREATE student_copy LIKE student EXCEPT age and hair_color;</code></p>
  
  <p>Thanks! </p>