title: How to filter out all null values from all the columns of a table in one go using Spark-shell?
body: <p>I am using <strong>Spark shell 1.6</strong>. I want to perform a check to separate all the rows containing null values from the once that don't. More precisely I have to segregate them into 2 different tables (data and error). Problem is that I have too many columns (42) so checking it one at a time goes out of the question.
  Some points which may help:</p>
  
  <ol>
  <li>Schema of the data contains bigint, int, String and date formats.</li>
  <li>Tables used are all hive tables.</li>
  <li>I have CSV for the data as well (but using spark shell is a must).</li>
  </ol>