Reply
New Contributor
Posts: 2
Registered: ‎07-23-2014

insert data into Impala/Hive tables using sql server linked server

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

New Contributor
Posts: 2
Registered: ‎06-15-2015

Re: insert data into Impala/Hive tables using sql server linked server

Hi,

 

Is there any latest update on this?

Highlighted
Contributor
Posts: 122
Registered: ‎10-15-2014

Re: insert data into Impala/Hive tables using sql server linked server

I have this same issue

I cannot use Sqoop or any ETL tool

SSIS/SSRS is not installed so I cannot create a package

Hoping to reverse this https://blogs.msdn.microsoft.com/igorpag/2013/11/12/how-to-create-a-sql-server-linked-server-to-hdin...

Announcements