Presto 329 Documentation

12.196. Release 0.61

12.196. Release 0.61

Add support for Table Value Constructors

Presto now supports the SQL table value constructor syntax to create inline tables. The VALUES clause can be used anywhere a SELECT statement is allowed. For example, as a top-level query:

VALUES ('a', 1), ('b', 2);
 _col0 | _col1
-------+-------
 a     |     1
 b     |     2
(2 rows)

Alternatively, in the FROM clause:

SELECT *
FROM (
  VALUES
    ('a', 'ape'),
    ('b', 'bear')
) AS animal (letter, animal)
JOIN (
  VALUES
    ('a', 'apple'),
    ('b', 'banana')
) AS fruit (letter, fruit)
USING (letter);
 letter | animal | letter |  fruit
--------+--------+--------+---------
 a      | ape    | a      | apple
 b      | bear   | b      | banana
(2 rows)

Cassandra

  • Add support for upper-case schema, table, and columns names.
  • Add support for DECIMAL type.

Amazon S3 support

  • Completely rewritten Hadoop FileSystem implementation for S3 using the Amazon AWS SDK, with major performance and reliability improvements.
  • Add support for writing data to S3.

Miscellaneous

  • General improvements to the JDBC driver, specifically with respect to metadata handling.
  • Fix division by zero errors in variance aggregation functions (VARIANCE, STDDEV, etc.).
  • Fix a bug when using DISTINCT aggregations in the HAVING clause.
  • Fix an out of memory issue when writing large tables.
  • Fix a bug when using ORDER BY rand() in a JOIN query.
  • Fix handling of timestamps in maps and lists in Hive connector.
  • Add instrumentation for Hive metastore and HDFS API calls to track failures and latency. These metrics are exposed via JMX.