20.137. Release 0.123
Fixed query failures that occur when the
optimizer.optimize-hash-generationconfig is disabled.
Fix exception when using the
ResultSetreturned from the
DatabaseMetaData.getColumnsmethod in the JDBC driver.
Increase default value of
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
prestouser in RPM init scripts.
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
We have implemented
DELETE for Hive. Both
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'])
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'
Currently, Hive deletion is only supported for partitioned tables. Additionally, partition keys must be of type VARCHAR.