Hi,

I am trying to use sql server linked server in order to add data to existing Impala table:

INSERT INTO CDH_Impala.Impala.db.yourtablenamehere

select 2 as Field1, 3 AS Field2

but i am getting error:

Msg 7390, Level 16, State 2, Line 1

The requested operation could not be performed because OLE DB provider "MSDASQL" for linked server "CDH_IMPALA" does not support the required transaction interface.

Is there any workaround?

Thanks, Yuval