[
https://issues.apache.org/jira/browse/TAJO-1445?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14381244#comment-14381244
]
Jihoon Son commented on TAJO-1445:
----------------------------------
Thanks!
I'll put a patch on TAJO-1350 after adding a test case for this issue.
It will be my pleasure if you review the patch.
> 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
> Attachments: TAJO-1350_for_1445.patch
>
>
> {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)
