Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2013
    Posts
    1

    Unanswered: Hive insert with openquery

    Hi,

    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:

    Code:
    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

    Code:
    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

  2. #2
    Join Date
    Apr 2004
    Location
    The Netherlands
    Posts
    29

    Insert data in Hadoop from SQL Server by using Openquery.

    Hi there,

    Have look at this: https://www.inkling.com/read/hadoop-...99ee5c63ab4fc0

    Maybe it will help you achieve what you are trying todo.

    Good luck.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •