Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-15338

Wrong result from non-vectorized DATEDIFF with scalar parameter of type DATE/TIMESTAMP

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.3.0
    • Component/s: Hive
    • Labels:
      None

      Description

      Vectorization in vectorized DATEDIFF accidentally treated the scalar parameter is type DATE (e.g. CURRENT_DATE) as 0.
      Current Q file test vectorized_date_funcs.q DOES NOT test the DATE/TIMESTAMP scalar type case.
      And, non-vectorized cases of DATEDIFF are using UTF and returning the wrong results.

        Attachments

        1. HIVE-15338.01.patch
          95 kB
          Matt McCline
        2. HIVE-15338.02.patch
          114 kB
          Matt McCline
        3. HIVE-15338.03.patch
          221 kB
          Matt McCline
        4. HIVE-15338.04.patch
          221 kB
          Matt McCline
        5. HIVE-15338.05.patch
          222 kB
          Matt McCline

          Activity

            People

            • Assignee:
              mmccline Matt McCline
              Reporter:
              mmccline Matt McCline
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: