Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Regex or list in 'serialization.null.format' parameter

Regex or list in 'serialization.null.format' parameter

Rising Star

Is there any way to use list or regex in Hive table parameter 'serialization.null.format'?

I know that I can use single character as null by using this command:

tblproperties('serialization.null.format'='null')

But what if I want Hive to treat two characters as null? For example:

tblproperties('serialization.null.format'=['null', '\\N']); 
OR 
tblproperties('serialization.null.format'=' *');

Does anyone know if it is possible?

Don't have an account?
Coming from Hortonworks? Activate your account here