Support Questions
Find answers, ask questions, and share your expertise

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:


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