PARTITION_TYPE = USER_SPECIFIED must be used when you prefer to add and remove partitions selectively rather than automatically adding partitions for all new files in an external storage location that match an expression?

PARTITION_TYPE = USER_SPECIFIED must be used when you prefer to add and remove partitions selectively rather than automatically adding partitions for all new files in an external storage location that match an expression?
A . TRUE
B . FALSE

View Answer

Answer: A

Explanation:

The CREATE EXTERNAL TABLE syntax for manually added partitions is as follows: