티스토리 뷰

공부

[Athena] SQL COALESCE(a, 0) <-- NVL(a, 0)

승가비 2022. 6. 28. 02:35
728x90

https://stackoverflow.com/questions/43275356/presto-check-if-null-and-return-default-nvl-analog

 

Presto check if NULL and return default (NVL analog)

Is there any analog of NVL in Presto DB? I need to check if a field is NULL and return a default value. I solve this somehow like this: SELECT CASE WHEN my_field is null THEN 0 ELSE

stackoverflow.com

 

728x90
저작자표시 비영리

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

[Ehcache] spring  (0) 2022.06.28
[ktlint] disabled_rules=experimental:argument-list-wrapping  (0) 2022.06.28
[Github] Actions  (0) 2022.06.28
[IntelliJ] kotlin code remove wildcard(*) import  (0) 2022.06.28
[yaml] boolean (true, false) not need quotations (", ')  (0) 2022.06.28
댓글