Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-1623

unix_timestamp() does not return correct time

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: Impala 2.0.1
    • Fix Version/s: Impala 2.2
    • Component/s: None
    • 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)

      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.

        Attachments

          Activity

            People

            • Assignee:
              caseyc casey
              Reporter:
              sujitc_impala_12b4 Sujit Chaubal
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: