title: Replace empty string in hive- Nvl and COALESCE tried
body: <p>How to replace an empty string(length 0 ) with some other value?  Already used <code>Nvl</code> and <code>COALESCE</code> but both doesn't replace with the replacement value because the value is not null. i can use <code>case</code> statement but looking for a built in function if there is any.</p>