[TAJO-1445] Optimizer removes some filter in where clause. - ASF JIRA

XML

Word

Printable

JSON

Details

Type: Bug
Status: Resolved
Priority: Minor
Resolution: Duplicate
Affects Version/s: None
Fix Version/s: 0.11.0
Component/s: None
Labels:
None

Description

select ca_zip
       ,sum(cs_sales_price)
 from catalog_sales
     ,customer
     ,customer_address
     ,date_dim
 where cs_bill_customer_sk = c_customer_sk
   and c_current_addr_sk = ca_address_sk 
   and ( substr(ca_zip,1,5) in ('85669', '86197','88274','83405','86475',
                                   '85392', '85460', '80348', '81792')
         or ca_state in ('CA','WA','GA')
         or cs_sales_price > 500)
   and cs_sold_date_sk = d_date_sk
   and d_qoy = 2 and d_year = 2000
 group by ca_zip
 order by ca_zip
limit 100;

The above query is TPC-DS query15. The logical planner generates the plan as the following. Some filters are in the SELECTION(4) but after optimizing there are no filters in the plan. Optimizer may removes some filters.

PROJECTION(8)
  => Targets: tpcds.customer_address.ca_zip (TEXT), ?sum (FLOAT8)
  => out schema: {(2) tpcds.customer_address.ca_zip (TEXT), ?sum (FLOAT8)}
  => in  schema: {(2) tpcds.customer_address.ca_zip (TEXT), ?sum (FLOAT8)}
   LIMIT(7) 100
      SORT(6)
        => Sort Keys: tpcds.customer_address.ca_zip (TEXT) (asc)
         GROUP_BY(5)(ca_zip)
           => exprs: (sum(tpcds.catalog_sales.cs_sales_price (FLOAT4)))
           => target list: tpcds.customer_address.ca_zip (TEXT), ?sum (FLOAT8)
           => out schema:{(2) tpcds.customer_address.ca_zip (TEXT), ?sum (FLOAT8)}
           => in schema:{(95) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT), tpcds.customer_address.ca_zip (TEXT), ?and_1 (BOOLEAN), tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), ?fake0 (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT), tpcds.date_dim.d_date_sk (INT4), tpcds.date_dim.d_date_id (TEXT), tpcds.date_dim.d_date (DATE), tpcds.date_dim.d_month_seq (INT4), tpcds.date_dim.d_week_seq (INT4), tpcds.date_dim.d_quarter_seq (INT4), tpcds.date_dim.d_year (INT4), tpcds.date_dim.d_dow (INT4), tpcds.date_dim.d_moy (INT4), tpcds.date_dim.d_dom (INT4), tpcds.date_dim.d_qoy (INT4), tpcds.date_dim.d_fy_year (INT4), tpcds.date_dim.d_fy_quarter_seq (INT4), tpcds.date_dim.d_fy_week_seq (INT4), tpcds.date_dim.d_day_name (TEXT), tpcds.date_dim.d_quarter_name (TEXT), tpcds.date_dim.d_holiday (TEXT), tpcds.date_dim.d_weekend (TEXT), tpcds.date_dim.d_following_holiday (TEXT), tpcds.date_dim.d_first_dom (INT4), tpcds.date_dim.d_last_dom (INT4), tpcds.date_dim.d_same_day_ly (INT4), tpcds.date_dim.d_same_day_lq (INT4), tpcds.date_dim.d_current_day (TEXT), tpcds.date_dim.d_current_week (TEXT), tpcds.date_dim.d_current_month (TEXT), tpcds.date_dim.d_current_quarter (TEXT), tpcds.date_dim.d_current_year (TEXT)}
            SELECTION(4)
              => Search Cond: tpcds.catalog_sales.cs_bill_customer_sk (INT4) = tpcds.customer.c_customer_sk (INT4) AND tpcds.customer.c_current_addr_sk (INT4) = tpcds.customer_address.ca_address_sk (INT4) AND substr(tpcds.customer_address.ca_zip (TEXT),1,5) IN (85669, 86197, 88274, 83405, 86475, 85392, 85460, 80348, 81792) OR tpcds.customer_address.ca_state (TEXT) IN (CA, WA, GA) OR tpcds.catalog_sales.cs_sales_price (FLOAT4) > 500.0 AND tpcds.catalog_sales.cs_sold_date_sk (INT4) = tpcds.date_dim.d_date_sk (INT4) AND tpcds.date_dim.d_qoy (INT4) = 2 AND tpcds.date_dim.d_year (INT4) = 2000
               JOIN(11)(CROSS)
                 => target list: tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT), tpcds.customer_address.ca_zip (TEXT), ?and_1 (BOOLEAN), tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), ?fake0 (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT), tpcds.date_dim.d_date_sk (INT4), tpcds.date_dim.d_date_id (TEXT), tpcds.date_dim.d_date (DATE), tpcds.date_dim.d_month_seq (INT4), tpcds.date_dim.d_week_seq (INT4), tpcds.date_dim.d_quarter_seq (INT4), tpcds.date_dim.d_year (INT4), tpcds.date_dim.d_dow (INT4), tpcds.date_dim.d_moy (INT4), tpcds.date_dim.d_dom (INT4), tpcds.date_dim.d_qoy (INT4), tpcds.date_dim.d_fy_year (INT4), tpcds.date_dim.d_fy_quarter_seq (INT4), tpcds.date_dim.d_fy_week_seq (INT4), tpcds.date_dim.d_day_name (TEXT), tpcds.date_dim.d_quarter_name (TEXT), tpcds.date_dim.d_holiday (TEXT), tpcds.date_dim.d_weekend (TEXT), tpcds.date_dim.d_following_holiday (TEXT), tpcds.date_dim.d_first_dom (INT4), tpcds.date_dim.d_last_dom (INT4), tpcds.date_dim.d_same_day_ly (INT4), tpcds.date_dim.d_same_day_lq (INT4), tpcds.date_dim.d_current_day (TEXT), tpcds.date_dim.d_current_week (TEXT), tpcds.date_dim.d_current_month (TEXT), tpcds.date_dim.d_current_quarter (TEXT), tpcds.date_dim.d_current_year (TEXT)
                 => out schema: {(95) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT), tpcds.customer_address.ca_zip (TEXT), ?and_1 (BOOLEAN), tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), ?fake0 (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT), tpcds.date_dim.d_date_sk (INT4), tpcds.date_dim.d_date_id (TEXT), tpcds.date_dim.d_date (DATE), tpcds.date_dim.d_month_seq (INT4), tpcds.date_dim.d_week_seq (INT4), tpcds.date_dim.d_quarter_seq (INT4), tpcds.date_dim.d_year (INT4), tpcds.date_dim.d_dow (INT4), tpcds.date_dim.d_moy (INT4), tpcds.date_dim.d_dom (INT4), tpcds.date_dim.d_qoy (INT4), tpcds.date_dim.d_fy_year (INT4), tpcds.date_dim.d_fy_quarter_seq (INT4), tpcds.date_dim.d_fy_week_seq (INT4), tpcds.date_dim.d_day_name (TEXT), tpcds.date_dim.d_quarter_name (TEXT), tpcds.date_dim.d_holiday (TEXT), tpcds.date_dim.d_weekend (TEXT), tpcds.date_dim.d_following_holiday (TEXT), tpcds.date_dim.d_first_dom (INT4), tpcds.date_dim.d_last_dom (INT4), tpcds.date_dim.d_same_day_ly (INT4), tpcds.date_dim.d_same_day_lq (INT4), tpcds.date_dim.d_current_day (TEXT), tpcds.date_dim.d_current_week (TEXT), tpcds.date_dim.d_current_month (TEXT), tpcds.date_dim.d_current_quarter (TEXT), tpcds.date_dim.d_current_year (TEXT)}
                 => in schema: {(95) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT), tpcds.customer_address.ca_zip (TEXT), ?and_1 (BOOLEAN), tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), ?fake0 (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT), tpcds.date_dim.d_date_sk (INT4), tpcds.date_dim.d_date_id (TEXT), tpcds.date_dim.d_date (DATE), tpcds.date_dim.d_month_seq (INT4), tpcds.date_dim.d_week_seq (INT4), tpcds.date_dim.d_quarter_seq (INT4), tpcds.date_dim.d_year (INT4), tpcds.date_dim.d_dow (INT4), tpcds.date_dim.d_moy (INT4), tpcds.date_dim.d_dom (INT4), tpcds.date_dim.d_qoy (INT4), tpcds.date_dim.d_fy_year (INT4), tpcds.date_dim.d_fy_quarter_seq (INT4), tpcds.date_dim.d_fy_week_seq (INT4), tpcds.date_dim.d_day_name (TEXT), tpcds.date_dim.d_quarter_name (TEXT), tpcds.date_dim.d_holiday (TEXT), tpcds.date_dim.d_weekend (TEXT), tpcds.date_dim.d_following_holiday (TEXT), tpcds.date_dim.d_first_dom (INT4), tpcds.date_dim.d_last_dom (INT4), tpcds.date_dim.d_same_day_ly (INT4), tpcds.date_dim.d_same_day_lq (INT4), tpcds.date_dim.d_current_day (TEXT), tpcds.date_dim.d_current_week (TEXT), tpcds.date_dim.d_current_month (TEXT), tpcds.date_dim.d_current_quarter (TEXT), tpcds.date_dim.d_current_year (TEXT)}
                  SCAN(3) on tpcds.date_dim
                    => target list: tpcds.date_dim.d_date_sk (INT4), tpcds.date_dim.d_date_id (TEXT), tpcds.date_dim.d_date (DATE), tpcds.date_dim.d_month_seq (INT4), tpcds.date_dim.d_week_seq (INT4), tpcds.date_dim.d_quarter_seq (INT4), tpcds.date_dim.d_year (INT4), tpcds.date_dim.d_dow (INT4), tpcds.date_dim.d_moy (INT4), tpcds.date_dim.d_dom (INT4), tpcds.date_dim.d_qoy (INT4), tpcds.date_dim.d_fy_year (INT4), tpcds.date_dim.d_fy_quarter_seq (INT4), tpcds.date_dim.d_fy_week_seq (INT4), tpcds.date_dim.d_day_name (TEXT), tpcds.date_dim.d_quarter_name (TEXT), tpcds.date_dim.d_holiday (TEXT), tpcds.date_dim.d_weekend (TEXT), tpcds.date_dim.d_following_holiday (TEXT), tpcds.date_dim.d_first_dom (INT4), tpcds.date_dim.d_last_dom (INT4), tpcds.date_dim.d_same_day_ly (INT4), tpcds.date_dim.d_same_day_lq (INT4), tpcds.date_dim.d_current_day (TEXT), tpcds.date_dim.d_current_week (TEXT), tpcds.date_dim.d_current_month (TEXT), tpcds.date_dim.d_current_quarter (TEXT), tpcds.date_dim.d_current_year (TEXT)
                    => out schema: {(28) tpcds.date_dim.d_date_sk (INT4), tpcds.date_dim.d_date_id (TEXT), tpcds.date_dim.d_date (DATE), tpcds.date_dim.d_month_seq (INT4), tpcds.date_dim.d_week_seq (INT4), tpcds.date_dim.d_quarter_seq (INT4), tpcds.date_dim.d_year (INT4), tpcds.date_dim.d_dow (INT4), tpcds.date_dim.d_moy (INT4), tpcds.date_dim.d_dom (INT4), tpcds.date_dim.d_qoy (INT4), tpcds.date_dim.d_fy_year (INT4), tpcds.date_dim.d_fy_quarter_seq (INT4), tpcds.date_dim.d_fy_week_seq (INT4), tpcds.date_dim.d_day_name (TEXT), tpcds.date_dim.d_quarter_name (TEXT), tpcds.date_dim.d_holiday (TEXT), tpcds.date_dim.d_weekend (TEXT), tpcds.date_dim.d_following_holiday (TEXT), tpcds.date_dim.d_first_dom (INT4), tpcds.date_dim.d_last_dom (INT4), tpcds.date_dim.d_same_day_ly (INT4), tpcds.date_dim.d_same_day_lq (INT4), tpcds.date_dim.d_current_day (TEXT), tpcds.date_dim.d_current_week (TEXT), tpcds.date_dim.d_current_month (TEXT), tpcds.date_dim.d_current_quarter (TEXT), tpcds.date_dim.d_current_year (TEXT)}
                    => in schema: {(28) tpcds.date_dim.d_date_sk (INT4), tpcds.date_dim.d_date_id (TEXT), tpcds.date_dim.d_date (DATE), tpcds.date_dim.d_month_seq (INT4), tpcds.date_dim.d_week_seq (INT4), tpcds.date_dim.d_quarter_seq (INT4), tpcds.date_dim.d_year (INT4), tpcds.date_dim.d_dow (INT4), tpcds.date_dim.d_moy (INT4), tpcds.date_dim.d_dom (INT4), tpcds.date_dim.d_qoy (INT4), tpcds.date_dim.d_fy_year (INT4), tpcds.date_dim.d_fy_quarter_seq (INT4), tpcds.date_dim.d_fy_week_seq (INT4), tpcds.date_dim.d_day_name (TEXT), tpcds.date_dim.d_quarter_name (TEXT), tpcds.date_dim.d_holiday (TEXT), tpcds.date_dim.d_weekend (TEXT), tpcds.date_dim.d_following_holiday (TEXT), tpcds.date_dim.d_first_dom (INT4), tpcds.date_dim.d_last_dom (INT4), tpcds.date_dim.d_same_day_ly (INT4), tpcds.date_dim.d_same_day_lq (INT4), tpcds.date_dim.d_current_day (TEXT), tpcds.date_dim.d_current_week (TEXT), tpcds.date_dim.d_current_month (TEXT), tpcds.date_dim.d_current_quarter (TEXT), tpcds.date_dim.d_current_year (TEXT)}
                  JOIN(10)(CROSS)
                    => target list: tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT), tpcds.customer_address.ca_zip (TEXT), ?and_1 (BOOLEAN), tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), ?fake0 (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT)
                    => out schema: {(67) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT), tpcds.customer_address.ca_zip (TEXT), ?and_1 (BOOLEAN), tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), ?fake0 (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT)}
                    => in schema: {(67) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT), tpcds.customer_address.ca_zip (TEXT), ?and_1 (BOOLEAN), tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), ?fake0 (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT)}
                     SCAN(2) on tpcds.customer_address
                       => target list: tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), tpcds.customer_address.ca_zip (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT)
                       => out schema: {(13) tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), tpcds.customer_address.ca_zip (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT)}
                       => in schema: {(13) tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), tpcds.customer_address.ca_zip (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT)}
                     JOIN(9)(CROSS)
                       => target list: tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT), tpcds.customer_address.ca_zip (TEXT), tpcds.catalog_sales.cs_bill_customer_sk (INT4) = tpcds.customer.c_customer_sk (INT4) AND tpcds.customer.c_current_addr_sk (INT4) = tpcds.customer_address.ca_address_sk (INT4) AND substr(tpcds.customer_address.ca_zip (TEXT),1,5) IN (85669, 86197, 88274, 83405, 86475, 85392, 85460, 80348, 81792) OR tpcds.customer_address.ca_state (TEXT) IN (CA, WA, GA) OR tpcds.catalog_sales.cs_sales_price (FLOAT4) > 500.0 AND tpcds.catalog_sales.cs_sold_date_sk (INT4) = tpcds.date_dim.d_date_sk (INT4) AND tpcds.date_dim.d_qoy (INT4) = 2 AND tpcds.date_dim.d_year (INT4) = 2000 as ?and_1
                       => out schema: {(54) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT), tpcds.customer_address.ca_zip (TEXT), ?and_1 (BOOLEAN)}
                       => in schema: {(52) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT)}
                        SCAN(1) on tpcds.customer
                          => target list: tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT)
                          => out schema: {(18) tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT)}
                          => in schema: {(18) tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT)}
                        SCAN(0) on tpcds.catalog_sales
                          => target list: tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4)
                          => out schema: {(34) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4)}
                          => in schema: {(34) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4)}

The next plan is generated by Optimizer.

LIMIT(7) 100
   SORT(6)
     => Sort Keys: tpcds.customer_address.ca_zip (TEXT) (asc)
      GROUP_BY(5)(ca_zip)
        => exprs: (sum(tpcds.catalog_sales.cs_sales_price (FLOAT4)))
        => target list: tpcds.customer_address.ca_zip (TEXT), ?sum (FLOAT8)
        => out schema:{(2) tpcds.customer_address.ca_zip (TEXT), ?sum (FLOAT8)}
        => in schema:{(2) tpcds.customer_address.ca_zip (TEXT), tpcds.catalog_sales.cs_sales_price (FLOAT4)}
         JOIN(15)(INNER)
           => Join Cond: tpcds.catalog_sales.cs_bill_customer_sk (INT4) = tpcds.customer.c_customer_sk (INT4)
           => target list: tpcds.customer_address.ca_zip (TEXT), tpcds.catalog_sales.cs_sales_price (FLOAT4)
           => out schema: {(2) tpcds.customer_address.ca_zip (TEXT), tpcds.catalog_sales.cs_sales_price (FLOAT4)}
           => in schema: {(4) tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.customer_address.ca_zip (TEXT), tpcds.customer.c_customer_sk (INT4)}
            JOIN(13)(INNER)
              => Join Cond: tpcds.customer.c_current_addr_sk (INT4) = tpcds.customer_address.ca_address_sk (INT4)
              => target list: tpcds.customer_address.ca_zip (TEXT), tpcds.customer.c_customer_sk (INT4)
              => out schema: {(2) tpcds.customer_address.ca_zip (TEXT), tpcds.customer.c_customer_sk (INT4)}
              => in schema: {(4) tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer_address.ca_zip (TEXT), tpcds.customer_address.ca_address_sk (INT4)}
               SCAN(2) on tpcds.customer_address
                 => target list: tpcds.customer_address.ca_zip (TEXT), tpcds.customer_address.ca_address_sk (INT4)
                 => out schema: {(2) tpcds.customer_address.ca_zip (TEXT), tpcds.customer_address.ca_address_sk (INT4)}
                 => in schema: {(13) tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), tpcds.customer_address.ca_zip (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT)}
               SCAN(1) on tpcds.customer
                 => target list: tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_current_addr_sk (INT4)
                 => out schema: {(2) tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_current_addr_sk (INT4)}
                 => in schema: {(18) tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT)}
            JOIN(14)(INNER)
              => Join Cond: tpcds.catalog_sales.cs_sold_date_sk (INT4) = tpcds.date_dim.d_date_sk (INT4)
              => target list: tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_sales_price (FLOAT4)
              => out schema: {(2) tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_sales_price (FLOAT4)}
              => in schema: {(4) tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.date_dim.d_date_sk (INT4)}
               SCAN(3) on tpcds.date_dim
                 => filter: tpcds.date_dim.d_year (INT4) = 2000 AND tpcds.date_dim.d_qoy (INT4) = 2
                 => target list: tpcds.date_dim.d_date_sk (INT4)
                 => out schema: {(1) tpcds.date_dim.d_date_sk (INT4)}
                 => in schema: {(28) tpcds.date_dim.d_date_sk (INT4), tpcds.date_dim.d_date_id (TEXT), tpcds.date_dim.d_date (DATE), tpcds.date_dim.d_month_seq (INT4), tpcds.date_dim.d_week_seq (INT4), tpcds.date_dim.d_quarter_seq (INT4), tpcds.date_dim.d_year (INT4), tpcds.date_dim.d_dow (INT4), tpcds.date_dim.d_moy (INT4), tpcds.date_dim.d_dom (INT4), tpcds.date_dim.d_qoy (INT4), tpcds.date_dim.d_fy_year (INT4), tpcds.date_dim.d_fy_quarter_seq (INT4), tpcds.date_dim.d_fy_week_seq (INT4), tpcds.date_dim.d_day_name (TEXT), tpcds.date_dim.d_quarter_name (TEXT), tpcds.date_dim.d_holiday (TEXT), tpcds.date_dim.d_weekend (TEXT), tpcds.date_dim.d_following_holiday (TEXT), tpcds.date_dim.d_first_dom (INT4), tpcds.date_dim.d_last_dom (INT4), tpcds.date_dim.d_same_day_ly (INT4), tpcds.date_dim.d_same_day_lq (INT4), tpcds.date_dim.d_current_day (TEXT), tpcds.date_dim.d_current_week (TEXT), tpcds.date_dim.d_current_month (TEXT), tpcds.date_dim.d_current_quarter (TEXT), tpcds.date_dim.d_current_year (TEXT)}
               SCAN(0) on tpcds.catalog_sales
                 => target list: tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_sold_date_sk (INT4)
                 => out schema: {(3) tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_sold_date_sk (INT4)}
                 => in schema: {(34) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4)}

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending

TAJO-1350_for_1445.patch
26/Mar/15 02:23
45 kB
Jihoon Son

Issue Links

Is contained by

TAJO-1350 Refactor FilterPushDownRule::visitJoin() into well-defined, small methods

Resolved

is related to

TAJO-1350 Refactor FilterPushDownRule::visitJoin() into well-defined, small methods

Resolved

Activity

People

Assignee:: Unassigned

Reporter:: Hyoungjun Kim

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 23/Mar/15 15:09

Updated:: 14/Apr/15 11:00

Resolved:: 14/Apr/15 11:00