{"action":"published","release":{"url":"https://api.github.com/repos/geraint0923/presto/releases/4157562","assets_url":"https://api.github.com/repos/geraint0923/presto/releases/4157562/assets","upload_url":"https://uploads.github.com/repos/geraint0923/presto/releases/4157562/assets{?name,label}","html_url":"https://github.com/geraint0923/presto/releases/tag/0.75","id":4157562,"tag_name":"0.75","target_commitish":"master","name":"0.75","draft":false,"author":{"login":"geraint0923","id":923382,"avatar_url":"https://avatars.githubusercontent.com/u/923382?v=3","gravatar_id":"","url":"https://api.github.com/users/geraint0923","html_url":"https://github.com/geraint0923","followers_url":"https://api.github.com/users/geraint0923/followers","following_url":"https://api.github.com/users/geraint0923/following{/other_user}","gists_url":"https://api.github.com/users/geraint0923/gists{/gist_id}","starred_url":"https://api.github.com/users/geraint0923/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/geraint0923/subscriptions","organizations_url":"https://api.github.com/users/geraint0923/orgs","repos_url":"https://api.github.com/users/geraint0923/repos","events_url":"https://api.github.com/users/geraint0923/events{/privacy}","received_events_url":"https://api.github.com/users/geraint0923/received_events","type":"User","site_admin":false},"prerelease":false,"created_at":"2014-08-21T22:33:18Z","published_at":"2016-09-17T00:22:33Z","assets":[],"tarball_url":"https://api.github.com/repos/geraint0923/presto/tarball/0.75","zipball_url":"https://api.github.com/repos/geraint0923/presto/zipball/0.75","body":"Hive Changes\n============\n\n-   The Hive S3 file system has a new configuration option, `hive.s3.max-connections`, which sets the maximum number of connections to S3. The default has been increased from `50` to `500`.\n-   The Hive connector now supports renaming tables. By default, this feature is not enabled. To enable it, set `hive.allow-rename-table=true` in your Hive catalog properties file.\n\nGeneral Changes\n===============\n\n-   Optimize count with a constant to execute as the much faster `count(*)`\n-   Add support for binary types to the JDBC driver\n-   The legacy byte code compiler has been removed\n-   New aggregation framework (~10% faster)\n-   Added max\\_by aggregation function\n-   The `approx_avg()` function has been removed. Use avg instead.\n-   Fixed parsing of `UNION` queries that use both `DISTINCT` and `ALL`\n-   Fixed cross join planning error for certain query shapes\n-   Added hex and base64 conversion functions for varbinary\n-   Fix the `LIKE` operator to correctly match against values that contain multiple lines. Previously, it would stop matching at the first newline.\n-   Add support for renaming tables using the /sql/alter-table statement.\n-   Add basic support for inserting data using the /sql/insert statement. This is currently only supported for the Raptor connector.\n\nJSON Function Changes\n=====================\n\nThe json\\_extract and json\\_extract\\_scalar functions now support the square bracket syntax:\n\n    SELECT json_extract(json, '$.store[book]');\n    SELECT json_extract(json, '$.store[\"book name\"]');\n\nAs part of this change, the set of characters allowed in a non-bracketed path segment has been restricted to alphanumeric, underscores and colons. Additionally, colons cannot be used in a un-quoted bracketed path segment. Use the new bracket syntax with quotes to match elements that contain special characters.\n\nScheduler Changes\n=================\n\nThe scheduler now assigns splits to a node based on the current load on the node across all queries. Previously, the scheduler load balanced splits across nodes on a per query level. Every node can have `node-scheduler.max-splits-per-node` splits scheduled on it. To avoid starvation of small queries, when the node already has the maximum allowable splits, every task can schedule at most `node-scheduler.max-pending-splits-per-node-per-task` splits on the node.\n\nRow Number Optimizations\n========================\n\nQueries that use the row\\_number function are substantially faster and can run on larger result sets for two types of queries.\n\nPerforming a partitioned limit that choses `N` arbitrary rows per partition is a streaming operation. The following query selects five arbitrary rows from `orders` for each `orderstatus`:\n\n    SELECT * FROM (\n        SELECT row_number() OVER (PARTITION BY orderstatus) AS rn,\n            custkey, orderdate, orderstatus\n        FROM orders\n    ) WHERE rn <= 5;\n\nPerforming a partitioned top-N that chooses the maximum or minimum `N` rows from each partition now uses significantly less memory. The following query selects the five oldest rows based on `orderdate` from `orders` for each `orderstatus`:\n\n    SELECT * FROM (\n        SELECT row_number() OVER (PARTITION BY orderstatus ORDER BY orderdate) AS rn,\n            custkey, orderdate, orderstatus\n        FROM orders\n    ) WHERE rn <= 5;\n\nUse the /sql/explain statement to see if any of these optimizations have been applied to your query.\n\nSPI Changes\n===========\n\nThe core Presto engine no longer automatically adds a column for `count(*)` queries. Instead, the `RecordCursorProvider` will receive an empty list of column handles.\n\nThe `Type` and `Block` APIs have gone through a major refactoring in this release. The main focus of the refactoring was to consolidate all type specific encoding logic in the type itself, which makes types much easier to implement. You should consider `Type` and `Block` to be a beta API as we expect further changes in the near future.\n\nTo simplify the API, `ConnectorOutputHandleResolver` has been merged into `ConnectorHandleResolver`. Additionally, `ConnectorHandleResolver`, `ConnectorRecordSinkProvider` and `ConnectorMetadata` were modified to support inserts.\n\n> **note**\n>\n> This is a backwards incompatible change with the previous connector and  \n> type SPI, so if you have written a connector or type, you will need to update your code before deploying this release. In particular, make sure your connector can handle an empty column handles list (this can be verified by running `SELECT count(*)` on a table from your connector).\n>\n"}}
{"actor":{"display_login":"geraint0923"}}