title: How can I partition a hive table by (only) a portion of a timestamp column?
body: <p>Assume I have a Hive table that includes a TIMESTAMP column that is frequently (almost always) included in the WHERE clauses of a query.  It makes sense to partition this table by the TIMESTAMP field; however, to keep to a reasonable cardinality, it makes sense to partition by day (not by the maximum resolution of the TIMESTAMP).</p>
  
  <p>What's the best way to achieve this?  Should I create an additional column (DATE) and partition on that?  Or is there a way to achieve the partition without creating a duplicate column?</p>