Turn subquery result to array in Kylin

Question

How can I turn the result from subquery into an array in Kylin? In PostgresSQL, I can do it like the query below, but in Kylin it is an error.

SELECT ARRAY(
    SELECT A.ID
    FROM A
    WHERE A.num = 123
)

Answer 1

Checked Kylin SQL reference, there is no such ARRAY function or similar. Seems the feature you are looking for is not in Kylin yet.