jiaan.geng created SPARK-44649: ---------------------------------- Summary: Runtime Filter supports passing equivalent creation side expressions Key: SPARK-44649 URL: https://issues.apache.org/jira/browse/SPARK-44649 Project: Spark Issue Type: New Feature Components: SQL Affects Versions: 4.0.0 Reporter: jiaan.geng
{code:java} 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' {code} -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org