Re: Location of external table in hdfs

[Sai Sai]

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