Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Release notes for 307 #493

Closed
6 tasks done
electrum opened this issue Mar 17, 2019 · 12 comments
Closed
6 tasks done

Release notes for 307 #493

electrum opened this issue Mar 17, 2019 · 12 comments
Milestone

Comments

@electrum
Copy link
Member

electrum commented Mar 17, 2019

Dain Sundstrom

  • all checked
  • 03-27 18:35:20 77f6230 Change IpAddressType to use Int128ArrayBlock
  • 03-27 18:35:20 8294fa1 Change LongDecimalType to use Int128ArrayBlock
  • 03-27 18:35:20 89ec222 Remove unused FixedWidthBlock
  • 03-27 18:35:20 b4ce0df Change UnknownType to use ByteArrayBlock
  • 03-27 18:35:20 d19fe23 Change TestingIdType to use LongArrayBlock
  • 03-27 18:35:20 f5e86c4 Add Int128ArrayBlock

David Phillips

  • all checked
  • 03-18 12:32:11 6fb1e46 Skip JDBC rollback when connection is closed
  • 03-18 15:49:23 31dbb2f Pass TableHandle to ConnectorRecordSetProvider
  • 03-18 15:49:23 40d9657 Remove unused TransactionHandle from Split
  • 03-18 15:49:23 70ac2fd Add constant TableHandle for tests
  • 03-18 15:49:23 e2e6fd3 Pass TableHandle to ConnectorPageSourceProvider
  • 03-19 14:32:41 0280384 Convert Local File connector to new RecordSet API
  • 03-19 14:32:41 20436e5 Remove connector ID from system connector
  • 03-19 14:32:41 2c73e44 Convert JDBC connector to new RecordSet API
  • 03-19 14:32:41 2cce432 Convert Cassandra connector to new RecordSet API
  • 03-19 14:32:41 4454071 Remove unused connector ID reference
  • 03-19 14:32:41 4d5f87f Convert Example connector to new RecordSet API
  • 03-19 14:32:41 5084234 Remove connector ID from Redis connector
  • 03-19 14:32:41 6202651 Remove connector ID from Kafka connector
  • 03-19 14:32:41 7edc1b5 Remove connector ID from Example connector
  • 03-19 14:32:41 84370a0 Convert Black Hole connector to new PageSource API
  • 03-19 14:32:41 85f3887 Remove connector ID from Raptor legacy connector
  • 03-19 14:32:41 973227a Convert JMX connector to new RecordSet API
  • 03-19 14:32:41 9acea48 Convert Accumulo connector to new RecordSet API
  • 03-19 14:32:41 b344ae1 Convert system connector to new PageSource API
  • 03-19 14:32:41 c23217d Convert TPCH connector to new RecordSet API
  • 03-19 14:32:41 c6ce2db Fix rendering of Hive table handles in explain plan
  • 03-19 14:32:41 d873a9f Convert TPCDS connector to new RecordSet API
  • 03-19 14:32:41 e5d3708 Convert connectors to new PageSource and RecordSet APIs
  • 03-22 22:02:18 8c87a3d Add seconds to from_unixtime documentation
  • 03-24 01:58:29 4543093 Add safety checks for Hive bucketing version
  • 03-24 02:03:54 fca01af Remove unused code in presto-main
  • 03-26 12:31:06 46b2e77 Update to Hadoop 3.2.0
  • 04-02 11:00:35 dc11eba Rename VarcharsTest to match Surefire naming pattern
  • 04-02 14:21:05 e42dae5 Abort query in batch mode when CLI is killed
  • 04-02 21:42:01 37773dd Allow user and password passthrough in jdbc connector
  • 04-02 21:42:01 9dee791 Add Nullable annotation in BaseJdbcConfig
  • 04-03 11:48:10 5207fb9 Fix the INSTANCE_SIZE of Page

