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:
![](https://www.edureka.co/community/?qa=blob&qa_blobid=15473764331466049509)