When use alias to execute update statement meet error

Site Feedback
1

execute update statement like this:

UPDATE “mdm-test”.A ic
set ic.mdm_status = (select ib.mdm_status from “mdm-test”.B ib where ic.name=ib.name)
where EXISTS (select ib.mdm_status from “mdm-test”.B ib where ic.name=ib.name);

it`s fine in oracle,but dremio;it is not support this grammar in dremio?

2

@knocher Dremio currently is a query engine only except for CTAS into a data lake in PARQUET FORMAT, updating Oracle tables from Dremio is currently not supported

3

oh, i see, thank u very much