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.

Empty string as NULL in ORC tables

Empty string as NULL in ORC tables

Rising Star

Is it possible to treat empty strings (or string with only white spaces) as NULL values in ORC table?


I will give the example. I import data from MS SQL to Hive using Sqoop. When I use TEXTFILE everything works good. All empty strings are treated as NULL if I use paremeter:

'serialization.null.format'=''

But this parameter does not work with ORC tables. Is there any equivalent of this parameter in ORC format?