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.
alternati
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, 2
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
