This behavior change is in the 2022_07 bundle. In the 6.32 release, the bundle is disabled by default.
For the most up-to-date status of the bundle, as well as other release-related details, see the Behavior Change Log.
Defining the partitions in an external table as user-specified means that you choose to add and remove partitions selectively rather than automatically add partitions for all new files in an external storage location that match an expression. This partition type is specified by including the PARTITION_TYPE = USER_SPECIFIED parameter when you create an external table. User-specified partitioning does not support the automatic refreshing of external table metadata.
When a CREATE EXTERNAL TABLE statement is executed with both the PARTITION_TYPE = USER_SPECIFIED and AUTO_REFRESH = TRUE parameters set, the behavior has changed as follows:
|
Previously:
|
The CREATE EXTERNAL TABLE statement was successful; however, any event notifications received from cloud storage for the external table (e.g. "new object" messages) produced an error.
|
|
Currently:
|
The CREATE EXTERNAL TABLE statement returns a user error.
|
Ref: 806
