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

jdbc tests/test_no_7 query is not supported by Citus #190

Open
onurctirtir opened this issue Jul 3, 2020 · 0 comments
Open

jdbc tests/test_no_7 query is not supported by Citus #190

onurctirtir opened this issue Jul 3, 2020 · 0 comments

Comments

@onurctirtir
Copy link
Member

test_no_7 query from https://github.com/citusdata/test-automation/blob/jdbc/jdbc/JDBCReleaseTest.java#L121 is not supported by Citus. For this reason:

  • We get some citus planner errors for append tables as below:
"ERROR:  complex joins are only supported when all distributed tables are co-located and joined on their distribution columns"   

(It is the expected behaviour as level-1 subquery does not join ""supplier"" table with other 3 tables on its distribution column, we should change the test query)

  • We get some citus planner errors for hash dist. tables as below:
ERROR:  cannot perform distributed planning on this query
DETAIL:  Cartesian products are currently unsupported

(It is the expected behaviour as level-2 subquery does cartesian product, we should change the test query)

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