title: hive external table needing write access
body: <p>I am trying to load a dataset stored on HDFS (textfile) into hive for analysis.
  I am using create external table as follows:</p>
  
  <pre><code>CREATE EXTERNAL table myTable(field1 STRING...) 
  ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' 
  STORED AS TEXTFILE 
  LOCATION '/user/myusername/datasetlocation';
  </code></pre>
  
  <p>This works fine, but it requires <strong>write access</strong> to the hdfs location. Why is that? </p>
  
  <p>In general, what is the right way to load text data to which I do not have write access? is there a 'read-only' external table type? </p>
  
  <p>Edit: I noticed <a href="https://issues.apache.org/jira/browse/HIVE-335" rel="noreferrer">this issue</a> on hive regarding the question. It does not seem to have been resolved.</p>