title: Data not getting loaded into Partitioned Table in Hive
body: <p>I am trying to create partition for my Table inorder to update a value.</p>
  
  <p>This is my sample data</p>
  
  <pre><code>1,Anne,Admin,50000,A
  2,Gokul,Admin,50000,B
  3,Janet,Sales,60000,A
  </code></pre>
  
  <p>I want to update <code>Janet's</code> Department to <strong>B</strong>.</p>
  
  <p>So for doing that I created a table with Department as partition.</p>
  
  <blockquote>
    <p>create external table trail (EmployeeID Int,FirstName
    String,Designation  String,Salary Int) PARTITIONED BY (Department
    String) row format delimited fields terminated by "," location
    '/user/sreeveni/HIVE';</p>
  </blockquote>
  
  <p>But while doing the above command.
  No data are inserted into trail table.</p>
  
  <pre><code>hive&gt;select * from trail;                               
  OK
  Time taken: 0.193 seconds
  
  hive&gt;desc trail;                                        
  OK
  employeeid              int                     None                
  firstname               string                  None                
  designation             string                  None                
  salary                  int                     None                
  department              string                  None                
  
  # Partition Information      
  # col_name              data_type               comment             
  
  department              string                  None   
  </code></pre>
  
  <p>Am I doing anything wrong?</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>As suggested I tried to insert data into my table</p>
  
  <blockquote>
    <p>load data inpath '/user/aibladmin/HIVE' overwrite into table trail
    Partition(Department);</p>
  </blockquote>
  
  <p>But it is showing</p>
  
  <blockquote>
    <p>FAILED: SemanticException [Error 10096]: Dynamic partition strict mode
    requires at least one static partition column. To turn this off set 
    hive.exec.dynamic.partition.mode=nonstrict</p>
  </blockquote>
  
  <p>After setting <code>set hive.exec.dynamic.partition.mode=nonstrict</code> also didnt work fine.</p>
  
  <p>Anything else to do. </p>