alamb commented on PR #8991:
URL: 
https://github.com/apache/arrow-datafusion/pull/8991#issuecomment-1915670650

   > Hmm, except for joining keys, I think you still can list other columns 
(e.g., the original 4 columns) into selection list? So they are not always able 
to be removed from shuffle, I think?
   
   Sure, if the columns are used elsewhere in the plan, they can't be removed. 
I was thinking of the case when they aren't used anywhere else
   
   However, I am not sure how often that happens in the real world
   
   Maybe a range join 🤔 
   
   ```SQL
   SELECT ...
   FROM stocks JOIN splits ON (
     stocks.symbol = splits.symbol AND 
     stocks.ts < splits.max_time AND stocks.ts > splits.min_time
   )
   ```
   
   But I suppose the expressions are't equijoin predicates anyways 🤔 


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to