Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-17129 Support statistics collection and cardinality estimation for partitioned tables
  3. SPARK-15616

CatalogRelation should fallback to HDFS size of partitions that are involved in Query if statistics are not available.

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 2.3.0
    • 3.0.0
    • SQL
    • None

    Description

      Currently if some partitions of a partitioned table are used in join operation we rely on Metastore returned size of table to calculate if we can convert the operation to Broadcast join.
      if Filter can prune some partitions, Hive can prune partition before determining to use broadcast joins according to HDFS size of partitions that are involved in Query.So sparkSQL needs it that can improve join's performance for partitioned table.

      Attachments

        Issue Links

          Activity

            People

              wwg28103 Hu Fuwang
              lianhuiwang Lianhui Wang
              Votes:
              1 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: