title: HIVE from.unixtime(...) with Time Zone
body: <p>I set up my Hive in a machine with GMT+8 time zone. Therefore, <code>from_unixtime(946656000)</code> returns <code>2000-01-01 00:00:00</code> instead of <code>1999-12-31 16:30:00</code>. According to the manual, this function returns the date string using the current system time zone. What can I do to get a date string with UTC time zone i.e. <code>1999-12-31 16:30:00</code>?</p>