| set hive.mapred.mode=nonstrict; |
| -- start query 1 in stream 0 using template query52.tpl and seed 1819994127 |
| explain cbo |
| select dt.d_year |
| ,item.i_brand_id brand_id |
| ,item.i_brand brand |
| ,sum(ss_ext_sales_price) ext_price |
| from date_dim dt |
| ,store_sales |
| ,item |
| where dt.d_date_sk = store_sales.ss_sold_date_sk |
| and store_sales.ss_item_sk = item.i_item_sk |
| and item.i_manager_id = 1 |
| and dt.d_moy=12 |
| and dt.d_year=1998 |
| group by dt.d_year |
| ,item.i_brand |
| ,item.i_brand_id |
| order by dt.d_year |
| ,ext_price desc |
| ,brand_id |
| limit 100 ; |
| |
| -- end query 1 in stream 0 using template query52.tpl |
