title: NULL is displaying as '\N' when write the result of Hive query in text file
body: <p>I'm trying to download the results of Hive queries using 'Write to directory' feature of Hive. For some columns my query is returning <code>NULL</code> values but in the generated file I can see this being replaced by <code>\N</code>.
  Is this the expected behavior of Hive? I have to upload the generated files to Bigquery tables. Is there any way to generate <code>NULL</code> for null values instead of <code>\N</code> because after receiving <code>\N</code> in the file I'll have to do the intermediate processing( replacing <code>\N</code> with <code>NULL</code> or empty string).
  Please suggest.</p>