You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by "aprimadi (via GitHub)" <gi...@apache.org> on 2023/06/04 18:46:22 UTC

[GitHub] [arrow-datafusion] aprimadi opened a new issue, #6540: Question: why isn't this predicate being pushed down to TableScan?

aprimadi opened a new issue, #6540:
URL: https://github.com/apache/arrow-datafusion/issues/6540

   ### Describe the bug
   
   ```
   query TT
   EXPLAIN
   SELECT *
   FROM join_t1
   RIGHT JOIN join_t2 on join_t1.t1_id = join_t2.t2_id
   WHERE join_t1.t1_int IS NOT NULL
   ----
   logical_plan
   Inner Join: join_t1.t1_id = join_t2.t2_id
   --Filter: join_t1.t1_int IS NOT NULL
   ----TableScan: join_t1 projection=[t1_id, t1_name, t1_int]
   --TableScan: join_t2 projection=[t2_id, t2_name, t2_int]
   ```
   
   I think that the filter logical plan can be pushed down to TableScan.
   
   ### To Reproduce
   
   _No response_
   
   ### Expected behavior
   
   _No response_
   
   ### Additional context
   
   _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: github-unsubscribe@arrow.apache.org.apache.org

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

[GitHub] [arrow-datafusion] aprimadi commented on issue #6540: Question: why isn't this predicate being pushed down to TableScan?

Posted by "aprimadi (via GitHub)" <gi...@apache.org>.
aprimadi commented on issue #6540:
URL: https://github.com/apache/arrow-datafusion/issues/6540#issuecomment-1575673311

   Moving this to discussion


-- 
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: github-unsubscribe@arrow.apache.org

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

[GitHub] [arrow-datafusion] aprimadi closed issue #6540: Question: why isn't this predicate being pushed down to TableScan?

Posted by "aprimadi (via GitHub)" <gi...@apache.org>.
aprimadi closed issue #6540: Question: why isn't this predicate being pushed down to TableScan?
URL: https://github.com/apache/arrow-datafusion/issues/6540


-- 
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: github-unsubscribe@arrow.apache.org

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