hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Omer, Farah" <>
Subject How to load a table from external server....
Date Thu, 01 Mar 2012 16:44:43 GMT

Could anybody tell me how can I load data into a Hive table when the flat file is existing
on another server and bit locally on Hadoop node.

For example, I am trying to load the table LU_CUSTOMER, and the flat file for this table exists
on some other RH Linux server: The LU_CUSTOMER flat file is about 30 GB in size,
hence if I move it locally to the Hadoop node, that will take a long time. I am trying to
avoid this loading onto Hadoop node part.
So I wonder if there is a way to load the table directly from the other server.

The syntax that I know currently is: LOAD DATA LOCAL INPATH '/home/nzdata/CLOUD/SCRIPT/LU_CUSTOMER.txt'

But in case I want to load from the other server directly, the path won't be local.

Any suggestions? Is that possible....


Farah Omer

Senior DB Engineer, MicroStrategy, Inc.
T: 703 2702230

View raw message