Re: import sql file

2016-11-23 Thread Mich Talebzadeh 
put the file into an hdfs directory.

assuming to be some type of csv file from mssql or oracle, create an
external table in hive looking at the hdfs directory where you put the sql
file using LOCATION in Hive.

there are multiple examples if you google it. It is pretty straight forward.

alternatively use Sqoop to read the RDBMS table and create and import data
into Hive table. you need the JAR file for the relevevant RDBMS


HTH

Dr Mich Talebzadeh



LinkedIn * 
https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
*



http://talebzadehmich.wordpress.com


*Disclaimer:* Use it at your own risk. Any and all responsibility for any
loss, damage or destruction of data or any other property which may arise
from relying on this email's technical content is explicitly disclaimed.
The author will in no case be liable for any monetary damages arising from
such loss, damage or destruction.



On 23 November 2016 at 09:45, patcharee  wrote:

> I exported sql table into .sql file and would like to import this into hive
>
> Best, Patcharee
>
>
> On 23. nov. 2016 10:40, Markovitz, Dudu wrote:
>
>> Hi Patcharee
>> The question is not clear.
>>
>> Dudu
>>
>> -Original Message-
>> From: patcharee [mailto:patcharee.thong...@uni.no]
>> Sent: Wednesday, November 23, 2016 11:37 AM
>> To: user@hive.apache.org
>> Subject: import sql file
>>
>> Hi,
>>
>> How can I import .sql file into hive?
>>
>> Best, Patcharee
>>
>>
>

Re: import sql file

2016-11-23 Thread patcharee 

I exported sql table into .sql file and would like to import this into hive

Best, Patcharee

On 23. nov. 2016 10:40, Markovitz, Dudu wrote:

Hi Patcharee
The question is not clear.

Dudu

-Original Message-
From: patcharee [mailto:patcharee.thong...@uni.no]
Sent: Wednesday, November 23, 2016 11:37 AM
To: user@hive.apache.org
Subject: import sql file

Hi,

How can I import .sql file into hive?

Best, Patcharee

RE: import sql file

2016-11-23 Thread Markovitz, Dudu 
Hi Patcharee 
The question is not clear.

Dudu

-Original Message-
From: patcharee [mailto:patcharee.thong...@uni.no] 
Sent: Wednesday, November 23, 2016 11:37 AM
To: user@hive.apache.org
Subject: import sql file

Hi,

How can I import .sql file into hive?

Best, Patcharee