issues
search
linzhengen
/
tech-notes
My tech notes write in github issues🧲
1
stars
0
forks
source link
[20210623] athenaの関数はpresto構文を使っている、prestoの生み親はfacebook
#117
Open
linzhengen
opened
3 years ago
linzhengen
commented
3 years ago
Doc
https://docs.aws.amazon.com/ja_jp/athena/latest/ug/presto-functions.html
https://prestodb.io/docs/0.217/index.html
jsonの魔法
SELECT json_extract(json, '$.store.book');
Doc
jsonの魔法