title: Insert into Hive table with specific parition
body: <p>Forgive me for this dumb question i have google it and search for stack overflow
  and it supposed to work</p>
  
  <p><strong>I get an error for trying to load data into hive partitioned table</strong></p>
  
  <pre><code>CREATE EXTERNAL TABLE baba2 ( name string, age INT) PARTITIONED BY ( YEAR int) 
  ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' 
  LINES TERMINATED BY '\n' 
  STORED AS TEXTFILE 
  LOCATION '/user/hive/baba2/'
  </code></pre>
  
  <p><strong>create this simple file</strong></p>
  
  <pre><code>[cloudera@localhost ~]$ head babafile.txt
  aaaaa,10
  "bbbb",30
  </code></pre>
  
  <p><strong>Created a partition</strong></p>
  
  <pre><code> ALTER TABLE BABA2 ADD PARTITION (YEAR=2015) LOCATION '/user/hive/baba2/2015';
  </code></pre>
  
  <p>After running this command:</p>
  
  <pre><code>LOAD DATA LOCAL INPATH '/home/cloudera/babafile.txt'
  INTO TABLE BABA2 PARITION(YEAR=2015);
  </code></pre>
  
  <p><strong>I get this error :</strong></p>
  
  <pre><code>**parseexception line 2:17 missing eof at 'paritioned' near 'baba2'**
  </code></pre>