19.142. Release 0.101
- Add support for CREATE TABLE (in addition to CREATE TABLE AS).
IF EXISTSsupport to DROP TABLE and DROP VIEW.
- Add support for
- Fix excessive memory usage in
- Fix excessive memory usage in queries that perform partitioned top-N operations
- Optimize ARRAY comparison operators.
- Fix analysis of
UNIONqueries for tables with hidden columns.
JOINassociativity to be left-associative instead of right-associative.
runtime.queriestable in System Connector.
runtime.nodestable in System Connector.
errorobject in REST API (
errorCodepreviously existed but was always zero).
DatabaseMetaData.getIdentifierQuoteString()in JDBC driver.
- Handle thread interruption in JDBC driver
historycommand and support for running previous commands via
!nto the CLI.
- Change Driver to make as much progress as possible before blocking. This improves responsiveness of some limit queries.
- Add predicate push down support to JMX connector.
- Add support for unary
- Improve scheduling speed by reducing lock contention.
- Extend optimizer to understand physical properties such as local grouping and sorting.
- Add support for streaming execution of window functions.
UNIONrun partitioned, if underlying plan is partitioned.
hash_partition_countsession property to control hash partitions.
Web UI Changes
The main page of the web UI has been completely rewritten to use ReactJS. It also has a number of new features, such as the ability to pause auto-refresh via the “Z” key and also with a toggle in the UI.
- Add support for connecting to S3 using EC2 instance credentials.
This feature is enabled by default. To disable it, set
hive.s3.use-instance-credentials=falsein your Hive catalog properties file.
- Treat ORC files as splittable.
- Change PrestoS3FileSystem to use lazy seeks, which improves ORC performance.
- Fix ORC
DOUBLEstatistic for columns containing
- Lower the Hive metadata refresh interval from two minutes to one second.
- Invalidate Hive metadata cache for failed operations.
s3afile system scheme.
- Fix discovery of splits to correctly backoff when the queue is full.
- Add support for non-canonical Parquet structs.
- Add support for accessing Parquet columns by name. By default, columns in Parquet
files are accessed by their ordinal position in the Hive table definition. To access
columns based on the names recorded in the Parquet file, set
hive.parquet.use-column-names=truein your Hive catalog properties file.
- Add JMX stats to PrestoS3FileSystem.
hive.recursive-directoriesconfig option to recursively scan partition directories for data.
- Add connector callback for rollback of
CREATE TABLE AS.
- Introduce an abstraction for representing physical organizations of a table
and describing properties such as partitioning, grouping, predicate and columns.
ConnectorPartitionand related interfaces are deprecated and will be removed in a future version.
This is a backwards incompatible change with the previous connector SPI. If you have written a connector, you will need to update your code before deploying this release.