When you create an external table, original data ('/tmp/states' in
this case) is NOT copied to the warehouse folder (or infact any other
folder for that matter). So you can find it in '/tmp/states' ifself.
On Tue, Mar 5, 2013 at 10:26 PM, Sai Sai wrote:
> I have created an external table like bel
Thanks I figured this is in tmp/states
Thanks for your attention.
From: Sai Sai
To: "user@hive.apache.org"
Sent: Tuesday, 5 March 2013 8:56 AM
Subject: Re: Location of external table in hdfs
I have created an external table like below and wonde
/tmp/states in HDFS.
On Tue, Mar 5, 2013 at 10:56 AM, Sai Sai wrote:
> I have created an external table like below and wondering where (folder)
> in hdfs i can find this:
>
> CREATE EXTERNAL TABLE states(abbreviation string, full_name string) ROW
> FORMAT DELIMITED FIELDS TERMINATED BY '\t' LOCA
I have created an external table like below and wondering where (folder) in
hdfs i can find this:
CREATE EXTERNAL TABLE states(abbreviation string, full_name string) ROW FORMAT
DELIMITED FIELDS TERMINATED BY '\t' LOCATION '/tmp/states' ;
Any help is really appreciated.
Thanks
Sai
