[IMPALA-1623] unix_timestamp() does not return correct time

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 2.0.1
• Fix Version/s: Impala 2.2
• Labels: correctness impala
• Environment: > version;; Shell version: Impala Shell v2.0.1-cdh5 (cc09df0) built on Wed Nov 19 10:57:34 PST 2014; Server version: impalad version 2.0.1-cdh5 RELEASE (build cc09df07d93c79351052eef2f4e5baf52373dc33)
• Assignee: casey
• Reporter: Sujit Chaubal
• Created: 18/Dec/14 22:54
• Updated: 20/Dec/15 00:05
• Resolved: 05/Feb/15 19:23

Description

Impala:
> select unix_timestamp();
Query: select unix_timestamp()
------------------

unix_timestamp()

------------------

1

------------------
Fetched 1 row(s) in 0.01s

Hive:
hive> select unix_timestamp();
Total jobs = 1
Launching Job 1 out of 1
--snip--
Stage-Stage-1: Map: 1 Cumulative CPU: 3.54 sec HDFS Read: 270 HDFS Write: 11 SUCCESS
Total MapReduce CPU Time Spent: 3 seconds 540 msec
OK
1418942092

i.e unixtime() returns incorrect value/time.