Difference between Hive internal tables and external tables?

by

Hive has a relational database on the master node it uses to keep track of state.
For instance, when you CREATE TABLE FOO(foo string) LOCATION 'hdfs://tmp/';, this table schema is stored in the database.

If you have a partitioned table, the partitions are stored in the database(this allows hive to use lists of partitions without going to the file-system and finding them, etc). These sorts of things are the ‘metadata’.

When you drop an internal table, it drops the data, and it also drops the metadata.

When you drop an external table, it only drops the meta data. That means hive is ignorant of that data now. It does not touch the data itself.

More Related Contents:

  1. How to update table in Hive 0.13?
  2. Hive: Best way to do incremetal updates on a main table
  3. Execute Hive Query with IN clause parameters in parallel
  4. What is the difference between partitioning and bucketing a table in Hive ?
  5. How to transpose/pivot data in hive?
  6. How do I output the results of a HiveQL query to CSV?
  7. Sqoop import : composite primary key and textual primary key
  8. How to delete and update a record in Hive
  9. Hive unable to manually set number of reducers
  10. how many mappers and reduces will get created for a partitoned table in hive
  11. Hive: Add partitions for existing folder structure
  12. How to load data to hive from HDFS without removing the source file?
  13. Loading Data from a .txt file to Table Stored as ORC in Hive
  14. Create HIVE Table with multi character delimiter
  15. Job queue for Hive action in oozie
  16. Difference between Pig and Hive? Why have both? [closed]
  17. What is Hive: Return Code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
  18. Can Hive recursively descend into subdirectories without partitions or editing hive-site.xml?
  19. Hive Data Retrieval Queries: Difference between CLUSTER BY, ORDER BY, and SORT BY
  20. Chaining multiple MapReduce jobs in Hadoop
  21. Set hadoop system user for client embedded in Java webapp
  22. How to access s3a:// files from Apache Spark?
  23. How to get the input file name in the mapper in a Hadoop program?
  24. Apache Spark: The number of cores vs. the number of executors
  25. Apache Hadoop Yarn – Underutilization of cores
  26. Where does hadoop mapreduce framework send my System.out.print() statements ? (stdout)
  27. Default Namenode port of HDFS is 50070.But I have come across at some places 8020 or 9000 [closed]
  28. How does Hadoop perform input splits?
  29. Difference between HBase and Hadoop/HDFS
  30. Merging multiple files into one within Hadoop

Leave a Comment