Hive
  1. Hive
  2. HIVE-1938

Cost Based Query optimization for Joins in Hive

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Query Processor, Statistics
    • Labels:
      None
    • Environment:

      *nix,java

    • Tags:
      Query optimization . Query processor

      Description

      Current optimization in Hive is just rule-based and involves applying a set of rules on the Plan tree. This depends on hints given by the user (which may or may-not be correct) and might result in execution of costlier plans.So this jira aims at building a cost-model which can give a good estimate various plans before hand (using some meta-data already collected) and we can choose the best plan which incurs the least cost.

        Issue Links

          Activity

          bharath v created issue -
          Namit Jain made changes -
          Field Original Value New Value
          Summary Cost Based Query optimization in Hive Cost Based Query optimization for Joins in Hive
          Namit Jain made changes -
          Assignee bharath v [ bharathv ]
          bharath v made changes -
          Link This issue blocks HIVE-1362 [ HIVE-1362 ]
          bharath v made changes -
          Link This issue blocks HIVE-1362 [ HIVE-1362 ]
          bharath v made changes -
          Link This issue is blocked by HIVE-1362 [ HIVE-1362 ]
          Jeff Hammerbacher made changes -
          Link This issue relates to HIVE-1940 [ HIVE-1940 ]
          Jeff Hammerbacher made changes -
          Link This issue is related to HIVE-33 [ HIVE-33 ]
          Carl Steinbach made changes -
          Component/s Statistics [ 12314312 ]
          Jeff Hammerbacher made changes -
          Link This issue relates to HIVE-3027 [ HIVE-3027 ]
          Carl Steinbach made changes -
          Link This issue is duplicated by HIVE-1940 [ HIVE-1940 ]

            People

            • Assignee:
              bharath v
              Reporter:
              bharath v
            • Votes:
              0 Vote for this issue
              Watchers:
              16 Start watching this issue

              Dates

              • Created:
                Updated:

                Development