Thanks I figured this is in tmp/states Thanks for your attention.
________________________________ From: Sai Sai <saigr...@yahoo.in> To: "user@hive.apache.org" <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 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
