Hive insert with openquery

  • 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