Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-5775 Introduce Cost Based Optimizer to Hive
  3. HIVE-7655

CBO: Reading of partitioned table stats slows down explain

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.13.1
    • 0.14.0
    • None

    Description

      This defect is due to a regression introduced in https://issues.apache.org/jira/browse/HIVE-7625, explain for queries that touch partitioned tables is 10x slower.

      RelOptHiveTable.getRowCount calls listPartitionsWithAuthInfo which returns the data from all partitions, listPartitionsByExpr should be used instead.

      Attachments

        1. HIVE-7655.1.patch
          0.9 kB
          Harish Butani

        Activity

          People

            rhbutani Harish Butani
            mmokhtar Mostafa Mokhtar
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: