This article was originally published on May 26, 2022
WHAT’S NEW
This announcement is notifying you of new software releases of the EDB Foreign Data Wrappers for Hadoop, MongoDB, and MySQL. These foreign Data Wrappers allow EDB Postgres Advanced Server to connect to Hadoop, MongoDB, and MySQL servers enabling you to view, join and manage data holistically.
Highlights of this release include:
Hadoop FDW 2.2.0
|
Type |
Highlights |
|
New Feature |
Push down aggregates to remote HDFS servers. Push aggregates to the remote HDFS server instead of fetching all of the rows and aggregating them locally. This gives a performance boost for cases where aggregates can be pushed down. |
|
Enhancement |
Add support for NUMERIC data type. |
For further information including bug fixes or changes, please refer to the Release Notes.
MongoDB FDW 5.4.0
|
Type |
Highlights |
|
New Feature |
Push down aggregates to remote MongoDB servers. Push aggregates to the remote MongoDB server instead of fetching all of the rows and aggregating them locally. This gives a very good performance boost for the cases where aggregates can be pushed down. |
|
Enhancement |
Add a new server option use_remote_estimate to estimate the rows. |
For further information including bug fixes or changes, please refer to the Release Notes.
MySQL FDW 2.8.0
|
Type |
Highlights |
|
New Feature |
Push down ORDER BY to remote MySQL servers. When possible, considers a path that adds the ORDER BY clause to the remote SQL to get an ordered result set from the foreign server. This helps with an efficient merge join. |
|
New Feature |
Push down LIMIT/OFFSET to remote MySQL servers. |
|
Enhancement |
Add character_set option. Users can now set it to an appropriate value per MySQL database. |
|
Enhancement |
Add sql_mode option. MySQL server can operate in different SQL modes, this option allows it to match that up. |
For further information including bug fixes or changes, please refer to the Release Notes.
TELL ME MORE
For more details, please review the Foreign Data Wrappers documentation:
Hadoop FDW: https://www.enterprisedb.com/docs/hadoop_data_adapter/latest/
MongoDB FDW : https://www.enterprisedb.com/docs/mongo_data_adapter/latest/
MySQL FDW : https://www.enterprisedb.com/docs/mysql_data_adapter/latest/
Deprecation notice:
We recommend you update to the most recent software version. If you have not yet updated to the most current version, please note the end-of-support notes below*:
- Is Deprecated: FDWs for EDB Postgres Advanced Server 9.6
- Version: 9.6
- End of Standard Support: February, 2022
IS THIS FOR ME?
This announcement is for EDB customers who are using, or are interested in EDB Postgres Foreign Data Wrappers and have a subscription plan purchased for:
- Community 360
- Standard
- Enterprise
HOW TO GET THE SOFTWARE
Foreign Data Wrappers for EDB Postgres Advanced Server are available as native packages in the form of RPMs and DEBs, please visit EDB Repos.
To request the credentials required to access EDB repositories, please visit Create new account.
TROUBLESHOOTING
If you experience any problems around the installation, migration, upgrade or general use of your EDB software, please contact our Technical Support teams. Customers may reach us at https://techsupport.enterprisedb.com, and we're also available 24x7 via email and phone at the details below:
Customer Support Email: techsupport@enterprisedb.comTrial Use Assistance: trial-help@enterprisedb.com
US +1-732-331-1320 / 1-800-235-5891
UK +44-2033719820
Brazil +55-2139581371
India +91-20-66449612