Hyoungjun Kim created TAJO-1445:
-----------------------------------
Summary: Optimizer removes some filter in where clause.
Key: TAJO-1445
URL: https://issues.apache.org/jira/browse/TAJO-1445
Project: Tajo
Issue Type: Bug
Reporter: Hyoungjun Kim
Priority: Minor
{code:sql}
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;
{code}
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.
{noformat}
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)}
{noformat}
The next plan is generated by Optimizer.
{noformat}
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)}
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
