Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-1445

Optimizer removes some filter in where clause.

    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

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                hjkim Hyoungjun Kim
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: