22.136. 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 theHAVING
clause. - Fix an out of memory issue when writing large tables.
- Fix a bug when using
ORDER BY rand()
in aJOIN
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.