til.duyet.net
blog
Search…
til.duyet.net
🤪
Today I Learned
Data Engineering
☁
AWS
⚒
Tools
💻
Shell
☸
Kubernetes, Helm, Kustomize
🔄
Apache Airflow
🐳
Docker
Database
Google BigQuery
Apache Hive
AWS Redshift / Postgres
Presto
Aliyun Data Lake Analytics (Presto) - Add partition on non-existing location
AWS Athena - Add Partition
Programming
🍪
Rust
🐍
Python
👻
Golang
💎
Javascript / Typescript
✨
FE / React
Unix
Git - Pretty git branch graphs
Checking files in Docker build context
Bash get the directory of the current script
Vim
Find and replace
Miscellaneous
[Fig] Single machine and distributed system structure
Deploying Machine Learning Models at Scale
Bypass a Chrome certificate/HSTS error
Articles
Powered By
GitBook
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!
Reference:
https://help.aliyun.com/document_detail/193719.html
Database - Previous
Presto
Next
AWS Athena - Add Partition
Last modified
1yr ago
Copy link
Edit on GitHub