title: Partitioning a Delta Table by a subset of date column
body: <p>I am creating a Delta Table in Databricks that contains 1 day worth of proxy logs (100s of millions of lines). I want to be able to partition the table by hour, so simply partitioning the table by '_time' column is not good enough. Also, I am using the %sql runtime to create the table in my notebook but I am open to creating it in scala if that is a better option.</p>
  
  <p>How can I create partition logic such that a new partition is created for each hours worth of logs?</p>
  
  <p>The format of my _time column is as follows.</p>
  
  <p>yyyy-mm-ddThh:mm:ss.xxxxxx-time:zone where time and zone are 2 digits.</p>
  
  <p>So, I would like to partition for every unique hour, giving me 24 partitions for a day, like so.</p>
  
  <p>yyyy-mm-ddThh</p>