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

Alternatively use table scan stats for HoS

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

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 2.2.0
    • 2.3.0
    • Spark, Statistics
    • None

    Description

      For MapJoin in HoS, we should provide an option to only use stats in the TS rather than the populated stats in each of the join branch. This could be pretty conservative but more reliable.

      Attachments

        1. HIVE-15489.wip.patch
          9 kB
          Chao Sun
        2. HIVE-15489.1.patch
          9 kB
          Chao Sun
        3. HIVE-15489.2.patch
          9 kB
          Chao Sun
        4. HIVE-15489.3.patch
          9 kB
          Chao Sun
        5. HIVE-15489.6.patch
          10 kB
          Chao Sun
        6. HIVE-15489.7.patch
          24 kB
          Chao Sun

        Issue Links

        is related to

        Bug - A problem which impairs or prevents the functions of the product. HIVE-16336 Rename hive.spark.use.file.size.for.mapjoin to hive.spark.use.ts.stats.for.mapjoin

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

        Bug - A problem which impairs or prevents the functions of the product. HIVE-16328 HoS: more aggressive mapjoin optimization when hive.spark.use.ts.stats.for.mapjoin is true

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. HIVE-16336 Rename hive.spark.use.file.size.for.mapjoin to hive.spark.use.ts.stats.for.mapjoin

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. HIVE-16698 HoS should avoid mapjoin optimization in case of union and using table stats

        • Major - Major loss of function.
        • Closed

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

          People

            csun Chao Sun Assign to me
            csun Chao Sun
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment