When I use flatten() function, I discovered that if the field that has to be flatten is missing in particular row - that row is completely gone. I wonder is there a way to keep such rows in the result?
SELECT flatten(a) as a , b FROM example
returns two rows:
| a | b |
| foo | smth |
| bar | smth |
and I need to keep the “b : smth_else” row as well.