https://community.cloudera.com/t5/Support-Questions/Hive-set-Null-value-to-Empty-string/m-p/179664#M141910 <P>Hi <A rel="user" href="https://community.cloudera.com/users/11773/vgarg.html" nodeid="11773">@vgarg</A>,</P><P>Since <A href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF">0.11 hive</A> has a NVL function <CODE>nvl(T value, T default_value)</CODE></P><P>which says <EM>Returns default value if value is null else returns value</EM></P> Mon, 17 Sep 2018 12:53:24 GMT edu_vikassri 2018-09-17T12:53:24Z