How to fill null values with 0 in AWS Athena

Question

In Athena, what is the most efficient way to fill null values with 0?

I think I can use Case statement, but I am also curious if there are other ways to do it.

There is [existing](https://stackoverflow.com/a/43275417/14843902) thread related to this. — amitd, Jan 29 '21 at 13:26

score 8 · Accepted Answer · edited Jan 30 '21 at 19:15

8

We can use coalesce, here is Presto documentation on conditions which is what Athena is built on.

select coalesce(myColumn, 0) from my_table_name

edited Jan 30 '21 at 19:15

halfer

answered Jan 28 '21 at 23:01

Balu Vyamajala

1 Answers1