XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 3.0.0
    • 4.0.0-alpha-1
    • llap, Transactions
    • None

    Description

      Consider

      select ROW__ID, count(*) from over10k_orc_bucketed group by ROW__ID having count(*) > 1;
      

      in acid_vectorization_original.q (available since HIVE-17458)

      when run using TestMiniLlapCliDriver produces "NULL, N" where N varies from run to run.
      The right answer is empty results set as can be seen by running

      select ROW__ID, * from over10k_orc_bucketed where ROW__ID is null
      

      in the same test.

      This is with

      set hive.vectorized.execution.enabled=true;
      set hive.vectorized.row.identifier.enabled=true;
      

      It fails with TestMiniLlapCliDriver but not TestMiniTezCliDriver. See acid_vectorization_original_tez.q which has identical query.

      Attachments

        1. HIVE-17921.2.patch
          2 kB
          Saurabh Seth
        2. HIVE-17921.patch
          8 kB
          Saurabh Seth

        Activity

          People

            saurabhseth Saurabh Seth
            ekoifman Eugene Koifman
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: