title: spark scala tab file read and replace empty
body: <p>I have a set of tab files which I have to read and save in the database(Cassandra). I can load all the tables which has the data in all the columns. But some table has empty value in some of the columns and those are not getting inserted.</p>
  
  <p>I tried the below,</p>
  
  <pre><code>sqlContext.read.format("com.databricks.spark.csv").option("header", "true").option("delimiter", "/t").option("nullValue"," ").load(path)
  </code></pre>
  
  <p>and also</p>
  
  <pre><code>sqlContext.read.format("com.databricks.spark.csv").option("header", "true").option("delimiter", "/t").option("nullValue"," ").option(""," ").load(path)
  </code></pre>
  
  <p>both the options didnt load the data. Any inputs?</p>