I have Hive table with ORC format, an i have some records stored as Null in the table, is there any configuration in hive to Set Null as Empty string while Querying the data ?
I don't think there is any such configuration. You can use CASE statement to achieve this e.g.
SELECT CASE WHEN col is NULL THEN '' ELSE col END from table;
Tanx for your reply, i dont think so case statement would helpful for me, coz i need to make this change at globally across all my systems.
Since 0.11 hive has a NVL function nvl(T value, T default_value)
nvl(T value, T default_value)
which says Returns default value if value is null else returns value