title: Presto DDL on S3 using FileHiveMetastore not working
body: <p>I tried to connect Presto to S3 using FileHiveMetaStore with below configurations , but it when I am trying to create table with the statement mentioned but it fails with error message  mentioned below . could any one let me know if the configurations mentioned are wrong.</p>
  
  <p>I could see that it is possible as some one has already mentioned  it is possible to connect </p>
  
  <p>reference thread :- <a href="https://stackoverflow.com/questions/48932907/setup-standalone-hive-metastore-service-for-presto-and-aws-s3">Setup Standalone Hive Metastore Service For Presto and AWS S3</a></p>
  
  <p>error message:- com.amazonaws.services.s3.model.AmazonS3Exception: The specified bucket does not exist (Service: Amazon S3; Status Code: 404; Error Code: NoSuchBucket; Request ID: 33F01AA7477B12FC)</p>
  
  <pre><code>**connector.name=hive-hadoop2
  hive.metastore=file
  hive.metastore.catalog.dir=s3://ap-south-1.amazonaws.com/prestos3test/
  hive.s3.aws-access-key=yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy
  hive.s3.aws-secret-key=zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
  hive.s3.endpoint=http://prestos3test.s3-ap-south-1.amazonaws.com
  hive.s3.ssl.enabled=false
  hive.metastore.uri=thrift://localhost:9083**
  </code></pre>
  
  <h2>External Table Creation</h2>
  
  <p>**CREATE TABLE PropData (
    prop0 integer,
    prop1 integer,
    prop2 varchar,
    prop3 varchar ,
    prop4 varchar</p>
  
  <p>)
  WITH (
    format = 'ORC',
    external_location = 's3://prestos3test'
  )**</p>
  
  <p>Thanks
  Santosh</p>