Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-482

Implement SQL and planner hints

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.21.0
    • 1.22.0
    • core

    Description

      Query optimizer can never be perfect, so it makes sense to implement hints to allow user better control the execution.

      For instance: "never merge this subquery with others" (`/+ no_merge/`), "treat those tables as leading ones" (`/*+ leading */`), etc.
      Hints would enable predictable performance and the planning time would be improved as well.

      Attachments

        Issue Links

          duplicates

          Sub-task - The sub-task of the issue CALCITE-495 Support hints to be passed through select/DML commands

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-299 Divide the join graph into partitions that can be optimized separately

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-481 Add "Spool" operator, to allow re-use of relational expressions

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. CALCITE-5188 Review (and improve?) hints

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-3519 `inheritPath` of `RelHint` represented by `ImmutableBitSet` may be incomplete.

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-3940 Hint item can not parse correctly if the name is right after token "/*+"

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-4899 Support hint for lateral table syntax

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-3518 Use List instead of BitSet to keep inheritPath in RelHint

          • Major - Major loss of function.
          • Closed
          links to

          Web Link GitHub Pull Request #1354

          Web Link Implement SQL and Planner Hints In Calcite

          1.
          		 Strengthen the java doc and code of class RelHint and SqlHint Sub-task Closed Danny Chen

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 20m
          2.
          		 Enrich tests for SQL hints in SqlHintsConverterTest Sub-task Closed Danny Chen

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 2h
          3.
          		 Propagate hints when decorrelating a query Sub-task Closed Danny Chen

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 1h
          4.
          		 Support SQL hints for Aggregate Sub-task Closed Shuo Cheng

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 1h 40m
          5.
          		 Support hot Groupby keys hint Sub-task Closed Rui Wang

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 0.5h
          6.
          		 Support SQL hints for Calc Sub-task Closed Shuo Cheng

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 0.5h
          7.
          		 Support Hint for Sort Sub-task Open Unassigned

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 20m
          8.
          		 Reduce ambiguous hint strategies Sub-task Closed Rui Wang  
          9.
          		 Supports hint option as string or numeric literal Sub-task Closed Danny Chen

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 1h
          10.
          		 Hints should be propagated correctly in planner rules if original node is transformed to different kind Sub-task Closed Danny Chen

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 2.5h
          11.
          		 Add an interface to pass the table hints to RelOptTable Sub-task Closed Danny Chen

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 1h
          12.
          		 Add hint option checker to customize the option validation Sub-task Closed Danny Chen

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 2h 40m
          13.
          		 Following the change to add hints to RelNode, deprecate the old constructors Sub-task Closed Danny Chen

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 20m
          14.
          		 Add hints to RelBuilder Sub-task Closed Danny Chen

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 50m
          15.
          		 Add an interface in RelOptRuleCall to customize the propagation of hints before registering into planner rule Sub-task Closed Danny Chen

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 20m
          16.
          		 Add a Builder to RelHint Sub-task Closed Danny Chen

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 20m
          17.
          		 HintStrategy can specify excluded rules for planner Sub-task Closed Danny Chen

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 40m
          18.
          		 Refactor HintStrategy to HintPredicate Sub-task Closed Danny Chen

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 40m
          19.
          		 Support hint option key as string literal Sub-task Closed Danny Chen

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 20m

          Activity

            People

              danny0405 Danny Chen
              vladimirsitnikov Vladimir Sitnikov
              Votes:
              1 Vote for this issue
              Watchers:
              21 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

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