title: LOAD DATA INPATH loads same CSV-base data into two different and external Hive tables
body: <p>I have two CSV-files that I uploaded to the Azure Blob Storage within HDInsight. I can upload these two files to the cluster without problems. I then create two Hive-tables with...</p>
  
  <pre><code>CREATE EXTERNAL TABLE IF NOT EXISTS hive_table1(id int, age string, date string...) 
  ROW FORMAT DELIMITED FIELDS TERMINATED BY '\;' STORED AS TEXTFILE LOCATION '/user/hive/warehouse'
  </code></pre>
  
  <p>Similar syntax goes for the other table.</p>
  
  <p>Now I want to load the first CSV-file into the first table and the second CSV-file into the second table (resulting in non-corresponding columns).</p>
  
  <p>I use...</p>
  
  <pre><code>LOAD DATA INPATH '/file/file1.csv' OVERWRITE INTO TABLE hive_table1;
  </code></pre>
  
  <p>...and am able to load the CSV-file data into the first table. <em>But</em>..., not only is the first data set loaded into the first Hive table, it <em>also</em> loads the exact same file's data into the <em>second</em> Hive table.</p>
  
  <p>Obviously, I <em>only</em> want to have the first data set loaded into one table and the second <em>distinct</em> data set <em>only</em> into the other table.</p>
  
  <p>Can anyone help pointing out errors or contribute with a possible solution?</p>
  
  <p>Thanks in advance.</p>