************** HIVE **********************
CREATE EXTERNAL TABLE `customer`(
  `id` int,
  `first` string,
  `last` string)
ROW FORMAT SERDE
  'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES (
  'field.delim'=',',
  'serialization.format'=',')
STORED AS INPUTFORMAT
  'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
  's3a://testbucket/'
TBLPROPERTIES (
  'transient_lastDdlTime'='1524321660')

hive> use minio;
OK
Time taken: 2.398 seconds

hive> select * from customer;
OK
5       Bob     Jones
6       Phil    Brune
Time taken: 3.359 seconds, Fetched: 2 row(s)

************** PRESTO **********************

presto:minio> select * from customer;

Query 20180422_102158_00007_7etq4, FAILED, 1 node
Splits: 16 total, 0 done (0.00%)
0:38 [0 rows, 0B] [0 rows/s, 0B/s]

Query 20180422_102158_00007_7etq4 failed: Unable to execute HTTP request: testbucket.minio: Name or service not known

connector.name=hive-hadoop2
hive.metastore.uri=thrift://hivemeta:9083
hive.s3.endpoint=http://minio:9000
hive.s3.aws-access-key=OQ4K2YFH7S1BE6ZM10M0
hive.s3.aws-secret-key=Ft5iKPkY0YZNoDpp6r5HgbjFuGAxn+jt1avBPyHq