I am having a query like this
SELECT DISTINCT ALIAS_b55909c99633217242d38b64d57a739e.A ALIAS_62f1b13d55d89ab470166db2c6f55506,
ALIAS_b55909c99633217242d38b64d57a739e.B ALIAS_4299db05cd562d07c10746ed6d11ffb2,
ALIAS_18271277557d93036bf90abb259431c8.C ALIAS_f64acdc7c68990bf6c1ba6ad38029654,
ALIAS_3347376d19fb8189fc130a59340677bf.D ALIAS_46fdc8ceb77065525814cd4b4b3e99ca,
ALIAS_b55909c99633217242d38b64d57a739e.E ALIAS_d1c39dae0a8e401dd0bdb9a697fd92ae,
ALIAS_b55909c99633217242d38b64d57a739e.F ALIAS_fe4ec30fde1923cbef6934c15535872d,
ALIAS_B55909C99633217242D38B64D57A739E.G ALIAS_DD66FAC2D4DEAAC920A573F715FF989F,
(SELECT NVL(en_US,EN_US)
FROM RB_TABLE
WHERE KEY=ALIAS_b55909c99633217242d38b64d57a739e.H
) ALIAS_7aadc346cac2c6d74df380069cec3735
FROM TABLE_1 ALIAS_B55909C99633217242D38B64D57A739E
LEFT OUTER JOIN TABLE_2 ALIAS_18271277557d93036bf90abb259431c8
ON ALIAS_B55909C99633217242D38B64D57A739E.I = ALIAS_18271277557D93036BF90ABB259431C8.A
LEFT OUTER JOIN TABLE_3 ALIAS_cd1c54f35385e69750c8f6a6002b9351
ON ALIAS_B55909C99633217242D38B64D57A739E.I = ALIAS_CD1C54F35385E69750C8F6A6002B9351.J
LEFT OUTER JOIN TABLE_4 ALIAS_3347376d19fb8189fc130a59340677bf
ON ALIAS_cd1c54f35385e69750c8f6a6002b9351.K = ALIAS_3347376d19fb8189fc130a59340677bf.L
WHERE (ALIAS_b55909c99633217242d38b64d57a739e.A IS NOT NULL )
ORDER BY TRIM (UPPER(ALIAS_62f1b13d55d89ab470166db2c6f55506)) ASC NULLS LAST,
TRIM (UPPER(ALIAS_4299db05cd562d07c10746ed6d11ffb2)) ASC NULLS LAST,
TRIM (UPPER(ALIAS_f64acdc7c68990bf6c1ba6ad38029654)) ASC NULLS LAST,
TRIM (UPPER(ALIAS_46fdc8ceb77065525814cd4b4b3e99ca)) ASC NULLS LAST,
(ALIAS_d1c39dae0a8e401dd0bdb9a697fd92ae) ASC NULLS LAST,
(ALIAS_FE4EC30FDE1923CBEF6934C15535872D) ASC NULLS LAST OFFSET 0 ROWS
FETCH NEXT 2000 ROWS ONLY
and it gives me an error stating that “Dremio doesn’t currently support non-scalar sub-queries used in an expression.” I am using dremio 4.3 and Oracle 12C version 12.2 version.
I can’t use a join on this. So is this a known issue or do we have a work around on this?
