Clickhouse: Correlated subqueries

[samz406]

I want use the follow sql query,it's not work, I use msyql execute it's ok. can ck is support?

(SELECT A1.QTY_SOLD  FROM V_LB_DC_ITEM_CUST_MONTH A1 WHERE A1.CUST_ID=A.CUST_ID LIMIT 1) AS TQ_QTY_SOLD,
A.QTY_SOLD
FROM V_LB_DC_ITEM_CUST_MONTH A

[filimonov]

Correlated subqueries are not supported, and currently no schedule for implementing that.

You can rewrite your query using JOIN.

P.S. We still have no issue to track requests for that feature. Let's use this one.

[leoones]

Correlated subqueries are not supported, and currently no schedule for implementing that.

You can rewrite your query using JOIN.

P.S. We still have no issue to track requests for that feature. Let's use this one.

Eager to have these functions ，

[4ertus2]

Simple samples from #9861

SELECT dummy, name
FROM system.one, system.columns
WHERE (SELECT count() FROM system.columns WHERE name != '' AND dummy = 0) > 0
LIMIT 1;

# fail
SELECT o.dummy, name
FROM system.one o, system.columns
WHERE (SELECT count() FROM system.columns WHERE name != '' AND o.dummy = 0) > 0
LIMIT 1;