Apache Hive External Tables


External tables

  • Data will be available in HDFS. The table is going to create on HDFS data.
  • We can call this one as schema on data.
  • At the time of dropping the table it drops only schema, the data will be still available in HDFS as before.
  • External tables provide an option to create multiple schemas for the data stored
  • in HDFS instead of deleting the data every time whenever schema updates

Followers