Core concept
CREATE EXTERNAL TABLE for shared data (S3, existing HDFS paths).
Advertisement
How it works
Confusing dev accidentally drops managed table → data loss.
Advertisement
Trade-offs + gotchas
External for shared data lakes. Managed for Hive-owned tables.