var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Hive insert with openquery
My question is based on this article
Import Hadoop Data into Analysis Services Tabular | Ayad Shammout's SQL & BI Blog
Mentioned in the article is an example of using openquery to perform select statement on a Hive table through a linkedserver.
I was wondering how can i also perform an insert statement with openquery?
I understand that for example to insert into Hive is to use a Load command, like:
How do i execute this with openquery? I've tried the example below and some slight variations but all I get in return were syntax errors
load data inpath '/tmp/data.csv' overwrite into table tableA;
Hope to hear from somebody on the correct syntax
insert openquery (linkedserverName, 'load data inpath '/tmp/data.csv' overwrite into table tableA;')
Insert data in Hadoop from SQL Server by using Openquery.
Have look at this: https://www.inkling.com/read/hadoop-...99ee5c63ab4fc0
Maybe it will help you achieve what you are trying todo.
Tags for this Thread