By default, you will get the error when trying to add partition references to a non-existing oss path.
The table property auto.create.location
will help to resolve this error.
Examples are as follows:
CREATE EXTERNAL TABLE person (
`id` int,
`name` string,
`age` int
)
STORED AS TEXTFILE
LOCATION 'oss://bucket001/dir001/'
TBLPROPERTIES (
'auto.create.location'='true'
);
Reference: https://help.aliyun.com/document_detail/193719.html