11.185. Release 0.56

Table Creation

Tables can be created from the result of a query:

CREATE TABLE orders_by_date AS
SELECT orderdate, sum(totalprice) AS price
FROM orders
GROUP BY orderdate

Tables are created in Hive without partitions (unpartitioned) and useRCFile with the Binary SerDe (LazyBinaryColumnarSerDe) as this iscurrently the best format for Presto.

Note

This is a backwards incompatible change to ConnectorMetadata in the SPI,so if you have written a connector, you will need to update your code beforedeploying this release. We recommend changing your connector to extend fromthe new ReadOnlyConnectorMetadata abstract base class unless you want tosupport table creation.

Cross Joins

Cross joins are supported using the standard ANSI SQL syntax:

SELECT *
FROM a
CROSS JOIN b

Inner joins that result in a cross join due to the join criteria evaluatingto true at analysis time are also supported.