12.139. 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 theDatabaseMetaData.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.