Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

Coalesce in Kafka

COALESCE is replaces null with custom string. Coalesce in google cloud spanner replaces with

select id, name, coalesce(preference,'Empty') from students

Source Data
idnamePreference
123RanveerInsurance worker
234Meerublock chain
345Smirnovnull

Result
idnameUnspecified
123RanveerInsurance worker
234Meerublock chain
345SmirnovEmpty