Why CREATE EXTERNAL keyword is used in Hive

Question

Hi,

When there is already a way exist to create a table in hive, why create external keyword has been used?

Answer 1

Hey,

The create external keyword is used to create a table and provides a location where the table will create, so that Hive does not use a default location for this table. An EXTERNAL table points to any HDFS location for its storage, rather than default storage.

syntax: