Re: How to load a table from external server....

2012-03-06 Thread Jonathan Seidman
Farah – can you configure the remote server as a client machine? You would just need to install Hadoop with a configuration pointing to your cluster, and then install Hive. You'd then be able to execute all Hive commands against your cluster. Note that you won't run any daemons on this node, so yo

Re: How to load a table from external server....

2012-03-01 Thread Bejoy Ks
-use it with hive Regards Bejoy.KS From: "Omer, Farah" To: "hive-u...@hadoop.apache.org" Sent: Thursday, March 1, 2012 9:50 PM Subject: How to load a table from external server Hello,   Could anybody tell me how can I load data i

Re: How to load a table from external server....

2012-03-01 Thread Alex Kozlov
Hi Farah, If the data are on another server, you still need to move it one way or another. A bare bone way to do this is to use `hadoop fs -put ...` command after which you can create external or managed table in Hive. If the data are in a relational DB you can use sqoop. You can also look into

How to load a table from external server....

2012-03-01 Thread Omer, Farah
Hello, 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: 10.11.12.13. The LU_

How to load a table from external server....

2012-03-01 Thread Omer, Farah
Hello, 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: 10.11.12.13. The LU_