11.151. Release 0.57

Distinct Aggregations

approx_distinct() should be used in preference to this
whenever an approximate answer is allowable as it is substantially
faster and does not have any limits on the number of distinct items it
can process. COUNT(DISTINCT...) must transfer every item over the
network and keep each distinct item in memory.

Hadoop 2.x

Use the hive-hadoop2 connector to read Hive data from Hadoop 2.x.
See Deploying Presto for details.

Amazon S3

All Hive connectors support reading data from
Amazon S3.
This requires two additional catalog properties for the Hive connector
to specify your AWS Access Key ID and Secret Access Key: