Home >> Big Data Hadoop >> Hive Internal and External Table in Big Data Hadoop

Hive Internal and External Table in Big Data Hadoop

->Internal Table  or Managed Table, is the one that is managed by Hive.
->When we point data in HDFS to such table, the data is moved to Hive default location /usr/hive/warehouse/. And, then if such internal table is dropped, the data is deleted along with.
->External table on the other hand is user managed, and data is not moved to hive default directory after loading i.e, any custom location can be specified. Consecutively, when  drop such table, no data is deleted, only table schema is dropped from meta database.

Post Your Comment

Next Questions
Hive Internal Table
Drawback of Hive Internal/Managed Table
HIve External Table
Hive DDL
Hive CLI Options
Hive shell commands
Hive Logging & Resources
Hive Types Of Joins
Hive Joins
Hive Joins cont
Hive Built-in Operators
Hive Data Types
Hive Built-in Functions
Hive Explode
Hive SORT BY vs ORDER By
HIve DISTRIBUTE BY vs CLUSTER BY
Hive HUE Editor
Hive vs Impala
Hive Data & Schema
Hive Partitioning
Hive Bucketing
Hive File Format
Hive Engine
Hive Vectorization
Hive User Defined Function

Copyright ©2022 coderraj.com. All Rights Reserved.