til.duyet.net
Search…
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:
1
​CREATE EXTERNAL TABLE person (
2
`id` int,
3
`name` string,
4
`age` int
5
)
6
STORED AS TEXTFILE
7
LOCATION 'oss://bucket001/dir001/'
8
TBLPROPERTIES (
9
'auto.create.location'='true'
10
);​
Copied!
Copy link
Edit on GitHub