XMLWordPrintableJSON

    Details

      Description

      With HIVE-15544 IN/NOT IN correlated subqueries with aggregates were disabled since re-writting them into JOIN could have produced wrong result.
      Wrong results would occur if subquery produces zero row, since aggregate always produce result lower such query into LEFT JOIN or SEMI JOIN would not take these case into consideration.

      We propose to allow such queries with an added run time check which will throw an error/exception if subquery produces zero row.

        Attachments

        1. HIVE-15721.2.patch
          283 kB
          Vineet Garg
        2. HIVE-15721.1.patch
          283 kB
          Vineet Garg

          Issue Links

            Activity

              People

              • Assignee:
                vgarg Vineet Garg
                Reporter:
                vgarg Vineet Garg
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: