Each partition in an external table corresponds to multiple files. You can perform partition pruning to search for the required files. You can create partitions for an external table to improve the ease of use and query efficiency. After data is partitioned, a query needs to scan only specific partitions instead of all data in the entire table, improving the query efficiency and reducing resource consumption.
References
For more information about external table partitions, see Create external table partitions.