Grzegorz Kokosiński

  • all checked
  • 03-26 01:26:27 bd14140 Push TopN through Project
  • 03-26 01:26:27 ec57ed6 Push TopN through outer Join
  • 03-27 05:14:18 e27b09c Rename ConnectorId to CatalogName
  • 03-28 01:23:20 44b24b9 Rename quote to identifierQoute in QueryBuilder
  • 03-28 01:23:20 d1bec03 Add unit tests for SqlServer
  • 03-28 01:23:20 d5086d7 Fix large IN queries against SqlServer
  • 03-28 01:23:20 fdb71a9 Introduce DockerContainer for testing
  • 03-29 02:33:14 692ff5b Fix potential NPE in JdbcRecordCursor
  • 04-01 00:48:13 377fca0 Add a function to check if aggregation operation produces distinct rows
  • 04-01 00:48:13 79083f7 Remove DISTINCT inside IN subquery expression

Karol Sobczak

  • all checked
  • 03-19 14:32:24 0a1019a Don't update operator memory on every Page produced by page source
  • 03-19 14:32:24 1d3853e Remove redundant if
  • 03-19 14:32:24 3699516 Add WorkProcessor#withProcessStateMonitor
  • 03-19 14:32:24 3af63bc Avoid Optional boxing in WorkProcessor.Transformation#process
  • 03-19 14:32:24 4fff886 When merging pages, look at position count first
  • 03-19 14:32:24 c490a6e Update ScanFilterAndProjectOperator stats cumulatively
  • 03-19 14:32:24 c51e138 Avoid Optional boxing in WorkProcessor states
  • 03-19 14:32:24 c8b3acb Yield before propagating computations
  • 03-19 14:32:24 cf0c31a Base ScanFilterAndProjectOperator on WorkProcessors
  • 03-19 15:12:23 94ef44b User static import for mergePages
  • 03-26 06:49:43 d4c6055 Close spillers in Operator#close() for window and order by spill

Martin Traverso

  • all checked
  • 03-18 09:28:21 d5489bc Add argument comment for StatsCalculator
  • 03-20 19:51:13 b0f4fb6 Clean up duplicate code
  • 03-31 10:25:11 a885617 Fix condition to match exception message
  • 04-01 14:54:50 aba0c3f Remove TableScanNode.getCurrentConstraint()
  • 04-01 14:54:50 d6eaee9 Preserve table layout predicate in tpch connector
  • 04-01 14:54:50 d79fbff Add applyFilter equivalent to Constraint-based table layout selection
  • 04-01 16:24:44 28bb1e9 Fix typo
  • 04-01 16:24:44 73a3e9e Remove unnecessary comment
  • 04-01 16:24:44 79a70d1 Add support for LEFT/RIGHT/FULL/INNER lateral join
  • 04-01 16:24:44 c9d187b Static import TRUE_LITERAL
  • 04-02 11:20:57 20b0a5f Expand support of types handled in EXPLAIN (TYPE IO)
  • 04-03 07:44:01 48e73d9 Implement COMMENT ON TABLE in hive connector
  • 04-03 07:44:01 616d8b9 Support COMMENT ON TABLE statement
  • 04-03 07:44:01 d813133 Add product test for COMMENT ON TABLE statement

Piotr Findeisen

  • all checked
  • 03-18 03:41:32 1eb185a Remove redundant else
  • 03-18 03:41:32 6ac654e Remove misleading return type
  • 03-19 07:12:28 d971e7f Fix typos in presto-docs
  • 03-19 09:35:29 65922a2 Document CREATE/ALTER TABLE as supported in JDBC connectors
  • 03-21 10:52:03 5d2013d Prevent exceptions from CLI tests
  • 03-21 13:38:17 e61ce42 Remove obsolete property documentation
  • 03-23 16:24:01 2aa73c6 Rename io.prestosql.sql.planner.planPrinter package to lowercase
  • 03-23 16:24:01 5c59372 Rename io.prestosql.operator.aggregation.groupByAggregations package
  • 03-23 16:24:01 8f949a7 Rename io.prestosql.connector.informationSchema package to lowercase
  • 03-23 16:24:01 a6fbb35 Rename io.prestosql.failureDetector package to lowercase
  • 03-25 00:59:34 5a75126 Upgrade to airbase 91
  • 03-25 07:11:33 e0dac38 Ignore connector-provided data size for fixed-width types
  • 03-26 02:18:41 892ca81 Fix tests JVM time zone
  • 03-26 22:48:27 2636650 Fix code style
  • 03-26 22:48:27 5c11848 Embed version in SqlQueryExecution
  • 03-28 00:41:08 087054a Do not use historic timestamps in SQL Server tests
  • 03-28 00:41:08 12c1e54 Fix formatting
  • 03-28 00:41:08 9175452 Fix timestamp handling in JDBC connectors
  • 03-28 00:41:08 f2760f4 Rename legacy timestamp mapping functions
  • 03-28 02:09:20 babd98e Remove redundant catch
  • 03-28 02:09:20 e3a5115 Provide message for / by zero exception deterministically
  • 03-28 02:57:50 0df30d1 Upgrade h2database to 1.4.199
  • 03-28 06:35:47 4b6a52d Move @LiteralParameter to SPI
  • 03-28 14:52:27 c57cb19 Secure nextUri with a slug
  • 03-29 05:56:56 c10e0c5 Improve principal pattern in documentation
  • 03-31 13:39:27 73959ac Use temporary redirect to /ui/
  • 04-01 03:05:26 6251f9c Update to Airlift 0.179
  • 04-01 03:09:16 d127b2e Limit amount of native memory used for NIO buffers
