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

LATERAL JOINS don't work on distributed hypertables #3128

Closed
svenklemm opened this issue Apr 17, 2021 · 2 comments
Closed

LATERAL JOINS don't work on distributed hypertables #3128

svenklemm opened this issue Apr 17, 2021 · 2 comments

Comments

@svenklemm
Copy link
Member

svenklemm commented Apr 17, 2021

Example Query:

SELECT * FROM generate_series(1,3) g(device) 
JOIN LATERAL (SELECT time FROM t WHERE t.device = g.device LIMIT 10) l ON true;

Error message:

ERROR:  [data_node_1]: bind message supplies 0 parameters, but prepared statement "" requires 1
@svenklemm svenklemm changed the title LATERAL JOINS don't work on multinode LATERAL JOINS don't work on distributed hypertables Apr 17, 2021
@jgm-ktg
Copy link

jgm-ktg commented Aug 31, 2021

@svenklemm Can you provide the definition/data of t above and how the distributed hypertable was partitioned? As mentioned on #3094, I was able to seemingly successfully run a lateral join on a distributed hypertable. In my case, only the EXPLAIN failed with an error similar to above.

@svenklemm
Copy link
Member Author

I think this was fixed as part of #4176

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants