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 <[email protected]> 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' LOCATION '/tmp/states' ; > > Any help is really appreciated. > Thanks > Sai
