[SPARK-44649] Runtime Filter supports passing equivalent creation side expressions

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Jiaan Geng
• Reporter: Jiaan Geng
• Created: 03/Aug/23 03:46
• Updated: 18/Oct/23 06:59
• Resolved: 18/Oct/23 06:56

Description

SELECT
  d_year,
  i_brand_id,
  i_class_id,
  i_category_id,
  i_manufact_id,
  cs_quantity - COALESCE(cr_return_quantity, 0) AS sales_cnt,
  cs_ext_sales_price - COALESCE(cr_return_amount, 0.0) AS sales_amt
FROM catalog_sales
  JOIN item ON i_item_sk = cs_item_sk
  JOIN date_dim ON d_date_sk = cs_sold_date_sk
  LEFT JOIN catalog_returns ON (cs_order_number = cr_order_number
    AND cs_item_sk = cr_item_sk)
WHERE i_category = 'Books'

Issue Links

• links to: [Github] Pull Request #42317 (beliefer)
• links to: [Github] Pull Request #42317 (beliefer)
• links to: GitHub Pull Request #42317