external table in hive create external table in hive learn working external table in hive create external table in hive learn working apache hive internal external tables apache hive 3 tables external table in hive create hive internal tables vs external tables external tables over hdfs hive hive create table internal table data file parioning and advanced load and write data into hive corporate hive internal and external tables