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?
I have this same issue
I cannot use Sqoop or any ETL tool
SSIS/SSRS is not installed so I cannot create a package