Major Description
The unix_timestamp function returns values with respect to the SQL session time zone (which is the default JVM time zone). This varies depending on server time zone. This is required by the documentation for the function and would be difficult to change.
For users that want consistent results across zones, Hive should include a utc_timestamp method that is zone independent and gives a result assuming the timestamp without time zone passed in is in UTC.