Release 0.123#
General#
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#
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.