cloudflare / cloudflare/sqlalchemy-clickhouse

How can I use GLOBAL IN in this module?

Open
#83 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
325
Forks
101
PR merge metrics
No merged PRs in 30d

Description

I was using sqlachemy to do a Double-distributed IN/JOIN subqueries, whose sql looks like
`SELECT *
FROM table_a
WHERE
field_a global in (
SELECT filed_a FROM table b
)`
The sql works well. But in order to keep the code clean, I need write it in ORM way, like
`query(cls.field_a.in(table_b.subquery())`
I can't find where to put the keyword **_global_** in. So I just got the exception
` Double-distributed IN/JOIN subqueries is denied (distributed_product_mode = 'deny').`
Is there any one knows how to solve this?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.