Hi I am working on migration of hive tables from textfile format to ORC. In textfileformat I have used 'serialization.null.format' = '' table propery to insert empty values as NULL into the table. Hence select * from table where columnname is NULL query is working as expected. Now I would like to migrate my data from textfile to ORC. However same query is not working. Is there any table property to insert empty fields as NULL in ORC format? If yes please advice. Thanks In Advance, ravi.
... View more