@electrum electrum added this to the 307 milestone Mar 17, 2019
@kokosing
Copy link
Member

General changes
--------
 * Optimize queries containing ``ORDER BY`` together with `LIMIT` over an ``OUTER JOIN``, by pushing ``ORDER BY`` and ``LIMIT`` to an outer side of join if possible. (:issue:`419`)

#419

@sopel39
Copy link
Member

sopel39 commented Mar 26, 2019

General changes
---------------
* Improve performance of table scans for data sources that produce tiny pages. (:issue: `467`)

#467

@sopel39
Copy link
Member

sopel39 commented Mar 26, 2019

General changes
---------------
* Fix spill files leaks in window and order by operator. (:issue: `543`)

#543

@findepi
Copy link
Member

findepi commented Mar 28, 2019

MySQL, PostgreSQL, SQL Server, Redshift & Base-JDBC Connector Library Changes
---
* Fix reading and writing of ``timestamp`` values. Previously, incorrect value would be read unless
  Presto JVM is a certain time zone. (:issue:`495`)

#495

@kokosing
Copy link
Member

kokosing commented Apr 1, 2019

General changes
---------------
* Remove distinct aggregation from the IN subquery expression (optimization) (:issue:`551`)

#551

@findepi
Copy link
Member

findepi commented Apr 1, 2019

* Fix Web UI crash when opened as ``http://coordinator:port/ui``. (:issue:`500`)

#539

@findepi
Copy link
Member

findepi commented Apr 1, 2019

Server RPM Changes

* Prevent JVM from allocating large amounts of native memory. The new configuration is applied
  automatically when Presto is installed from RPM. When Presto is installed without RPM, or when
  you provide your own ``jvm.config``, we recommend to add the following to your ``jvm.config``:
  ``-Djdk.nio.maxCachedBufferSize=2000000``. See :doc:`/installation/deployment` for details.
  (:issue:`542`) 

#542

@martint
Copy link
Member

martint commented Apr 1, 2019

* Add support for simple constraint pushdown into connectors via the ``ConnectorMetadata.applyFilter()`` method. (:issue:`541`)

#541

@martint
Copy link
Member

martint commented Apr 1, 2019

* Add support for outer joins involving lateral derived tables (i.e., ``LATERAL``). (:issue:`390`)

#390

@martint
Copy link
Member

martint commented Apr 2, 2019

* Expand support of types handled in ``EXPLAIN (TYPE IO)``. (:issue:`509`)

#509

@martint
Copy link
Member

martint commented Apr 3, 2019

* Add support for setting table comments via the :doc:`/sql/comment` syntax. (:issue:`200`)

#200

@dain
Copy link
Member

dain commented Apr 3, 2019

* Changed ``LongDecimalType and ``IpAddressType`` to use ``Int128ArrayBlock``. Connectors building blocks directly, should update to the new APIs.

@dain dain closed this as completed Apr 11, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Development

No branches or pull requests

6 participants