Loading data using Load Data in HIve/Impala
<p>I can able to load data into hive using following command :</p>

<pre><code>LOAD DATA   INPATH '/xx/person/a.csv' INTO TABLE person PARTITION (age = 30);
</code></pre>

<p>in above statement , <code>age=30</code> is partition where data has to be stored.</p>

<p>what if <em>a.csv</em> actually have the age column inside? Is there a way to get hive to correctly insert each line of a.csv into my person table under the right partition with one LOAD DATA statement?</p>