title: Hive query regarding insert into
body: <p>I have a table tableA and creating tableB as </p>
  
  <pre><code> CREATE EXTERNAL TABLE IF NOT EXISTS db.tableB LIKE db.tableA;
  </code></pre>
  
  <p>Then inserting the data between date1 to date 7 using below command </p>
  
  <pre><code>insert overwrite table  db.tableB partition (yymmddval, yymmddcrt)
      select *
      from db.tableA
      where 1 = 1
        and yymmddval between '${start}' and '${end}' ; # date 1 to date 7
  </code></pre>
  
  <p>Now I want to insert new  data into my tableB from table A from date 11 to date 17 without losing date1 to date7 data.</p>
  
  <pre><code>insert into table  db.tableB partition (yymmddval, yymmddcrt)
      select *
      from db.tableA
      where 1 = 1
        and yymmddval between '${start}' and '${end}' ; # date 11 to date 17
  </code></pre>
  
  <p>So do I have to use partition syntax again in the second <code>insert into</code> command? I cannot run the two command in one shot</p>