HIve External Table in Big Data Hadoop

Create external table external_table(name string,age int, address string,zip int)row format delimited fields terminated by ','stored as textfile location '/test/abc';

Create external table external_table(name string,age int)row format delimited fields terminated by ','stored as parquet location '/test/abc';

Use external table if data is being used outside of Hive.

The data files are read and processed by an existing program that doesn't lock the files. Data needs to remain in the underlying location even after a DROP.