title: How do I load data correctly in Hive using spark?
body: <p>I want to input data which looks as-</p>
  
  <pre><code>"58;""management"";""married"";""tertiary"";""no"";2143;""yes"";""no"";""unknown"";5;""may"";261;1;-1;0;""unknown"";""no"""
  "44;""technician"";""single"";""secondary"";""no"";29;""yes"";""no"";""unknown"";5;""may"";151;1;-1;0;""unknown"";""no"""
  "33;""entrepreneur"";""married"";""secondary"";""no"";2;""yes"";""yes"";""unknown"";5;""may"";76;1;-1;0;""unknown"";""no"""
  "47;""blue-collar"";""married"";""unknown"";""no"";1506;""yes"";""no"";""unknown"";5;""may"";92;1;-1;0;""unknown"";""no"""
  </code></pre>
  
  <p>My create table statement is as-</p>
  
  <pre><code>sqlContext.sql("create table dummy11(age int, job string, marital string, education string, default string, housing string, loan string, contact string, month string, day_of_week string, duration int, campaign int, pday int, previous int, poutcome string, emp_var_rate int, cons_price_idx int, cons_conf_idx int, euribor3m int, nr_employed int, y string)row format delimited fields terminated by ';'")
  </code></pre>
  
  <p>When I run the statement- </p>
  
  <pre><code>sqlContext.sql("from dummy11 select age").show()
  </code></pre>
  
  <p>OR</p>
  
  <pre><code>sqlContext.sql("from dummy11 select y").show()
  </code></pre>
  
  <p>It returns <code>NULL</code> value instead of correct values, though other values are visible</p>
  
  <p>So how do I correct this??</p>