@Neeraj Sabharwal. Got It.. Thanks a lot. ... View more

@Neeraj Sabharwal : I did not get the first point : "Incorrect: Data resides in HDFS. HCatalog stores the data" Since my data is in local file system, And I have just created an external table in Hive(Still data is not loaded). At this moment data is in local file system and no file exists at the path which I have mentioned in Create table. As Hive does not know which data to load how will it store the data in HDFS? Little confused on this part. ... View more

@Neeraj Sabharwal Thanks For the quick reply. I got the solution to my problem. 1. I figured out that once the data is loaded into the External Table, Only then the file will appear in HDFS as create table just stores the metadata and data is not present for HDFS. 2. My root was not having write access to /tmp . When I tried to load the data I got the error. That is how it stuck my mind that there could be some permission issue. 🙂 Once I gave the path for which my root had the access i.e. /user/root in my case which i created and loaded the data into the table, I could see the file and its contents. ... View more