title: I am trying to set the empty values in a csv file to zero in hive. But this code doesn't seem to work. What changes should I make?
body: <h2>This is the input .csv file</h2>
  
  <p>"1","","Animation"</p>
  
  <p>"2","Jumanji",""</p>
  
  <p>"","Grumpier Old Men","Comedy"</p>
  
  <h2>Hive Code</h2>
  
  <p>CREATE TABLE IF NOT EXISTS movies(movie_id int, movie_name string,genre string)</p>
  
  <p>ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'</p>
  
  <p>WITH SERDEPROPERTIES (</p>
  
  <p>"separatorChar" = ",",</p>
  
  <p>"quoteChar"     = "\"",</p>
  
  <p>"serialization.null.format" = '0'</p>
  
  <p>);</p>
  
  <h2>Output</h2>
  
  <p>1               Animation</p>
  
  <p>2       Jumanji</p>
  
  <pre><code>    Grumpier Old Men        Comedy
  </code></pre>