[ https://issues.apache.org/jira/browse/SPARK-44649?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated SPARK-44649: ----------------------------------- Labels: pull-request-available (was: ) > 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 > Priority: Major > Labels: pull-request-available > > {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