[IMPALA-97] Impala returns "1970-01-01 00:00:00" in from_unixtime(0) , Hive returns "1970-01-01 09:00:00" in Japan

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 0.6
• Fix Version/s: Impala 2.2
• Assignee: casey
• Reporter: Yuki Yoi
• Created: 27/Feb/13 10:07
• Updated: 06/Mar/15 23:41
• Resolved: 25/Feb/15 23:05

Description

Incompatibility between Impala and Hive in Japan( or other timezones except for UTC):

Impala:

select from_unixtime(0);
Query: select from_unixtime(0)
Query finished, fetching results ...
1970-01-01 00:00:00
Returned 1 row(s) in 0.01s

Hive:

select from_unixtime(0) from tmp;         
<snip>
OK
1970-01-01 09:00:00

This is because Hive returns as current system time zone(GMT+9), but Impala returns as UTC.

Issue Links

• is duplicated by: IMPALA-1086 unix_timestamp() returns timestamp relative to local timezone epoch
• is duplicated by: IMPALA-1435 unix_timestamp() default timezone different from Hive or MySQL