티스토리 뷰

공부

[Presto] extract value from a column JSON

승가비 2020. 10. 28. 00:57
728x90
SELECT json_extract_scalar(json, '$.store.book[0].author');

https://stackoverflow.com/questions/50252774/extract-value-from-a-column-presto

 

extract value from a column presto

i have two columns: col1: Adam Smith col2: [{"productId":"328608","invoiceId":"16150101","productType":"car"}] i need to select this: col1: Adam Smith ProductId: 328608 any ideas? Thanks.

stackoverflow.com

 

728x90
저작자표시 비영리

'공부' 카테고리의 다른 글

[JS] get yesterday  (0) 2020.10.28
[Java] getHour()  (0) 2020.10.28
[MySQL] MySQL Error 1093 : You can't specify target table 'tablename' for update in FROM clause  (0) 2020.10.28
[Java] add arrayList()  (0) 2020.10.28
[Spark] order by 한글 > 영어 > 숫자  (0) 2020.10.27
댓글