Presto 337 Documentation

13.142. Release 0.123

13.142. Release 0.123#

General Changes#

  • Remove node-scheduler.location-aware-scheduling-enabled config.
  • Fixed query failures that occur when the optimizer.optimize-hash-generation config is disabled.
  • Fix exception when using the ResultSet returned from the DatabaseMetaData.getColumns method in the JDBC driver.
  • Increase default value of failure-detector.threshold config.
  • Fix race in queueing system which could cause queries to fail with “Entering secondary queue failed”.
  • Fix issue with histogram() that can cause failures or incorrect results when there are more than ten buckets.
  • Optimize execution of cross join.
  • Run Presto server as presto user in RPM init scripts.

Table Properties#

When creating tables with CREATE TABLE or CREATE TABLE AS, you can now add connector specific properties to the new table. For example, when creating a Hive table you can specify the file format. To list all available table, properties, run the following query:

SELECT * FROM system.metadata.table_properties

Hive Changes#

We have implemented INSERT and DELETE for Hive. Both INSERT and CREATE statements support partitioned tables. For example, to create a partitioned table execute the following:

CREATE TABLE orders (
   order_date VARCHAR,
   order_region VARCHAR,
   order_id BIGINT,
   order_info VARCHAR
) WITH (partitioned_by = ARRAY['order_date', 'order_region'])

To DELETE from a Hive table, you must specify a WHERE clause that matches entire partitions. For example, to delete from the above table, execute the following:

DELETE FROM orders
WHERE order_date = '2015-10-15' AND order_region = 'APAC'

Note

Currently, Hive deletion is only supported for partitioned tables. Additionally, partition keys must be of type VARCHAR.