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

Bring query optimization time down

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

    Description

      Umbrella JIRA to track the effort to bring optimization time of queries down.

      Attachments

        Issue Links

        1.
        Disable Hive PPD optimizer when CBO has optimized the plan Sub-task Closed Jesús Camacho Rodríguez Actions
        2.
        Disable Hive ConstantPropagate optimizer when CBO has optimized the plan Sub-task Closed Jesús Camacho Rodríguez Actions
        3.
        Disable Hive ColumnPruner optimizer when CBO has optimized the plan Sub-task Open Unassigned Actions
        4.
        Disable Hive ConstantPropagate optimizer when CBO has optimized the plan II Sub-task Closed Jesús Camacho Rodríguez Actions
        5.
        Fold CASE into NVL when CBO optimized the plan Sub-task Closed Jesús Camacho Rodríguez Actions
        6.
        CBO rule to pull up constants through Sort/Limit Sub-task Closed Jesús Camacho Rodríguez Actions
        7.
        CBO rule to pull up constants through Union Sub-task Closed Jesús Camacho Rodríguez Actions
        8.
        Disable Hive PartitionConditionRemover optimizer when CBO has optimized the plan Sub-task Open Unassigned Actions
        9.
        Add flag to detect constants to CBO pull up rules Sub-task Closed Jesús Camacho Rodríguez Actions
        10.
        More aggressive inference of transitive predicates for inner joins Sub-task Closed Jesús Camacho Rodríguez Actions
        11.
        Propagate constant expressions through insert Sub-task Open Remus Rusanu Actions
        12.
        Extend HiveSortLimitPullUpConstantsRule to pull up constants even when SortLimit is the root of the plan Sub-task Open Remus Rusanu Actions
        13.
        Extension to folding NOT expressions in CBO Sub-task Closed Jesús Camacho Rodríguez Actions
        14.
        Extend metadata provider to pull up predicates through Union Sub-task Closed Jesús Camacho Rodríguez Actions
        15.
        Use constant expressions to backtrack when we create ReduceSink Sub-task Closed Jesús Camacho Rodríguez Actions
        16.
        Constant not removed in index_auto_unused.q.out Sub-task Open Remus Rusanu Actions
        17.
        Improve logic to infer false predicates Sub-task Closed Jesús Camacho Rodríguez Actions
        18.
        Infer constants directly when we create semijoin Sub-task Open Remus Rusanu Actions
        19.
        Correctness of CASE folding in the presence of NULL values Sub-task Closed Jesús Camacho Rodríguez Actions

        Activity

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

          People

            Unassigned Unassigned Assign to me
            jcamacho Jesús Camacho Rodríguez

            Dates

              Created:
              Updated:

              Slack

                Issue deployment