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 2024/09/04 02:19:47 UTC

[I] [CH] With AQE disable, join tables reordering works wrong [incubator-gluten]

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

   ### Backend
   
   CH (ClickHouse)
   
   ### Bug description
   
   [Expected behavior] and [actual behavior].
   
   We have a sql as following
   ```sql
   select t1 left join t2 on t1.a = t2.a
   ```
   `t2` only contains less then 100 rows, the the final plan uses `t1` as the build side table.
   
   ### Spark version
   
   None
   
   ### Spark configurations
   
   _No response_
   
   ### System information
   
   _No response_
   
   ### Relevant logs
   
   _No response_


-- 
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] [Core] With AQE disable, join tables reordering works wrong [incubator-gluten]

Posted by "lgbo-ustc (via GitHub)" <gi...@apache.org>.
lgbo-ustc commented on issue #7108:
URL: https://github.com/apache/incubator-gluten/issues/7108#issuecomment-2327849724

   @zhztheplayer I think this is a problem


-- 
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


Re: [I] [CH] With AQE disable, join tables reordering works wrong [incubator-gluten]

Posted by "lgbo-ustc (via GitHub)" <gi...@apache.org>.
lgbo-ustc commented on issue #7108:
URL: https://github.com/apache/incubator-gluten/issues/7108#issuecomment-2327848750

   Print the stats from `logicalLink`
   ```
   24/09/04 11:36:22.563 ERROR [main] OffloadJoin: xxx left stats: Statistics(sizeInBytes=48.9 GiB), right stats: Statistics(sizeInBytes=8.0 EiB)
   ```


-- 
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