| set hive.mapred.mode=nonstrict; |
| -- start query 1 in stream 0 using template query10.tpl and seed 797269820 |
| explain cbo |
| select |
| cd_gender, |
| cd_marital_status, |
| cd_education_status, |
| count(*) cnt1, |
| cd_purchase_estimate, |
| count(*) cnt2, |
| cd_credit_rating, |
| count(*) cnt3, |
| cd_dep_count, |
| count(*) cnt4, |
| cd_dep_employed_count, |
| count(*) cnt5, |
| cd_dep_college_count, |
| count(*) cnt6 |
| from |
| customer c,customer_address ca,customer_demographics |
| where |
| c.c_current_addr_sk = ca.ca_address_sk and |
| ca_county in ('Walker County','Richland County','Gaines County','Douglas County','Dona Ana County') and |
| cd_demo_sk = c.c_current_cdemo_sk and |
| exists (select * |
| from store_sales,date_dim |
| where c.c_customer_sk = ss_customer_sk and |
| ss_sold_date_sk = d_date_sk and |
| d_year = 2002 and |
| d_moy between 4 and 4+3) and |
| (exists (select * |
| from web_sales,date_dim |
| where c.c_customer_sk = ws_bill_customer_sk and |
| ws_sold_date_sk = d_date_sk and |
| d_year = 2002 and |
| d_moy between 4 ANd 4+3) or |
| exists (select * |
| from catalog_sales,date_dim |
| where c.c_customer_sk = cs_ship_customer_sk and |
| cs_sold_date_sk = d_date_sk and |
| d_year = 2002 and |
| d_moy between 4 and 4+3)) |
| group by cd_gender, |
| cd_marital_status, |
| cd_education_status, |
| cd_purchase_estimate, |
| cd_credit_rating, |
| cd_dep_count, |
| cd_dep_employed_count, |
| cd_dep_college_count |
| order by cd_gender, |
| cd_marital_status, |
| cd_education_status, |
| cd_purchase_estimate, |
| cd_credit_rating, |
| cd_dep_count, |
| cd_dep_employed_count, |
| cd_dep_college_count |
| limit 100; |
| |
| -- end query 1 in stream 0 using template query10.tpl |