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

Impala returns 0 for bad time values in UNIX_TIMESTAMP, Hive returns NULL

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: Impala 0.3
    • Fix Version/s: Impala 1.0.1
    • Component/s: None
    • Labels:
      None

      Description

      Minor incompatibiliy between Impala and Hive:

      Impala:

      select UNIX_TIMESTAMP('10:02:01') ;
      Query: select UNIX_TIMESTAMP('10:02:01')
      Query finished, fetching results ...
      0
      Returned 1 row(s) in 0.01s
      

      Hive:

      hive> select UNIX_TIMESTAMP('10:02:01') FROM tmp;
      <snip>
      OK
      NULL
      

      In the code, we should probably check if (tv->date().is_special()) in both branches of TimestampFunctions::Unix.

        Attachments

          Activity

            People

            • Assignee:
              skye Skye Wanderman-Milne
              Reporter:
              henryr Henry Robinson
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: