Error Loading CSV data into a Hive table
<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>