title: Hive- how do I "create table as select.." with partitions from original table?
body: <p>I need to create a "work table" from our hive dlk. While I can use: </p>
  
  <pre><code>create table my_table as
  select *
  from dlk.big_table
  </code></pre>
  
  <p>just fine, I have problem with carrying over partitions (attributes <code>day</code>, <code>month</code> and <code>year</code>) from original "big_table" or just creating new ones from these attributes.
  Searching the web did not really helped me answer this question- all "tutorials" or solutions deal either with <code>create as select</code> OR creating partitions, never both.
  Can anybody here please help?</p>