August 29, 2013 at 7:56 pm
Hi,
My question is based on this article
http://ayadshammout.com/2013/05/27/import-hadoop-data-into-sql-bi-semantic-model-tabular/
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:
load data inpath '/tmp/data.csv' overwrite into table tableA;
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
insert openquery (linkedserverName, 'load data inpath '/tmp/data.csv' overwrite into table tableA;')
Hope to hear from somebody on the correct syntax
Thank you,
Koh
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy