Aliyun Data Lake Analytics (Presto) - Add partition on non-existing location

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

Last updated