I'd try avoid using the Hive inbuilt from_unixtime and unix_timestamp functions. They are buggy, in that they depend on the cluster's timezone. So if some of your cluster nodes have a different timezone than others, these functions suffer.
Right now, for what you want, it probably doesn't matter. But I'm just saying in general.
BTW, Joda Time also has provisions to set/convert timezones :) On Thu, Jun 12, 2014 at 8:34 PM, Krishnan Narayanan < [EMAIL PROTECTED]> wrote:
All projects made searchable here are trademarks of the Apache Software Foundation.
Service operated by Sematext