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

Umbrella JIRA for all subquery redesign related tasks and issues

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

Details

    • Task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Logical Optimizer

    Description

      With HIVE-15192 we are using Calcite's functionality to decorrelate and plan subqueries. This JIRA is to track all planned improvements, tasks and known bugs.

      Attachments

        Issue Links

        relates to

        Bug - A problem which impairs or prevents the functions of the product. HIVE-17726 Using exists may lead to incorrect results

        • Major - Major loss of function.
        • Closed
        1.
        		 Return path failures Sub-task Patch Available Vineet Garg   Actions
        2.
        		 Fix semi-join conversion rule for subquery Sub-task Closed Vineet Garg   Actions
        3.
        		 Use Calcite to de-correlate and plan subqueries Sub-task Closed Vineet Garg   Actions
        4.
        		 Support multiple and nested subqueries Sub-task Closed Vineet Garg   Actions
        5.
        		 Support scalar subqueries Sub-task Closed Vineet Garg   Actions
        6.
        		 Allow multiple queries with disjunction Sub-task Closed Vineet Garg   Actions
        7.
        		 Allow IN/NOT IN correlated subquery with aggregates Sub-task Closed Vineet Garg   Actions
        8.
        		 Allow EXISTS/NOT EXISTS correlated subquery with aggregates Sub-task Closed Krisztian Kasa

        100%
        Original Estimate - Not Specified Original Estimate - Not Specified
        Time Spent - 40m
        		Actions
        9.
        		 Allow correlated scalar subqueries with aggregates which has non-equi join predicates Sub-task Closed Vineet Garg   Actions
        10.
        		 Allow correlated subqueries with windowing clause Sub-task Open Vineet Garg   Actions
        11.
        		 Inefficient plan for correlated subqueries Sub-task Closed Vineet Garg   Actions
        12.
        		 Improve plans for correlated subquery with join and predicate Sub-task Closed Vineet Garg   Actions
        13.
        		 Support subqueries in project/select Sub-task Resolved Vineet Garg   Actions
        14.
        		 Support subqueries in complex expression in SELECT clause Sub-task Closed Vineet Garg   Actions
        15.
        		 Improve plans for scalar subquery with aggregates Sub-task Closed Vineet Garg   Actions
        16.
        		 Improve plan for subquery with EXISTS Sub-task Resolved Krisztian Kasa   Actions
        17.
        		 Improve plans for subqueries with non-equi co-related predicates Sub-task Closed Vineet Garg   Actions
        18.
        		 Enable subquery related Qtests for Hive on Spark Sub-task Closed Dapeng Sun   Actions

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            vgarg Vineet Garg Assign to me
            vgarg Vineet Garg
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0h
              0h
              Logged:
              Time Spent - 40m
              40m

              Slack

                Issue deployment