There are two types of tables in HIVE, Managed and External.Data in HIVE is stored in files and those files are stored inside the directories which have the same name as the table name.
All the files and directories related to HIVE are stored in HIVE's 'warehouse' directory by default. The default path of the 'warehouse' directory is '/user/hive/warehouse' .
The database 'myNewDB' is suffixed with .db. Inside which we find the 'Employee' directory. Finally we can see the file '000000_0', which contains actual data. Hadoop has given an arbitrary name for it. Overall the data is stored in the 'warehouse' directory.
Depending on where the data is placed in HIVE there are two types of table in HIVE:
In managed tables the data is placed in the 'warehouse' directory and is completely managed and maintained by HIVE. However other technologies like pig and map reduce jobs can also access the data. And most importantly deleting managed table deletes the data along with the metadata.
In External tables the data is stored in some other directory and not in the 'warehouse' directory of HIVE. So the data is not managed by HIVE but HIVE can access the data in the external directory. And in this case deleting an external table does not delete the actual data.