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

    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:

    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,


  2. #2
    Join Date
    Apr 2004
    The Netherlands

    Insert data in Hadoop from SQL Server by using Openquery.

    Hi there,

    Have look at this:

    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