title: Error Loading CSV data into a Hive table
body: <p>I have a CSV file which has rows in the following format,</p>
  
  <pre><code>1, 11812, 15273, "2016-05-22T111647.800 US/Eastern", 82971850, 0
  1, 11812, 7445, "2016-05-22T113640.200 US/Eastern", 82971928, 0
  1, 11654, 322, "2016-05-22T113845.773 US/Eastern", 82971934, 0
  1, 11722, 0, "2016-05-22T113929.541 US/Eastern", 82971940, 0
  </code></pre>
  
  <p>The I create a Hive table with the following command,</p>
  
  <pre><code>create table event_history(status tinyint, condition smallint,
  machine_id int, time timestamp, ident int, state tinyint)
  </code></pre>
  
  <p>Then I am trying to load the CSV file into the table with the following command,</p>
  
  <pre><code>load data local inpath "/home/ubuntu/events.csv" into table event_history;
  </code></pre>
  
  <p>But all I get is NULLs when I try to do a select query in the created table. What am I missing here?</p>
  
  <p>The Hive version is <strong><em>Hive 1.2.1</em></strong></p>