title: importing data into hive table from external s3 bucket url link
body: <p>I need to import data from a public s3 bucket which url is shared with me. how to load the data into hive table?
  I have tried below command but its not working:</p>
  <pre><code>create external table airlines_info (.... ) row format 
  delimited fields terminated by '|' lines terminated by '\n'
  stored as textfile location 'https://ml-cloud-dataset.....*.txt';
  </code></pre>
  <blockquote>
  <p>FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:ml-cloud-dataset.s3.amazonaws.com/Airlines_data.txt is not a directory or unable to create one)</p>
  </blockquote>
  <p>I am very new to hive and I am not sure about the code. I also tried below code after creating the table to load the data into hive table but that's also not working</p>
  <pre><code>load data inpath 'https://ml-cloud-dataset.....*.txt' into table airlines_info;
  </code></pre>