title: Difference between `load data inpath ` and `location` in hive?
body: <p>At my firm, I see these two commands used frequently, and I'd like to be aware of the differences, because their functionality seems the same to me:</p>
  
  <h1>1</h1>
  
  <pre><code>create table &lt;mytable&gt; 
  (name string,
  number double);
  
  load data inpath '/directory-path/file.csv' into &lt;mytable&gt;; 
  </code></pre>
  
  <h1>2</h1>
  
  <pre><code>create table &lt;mytable&gt;
  (name string,
  number double);
  
  location '/directory-path/file.csv';
  </code></pre>
  
  <p>They both copy the data from the directory on HDFS into the directory for the table on HIVE.   Are there differences that one should be aware of when using these?  Thank you.  </p>