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

Bring query optimization time down

    XMLWordPrintableJSON

Details

    Description

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

      Attachments

        Issue Links

          is related to

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-9132 CBO: Calcite Operator To Hive Operator (Calcite Return Path)

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

          Activity

            People

              Unassigned Unassigned
              jcamacho Jesús Camacho Rodríguez
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated: