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

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

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Critical
    • Resolution: Fixed
    • None
    • 2.3.0
    • Hive
    • 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
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            mmccline Matt McCline Assign to me
            mmccline Matt McCline
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment