Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

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

New Contributor

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

2 REPLIES 2

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

New Contributor

Hi,

 

Is there any latest update on this?

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

Contributor

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...