You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@gluten.apache.org by "lgbo-ustc (via GitHub)" <gi...@apache.org> on 2025/10/28 11:43:07 UTC

[I] [CH] Invalid result for `full join` without join condition [incubator-gluten]

lgbo-ustc opened a new issue, #10961:
URL: https://github.com/apache/incubator-gluten/issues/10961

   ### Backend
   
   CH (ClickHouse)
   
   ### Bug description
   
   [Expected behavior] and [actual behavior].
   
   For following query
   ```sql
   select a,b from (
       select id as a from range(1)
   ) as t1
   full outer join (
       select * from ( select id as b from range(2) ) t2 where b > 10
   ) as t3
   ```
   
   `vanilla`'s result is 
   ```
   0, null
   ```
   
   but `gluten`'s result is empty. 
   
   This is a conner case, the `full join` is tranformed into `cross join`, `cross join` returns empty if any table is empty.
   
   ### Gluten version
   
   _No response_
   
   ### Spark version
   
   None
   
   ### Spark configurations
   
   _No response_
   
   ### System information
   
   _No response_
   
   ### Relevant logs
   
   ```bash
   
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org
For additional commands, e-mail: commits-help@gluten.apache.org


Re: [I] [CH] Invalid result for `full join` without join condition [incubator-gluten]

Posted by "lgbo-ustc (via GitHub)" <gi...@apache.org>.
lgbo-ustc closed issue #10961: [CH] Invalid result for `full join` without join condition
URL: https://github.com/apache/incubator-gluten/issues/10961


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org
For additional commands, e-mail: commits-help@gluten.apache.org