Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-7122

TPCDS queries 29 25 17 are slower when Statistics is disabled.

    XMLWordPrintableJSON

    Details

      Description

      Here is query 29 with sf 100:

      SELECT i_item_id, 
                     i_item_desc, 
                     s_store_id, 
                     s_store_name, 
                     Avg(ss_quantity)        AS store_sales_quantity, 
                     Avg(sr_return_quantity) AS store_returns_quantity, 
                     Avg(cs_quantity)        AS catalog_sales_quantity 
      FROM   store_sales, 
             store_returns, 
             catalog_sales, 
             date_dim d1, 
             date_dim d2, 
             date_dim d3, 
             store, 
             item 
      WHERE  d1.d_moy = 4 
             AND d1.d_year = 1998 
             AND d1.d_date_sk = ss_sold_date_sk 
             AND i_item_sk = ss_item_sk 
             AND s_store_sk = ss_store_sk 
             AND ss_customer_sk = sr_customer_sk 
             AND ss_item_sk = sr_item_sk 
             AND ss_ticket_number = sr_ticket_number 
             AND sr_returned_date_sk = d2.d_date_sk 
             AND d2.d_moy BETWEEN 4 AND 4 + 3 
             AND d2.d_year = 1998 
             AND sr_customer_sk = cs_bill_customer_sk 
             AND sr_item_sk = cs_item_sk 
             AND cs_sold_date_sk = d3.d_date_sk 
             AND d3.d_year IN ( 1998, 1998 + 1, 1998 + 2 ) 
      GROUP  BY i_item_id, 
                i_item_desc, 
                s_store_id, 
                s_store_name 
      ORDER  BY i_item_id, 
                i_item_desc, 
                s_store_id, 
                s_store_name
      LIMIT 100; 
      

      The hash join order has changed. As a result, one of the hash joins does not seem to reduce the number of rows significantly.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                gparai Gautam Parai
                Reporter:
                rhou Robert Hou
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: