HIVE - date_format( your_date_column, '%Y-%m-%d %H' )
<p>I'm trying to achieve the MySQL equivalent of <code>date_format( your_date_column, '%Y-%m-%d %H' ) as my_date</code> in Hive. I've tried a few options from <a href="http://www.folkstalk.com/2011/11/date-functions-in-hive.html" rel="nofollow">Hive date formatting</a> but can't get the format right. I haven't found anything that has helped me yet.</p>

<p>Could I please request someone who may have already bumped into this situation or knows how to do it please?</p>