Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

postgres scanner not work on partition table #220

Open
wonb168 opened this issue Apr 20, 2024 · 0 comments
Open

postgres scanner not work on partition table #220

wonb168 opened this issue Apr 20, 2024 · 0 comments

Comments

@wonb168
Copy link

wonb168 commented Apr 20, 2024

The full table copy operation performed by the DuckDB PostgreSQL extension on partitioned tables, such as

SELECT * 
FROM pg.sch.tb a 
left join b on a.x=b.x
where a.dt=current_date

, checks the process for full table copy. Under what conditions is it pushed down?
now, this sql need like this:

with a as (select * from postgres_query('pg',$$select * from sch.tb$$))
select * from a 
left join b on a.x=b.x
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant