In Hive Internal Table can be created using command ‘CREATE TABLE’
Through internal table data can be stored and queried.
However, if you drop (delete) internal table, data stored in table will be deleted permanently.
One can load the data in internal table either through local file system or load the data from HDFS.
If you have load the data from HDFS to Hive and if you delete (‘ DROP TABLE’) then data will be deleted from HDFS also. Same stand true for local file system. So one should be careful for using internal table.
CREATE TABLE emp(id INT, deparID INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LOCATION (path)
DROP TABLE emp